Share feedback

<p>We are aware of intermittent issues in accessing the learning content</p>

We are aware of intermittent issues in accessing the learning content

Track your progress, save content and access your certifications — all in one place.

Log in or create a free account.

Why create an SAP account?

Enhance your learning experience

SAP Learning

Choose your subscription

Manage your subscription

Activate your subscription

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

This browser is not supported

Show more

Ooops, something went wrong!

Oh no! Tell us how we can improve.

Great! We value your feedback

Thank you!

Browse by capability

Please wait

Unfortunately there is a technical problem preventing us from checking your exam attempt status. Please try again later.

Unable to check your exam status

Please try again later

Sorry, we encountered an error

Try again or reset results to continue browsing

We didn't find what you're looking for

To continue, please log in

Your session has timed out

Validate your skills and learning by completing the certification exam and gain a highly recognised accreditation.

Book your certification exam

Complete the assessment to validate your SAP PartnerEdge competency qualifications.

Ready to take your assessment?

Learn about the key features and essentials in the latest release to help you prepare for the Stay Certified assessment.

Prepare for assessment

Learn new skills you need at your own pace with our bite-sized lessons.

Prepare for certification

In your My Learning account you can view your certification and learn how to take your Stay Certified assessment.

Ready to take your Stay Certified assessment?

Turn it into a podcast, summary, mind map, or interactive study guide – and get AI answers on any topic as you go.

Learn this course your way

Get tailored answers, tune into podcasts, and dive deeper with interactive study guides, mind maps, FAQs and more.

Upskill faster with AI-powered assistance

Upgrade to AI-powered learning

Enroll in Gemini Notebook to flexibly interact with SAP Learning content. It's free and activates instantly.

You are all set. Gemini Notebook is now active. You will have access to AI powered learning for all our eligible courses.

Enrollment successful!

Get started with AI-powered learning

Stay Certified Assessment/s Pending

Explore {title} at SAP Learning. Find out more!

You have earned a new badge!

You've completed

Something went wrong when connecting to the badge service. You can always check your achievements in My Learning.

Badge couldn't be issued

You've finished the course, but the external system didn't verify it. Please try again later or refresh the page to update your record.

We couldn't confirm your completion

The learning content has been updated. Refresh the page to reload the most recent content.

Your course content has changed

This badge was already awarded earlier, so no new one is added. You can view it anytime in My Learning.

You've already earned this badge

We couldn't finish your request due to an unexpected error. Please refresh the page and try again. If the issue continues, check My Learning or try again later.

Something went wrong...

The saved progress data isn't valid, so we couldn't update your course status. Please try again later or refresh the page.

We couldn't load your progress

About this course

Learn

Prove your knowledge and earn a badge that validates your expertise.

Earn a badge

Complete this section to get all the required knowledge.

Enable notifications to get notified when the new content is released

More units will appear here

Join scheduled live courses led by experienced SAP trainers.

Learn with an instructor

Other ways to learn

This certification is no longer offered. To check your certification details click on Go to My Learning.

This certification is retired

Visit My Learning to check your status and schedule your assessment. You can also watch <link>Certification Support videos</link> to guide you through the process.

Ready to renew? It's time to take your Stay Certified assessment

This certification has expired and cannot be renewed. You can explore recommended alternatives in the <link>SAP Certification portfolio</link> or visit My Learning for status updates.

This certification has been retired and is no longer active

Visit My Learning to see if you have attempts left to retake. For more details, see our guide: <link>How to Get Certified with SAP Certification</link>.

Unfortunately, you didn't pass the assessment this time

You certification is current. View details anytime in My Learning.

Your certification is up to date

Supplementary resources

Quiz

Congratulations on completing this {objType}

Subscribe to be informed about updates to this learning journey. We will inform you when a new unit is available.

Get notified

Assessment

Course Completion

Knowledge Badge

Overview

Support Resource

Certification Exam

Theoretical Exam

Schedule

Stay Certified

External Course

AI Roleplay

Practical Exercise

Practical Test

External Hands-On

External Resource

Learning Journey

Learning Journey Assessment

Lesson

Live Session

Practice System

Hands-on Practice for {title}

Scenario Based Assessment

Course Assessment

Course

SAP Expert Lectures

Subscription

System Based Assessment

Unit

Video

Video Playlist

Week

Appears in

Badge earned

Badge you can earn

Apply this learning through concrete examples such as demos for customer engagements.

Experience Journey

Learning outcome

Toggle full description

Prerequisites

Roles, products and skills

Want to remove this from your Learning List?

You have until July 30, 2026 to complete your Stay certified assessment.

Your SAP Certification extension is now active!

Please log out and log back in. If the issue persists after waiting a moment, please reach out to Support.

An error occurred during log in

Your exclusive access to the SAP Learning Hub, event edition is ready. <link>Start learning now.</link>

Access activated

Your free Joule Studio Certification voucher is now available. <link>Prepare for your exam</link>

Free voucher activated

Something went wrong while activating your free Certification voucher. Try again.

Free voucher couldn't be activated

You can now register for free Live Sessions.

cleanFiles/BOAN10_en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2025-11-13T03:12:53.000Z

Listing Analysis for Office Data Sources

Launching Analysis for Excel

Connecting to an SAP System

Inserting a Data Source

Getting Started with SAP Analysis for Excel

Analyzing Data

Saving a Workbook

Changing Data Displays

Sorting Data

Filtering Data

Creating Measure Calculations

Working with Hierarchies

Working with Variables/Prompts

Adding Comments

Analyzing Data in Analysis for Excel

Setting Analysis Preferences

Using the Design Panel Components Tab to Set Properties

Setting Preferences

Using SAP Formula Functions

Linking Dimensions

Grouping Crosstabs

Enhancing a Worksheet

Adding Design Components to a Worksheet

Defining and Using Conditional Formatting

Adding New Rows/Columns to a Crosstab

Customizing Crosstab Formatting Styles

Creating a Default Workbook

Formatting a Worksheet

Discovering SAP Analysis for Microsoft Office

<p>This course explains the analysis functions and layout design options of SAP Analysis for Microsoft Office through demonstrations and exercise simulations.</p>