Microsoft Excel Power Pivot
Business intelligence and data analysis made easy with Excel Power Pivot
PowerPivot is the most important new feature in Excel in over 20 years. PowerPivot is a powerful columnar database which allows the Excel user to easily work with millions of records of data, create relationships between tables and easily create key metrics and measurements. Working with PivotTables and Power View the Excel user is able to develop powerful reports, analysis and dashboards.
• Analyse more than one million rows of data
• Load data into PowerPivot
• Filter data with slicers
• Easily create relationships between tables of data
• Create easy to use Dashboard view from PowerPivot
• Learn the principles of the DAX formula language to create powerful new calculations
• Create powerful new DAX measures in PivotTables such as year-to-date, month-to-date, previous month, etc.
• Create dashboards with PowerPivot data
Time: 08:00 - 16:00
Venue: Henley Business School, Johannesburg, Sandton
Cost: R1,450 including VAT
More info:
Henley Business School is conveniently situated just off the Rivonia Road off-ramp
