The Microsoft Excel Power Pivot Online Course introduces you to the power of the Excel add-in called Power Pivot. Power Pivot comes with Excel and is a game changer when you want to create pivot tables based on more than one table or source. Power Pivot uses Power Query to connect to a variety of data sources and then creates a data model, transforms data and presents the data with powerful measures and pivot tables based on a data model. It includes power KPI visuals, charts and slicers. This course includes best practices and loads of shortcuts and tips to make using Excel actually enjoyable.
The online course includes videos that you can watch and rewind to learn techniques, step-by-step instructions to follow, and loads of exercises and quizzes to reinforce your learning. The course comes with a tutor who you can call, email or meet via MS Teams if you need that extra bit of support.
At the completion of the course, you will be issued with a Certificate of Completion.
Register and join us today!
Comprehensive coverage of:
- connect to data
- create a data model
- transform data
- calculated columns
- measures and DAX language
- pivot tables based on a data model
- slicers and charts
- and more
This Online Course is ideal, if you struggle to find time to attend a course, and you want to learn in the privacy of your own home, during the hours that you find the most convenient. Learn at your own speed and in your own time and don't deal with the pressure of trying to learn in a group classroom setting. Your online classroom does not expire, so you can take your time and you have access to your own personal tutor via phone, email or MS Teams.
With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
Microsoft Excel - Power Pivot Online Course (Level 5)
Power Query Level 4, is not a pre-requisite but is an advantage for this course. An understanding of formulas and functions, working with large sets of data, pivoting data and manipulating data is required.