Powerpivot Excel 2013 - Power Pivot

This intense and practical training course will provide delegates with a comprehensive understanding of Excel. The course will explore the stages of creating a KPIKPIs with absolute targets

Pre-Requisites

• There are no pre-requisites needed prior to attending this course

Who should attend?

• This course is suitable for those who need to use PowerPivot for Excel

What will you learn?

• Once you have completed PowerPivot for Excel Course you will understand:
• Connecting to SQL ServerFiltering rows and columns
• The EARLIER function
• Semi-additive measures
• Creating the measures needed
• Using in pivot tables

Course Outline

• Changing a table after import
• Creating a data model
• Hiding columns and tables
• Renaming columns and tables
• Diagram view
• Manually creating
• Pivot tables
• Creating pivot tables
• Sorting pivot tables
• Connecting to Excel
• Creating Excel tables
• Linking to Excel tables
• Connecting to other data
• Linking to Access
• Pasting tables
• Creating aggregation measures
• The FILTER function
• The CALCULATE function
• ALL and ALLEXCEPT
• Creating a calendar
• Date calculations
• Working days
• Period to date
• Prior and parallel year
• Hierarchies
• Creating a hierarchy
• Three parts of a KPI