Installation and Configuration Installation and Checks Authorizations Shortcut Properties Customize Analysis Office Options Technical Configuration Customize User Interface Company and Embedded Profile Basic Functionality The Analysis Office Addin The Ribbon menu Your first Crosstab Open and Save a workbook Different context menus Sorting your data Filter your data by member Filter your data within hierarchies Filter your data directly on the Crosstab Filter your data via background filter Filter your data by measure Use BEx Conditions in Analysis Office Ranking Access mode for filtering Prompting and Variables Allowed and forbidden areas Swap Axes Charts How to use Infofields Totals How to display Members Number Format/Currency Conversion/Scaling Factor/Zeros and Negative Values Creating New Cells Format Cells Crosstab Configuration Styles How to use Conditional Formatting Advanced Functions Hierarchies SAP Excel Formulas Use Standard Calculations How to use Dynamic Calculations Create Advanced Calculations Create Restrictions Work with Query Views Use the Filter Panel Creating PowerPoint Slides Use Excel Formulas in your Crosstab Report-Report-Interface Prompt Variants Contains Pattern Convert to formula Create a Web Application Launch the Query Designer Use Smart Copy and Paste Group your Crosstab and Link Dimensions Build Hierarchies on the fly Work with the formula-optimized mode Create a default workbook Reporting with Analysis Office API and VBA Overview Information Working
