SAP Analysis for Office Training Course

This one day instructor led course provides delegates with the technical skills required to implement and use the SAP Analysis for Office software.

SAP Analysis for Office

This one day instructor led course provides delegates with the technical skills required to implement and use the SAP Analysis for Office software.

  • Duration: 1 Day
  • Dates: Please select

Goals

• Learn the basic functions and navigation options of Analysis, edition for Microsoft Office
• Learn the special functions and layout design options of Analysis, edition for Microsoft Office

Audience

The course is intended for business intelligence developers and analysts who may need to use the power of Analysis for Office as part of their Business Intelligence solution.

Locations

  • London
  • Warwick
  • Glasgow
  • Onsite at Your Office
  • Virtual

Content

In more than 15 exercises, you will learn the complete functional scope of Analysis 1.1, edition for Microsoft Office.

Basic Functions

• Navigation within the Design Panel
• Working with hierarchies, conditional formatting and filter on measures
• Use of formulas
• Integrating dynamic text elements, charts and filter elements
• Creation of PowerPoint slides from Excel

Special Functions

• Working with styles
• Creation of layout elements (e.g.; dropdown boxes) in combination with VBA to control variables and filter values
• Combination of multiple functions into one action
• Advanced scenarios for formula usage


Contact
Contact

For any questions please feel free to contact us.