Power Pivot Excel 2010

This online course will enable learners to use this new Excel add in to analyze thousands of rows of data and use DAX functions

PowerPivot for the Excel user is an online Microsoft Power Pivot Course, written by an Accountant, focusing on beginner to advanced Power Pivot and Dax. This course has been designed for Accounting and Finance professionals who what to develop their MS Excel skill far beyond a basic level.
This online course will enable learners to use this new Excel add in to analyze data and speed up tasks
What Will Students Learn and what Topics are Covered?
Import Data from different sources
Work with Tables, relationships and columns
Insert pivot tables, charts and slicers
Understand and calculate measures

X Functions And Countrows
Related and Related tables functions
Filter and Distinct
Calculate function
Time Intelligence
What’s Included? Instruction by an expert
12 months access 24/7
How long will it take and how much does it cost?
Completion Time 5 Hours
Cost €125 + VAT

Intended Audience: Accountants

1.2 install powerpivot.mp4
1.3 import data from access.mp4
1.4 import custom query.mp4
1.5 import from excel.mp4
1.6 importing text files.mp4
1.7 saving your first powerpivot workbook.mp4
1.8 chapter 1 review.mp4
Section 1 downloads
2.1 working with tables.mp4
2.2 relationships.mp4
2.3 calcualted columns.mp4
2.4 insert pivot table.mp4
2.5 insert pivot charts.mp4
2.6 slicers.mp4
2.7 chapter review.mp4
Section 2 download
3.1 understanding measures.mp4
3.2 creating measures.mp4
3.3 measures.mp4
Section 3 download
4 DAX Introduction
4.1 xfunctions and countrows.mp4
4.3 related and related table.mp4
4.4 filter and distinct.mp4
4.5 calculate.mp4
4.6 dax.mp4
Section 4 download
5.1 time intelligance 1.mp4
5.2 time intellagance 2.mp4
5.3 time intelligance.mp4
Section 5 download

What's included

  • 26 Video Lessons
  • 5 Text Lessons

  • Works on all devices
  • Certificate of completion

Paula Guilfoyle


My Name is Paula, and I am a qualified CPA with over 15 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now author and presenter of many online courses and can boast that I have thought over 10,000 students!

In addition to being an Accountant and an Online Educators I am also a wife and a mother of two, my youngest is 2 and eldest is 7. I currently work as an Accountant for a global company, which makes family life very very busy. I am always stuck for time, and finding a balance is very difficult. I’m sure all working parents understand the pressures involved.