These practical 1 day PowerPivot training courses lead delegates through Excel’s new PowerPivot features (Excel 2010 and Excel 2013), explaining where you would use PowerPivot, how it differs from Pivot Tables and what the benefits are with practical examples.
NEW: Online version of this live PowerPivot course– ideal for individuals
Some of the benefits of knowing PowerPivot include:
- No additional software, it is business intelligence built into the Excel you already have so you can sweat your software assets
- Easily link to multiple sources of information and pull them into a single database i.e. Excel files, text files, SQL files, Access databases and more into a single report
- Establish relationships between your databases, so no more time and space consuming VLOOKUP’s
- Handle more data- 100 million rows is possible
- Build live dashboards and re use them every month
- Clean your data on import and not as a separate exercise
- New formula allow for more options then traditional pivot tables
In order to do this course we recommend a skill level of >3.5, some knowledge of traditional pivot tables, and a version of Excel that has the PowerPivot feature (we offer a free Skills Assessment to make sure you get the correct level of training).
Introduction to PowerPivot
Comparison to traditional pivot tables
Using PowerPivot for the first time
- Loading data from various data sources- excel, access, text, MS query etc
- Cleaning data directly on import
Creating a relationship between tables
- Comparison to a VLOOKUP type method used in Excel
- Benefits of this method
The Date Table
- What is it?
- Why is it important in comparison to Excel’s normal methods
Using formula in PowerPivot
- Excel formula that work in PowerPivot (so nothing new to learn)
- Excel formula that DON’t work in Powerpivot and how you achieve the same thing
- New PowerPivot formulas for comparing to prior periods, budgets and more
Tips, tricks and problem solving in PowerPivot
- Similarity to pivot tables
- Differences and enhancements
- Pivot Charts
- Pivot View
Feedback & Who Should Attend
- This was by far the most comprehensive and beneficial Excel training I have received while at Pick n Pay.- James H
- They [the delegates] found the trainer far superior in knowledge and lecturing style to those that we have previously experienced.- James H
- I enjoyed the overall course, the course director was always spot on and helpful at all times. I wish he was the one that taught me vba. Some of the parts i enjoyed the most were creating links(wow),dax measures and the importing data exercises. Mpho M.
- The way Power Pivot was presented was simple enough and by the end I had a good understanding of how it can help me do my job better. It served as a good foundation and introduction to Power Pivot and the exercises helped cement the concepts as you could apply them practically. All in all a great course! Susan B
Anyone who is, or needs to, work with databases or large datasets to identify trends, generate reports, perform data analytics or has business intelligence type functions. This includes:
- Business owners, managers, financial managers, directors, bookkeepers, marketers, HR managers and anyone who deals with databases in their work related tasks.
- Sales representatives, sales managers, sales executives or team leaders who need to learn how to manage large databases
- All persons using, or wanting to use Excel to interrogate their data
- All persons involved in the construction and use of databases, including budgets, projections, evaluations, cash flows, projects, etc.
Pre Requisite (s)
Excel knowledge required:
- At least an intermediate knowledge of Excel
- Knowledge of Pivot Tables would be beneficial but is not critical
- Pre Installed version of PowerPivot that you have successfully loaded.