Looking to expand your SAP knowledge using trusted resources? Our Discovering SAP Analysis for Microsoft Office (BOAN10), latest book from SAP Learning Hub, is your key to mastering SAP systems and processes. Perfect for students, professionals, and SAP enthusiasts, this book provides verified content straight from the source.
Unit 1: Getting Started with SAP Analysis for Excel
Lesson: Listing Analysis for Office Data Sources
Lesson: Launching Analysis for Excel
Lesson: Connecting to a SAP system
Lesson: Inserting a data source
Unit 2: Analyzing Data in Analysis for Excel
Lesson: Analyzing Data
Lesson: Saving and Scheduling a Workbook
Lesson: Changing Data Displays
Lesson: Working with Analysis Views
Lesson: Sorting Data
Lesson: Filtering Data
Lesson: Creating Measure Calculations
Lesson: Working with Hierarchies
Lesson: Working with Variables/Prompts
Lesson: Adding Comments
Unit 3: Setting Preferences
Lesson: Setting Analysis preferences
Lesson: Using the design panel Components tab to set properties
Unit 4: Enhancing a Worksheet
Lesson: Using SAP formula functions
Lesson: Linking dimensions
Lesson: Grouping crosstabs
Unit 5: Formatting a Worksheet
Lesson: Adding design components to a worksheet
Lesson: Defining and using conditional formatting
Lesson: Adding new rows/columns to a crosstab
Lesson: Customize crosstab formatting styles
Lesson: Creating a default workbook
Unit 6: Using Analysis for PowerPoint
Lesson: Using Analysis for PowerPoint