In QA's Microsoft Excel 2010 Level 2 course, we show you how to create and manage PivotTables, Slicers and PivotCharts: some of Excel's most powerful features for analysing data. This course takes PivotTables to the next level, teaching you how to use PowerPivot: a free add-in available only for Microsoft Excel 2010. PowerPivot links in with PivotTables, however the data used, can be manipulated and managed as though you were using a Relational Database (such as SQL or Access).
Please Note: PowerPivot will not work on Microsoft Excel 2003 or 2007, it is solely designed for Microsoft Excel 2010.
At the end of this course you will be able to:
This course is designed for intermediate/advanced Microsoft Excel professionals who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation. They will have a need to create PivotTables on a regular basis and to produce reports with multiple PivotTables/PivotCharts to produce 'Business Intelligent' type dashboard reports.
To ensure your success, we recommend the following courses have been undertaken, or equivalent knowledge gained:
Microsoft Office Excel 2010: Level 2
If you attend a course and do not meet the prerequisites, or your organisation does not use Microsoft Excel 2010, you may be asked to leave.
Module 1 - PivotTable Review
Module 2 - Introduction to PowerPivot
Module 3 - Connecting to Single Table Data Sources
Module 4 - Working with Multiple Table Data Sources
Module 5 - The Diagram View
Module 6 - Measures, Calculations and KPIs
Module 7 - Working with DAX (Data Analysis Expressions)
Module 8 - Working with Slicers
QA reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.
|Teaching mode:||Classroom - Instructor Led|
We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.
Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.