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

Course Summary

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 Dax	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

Course Curriculum

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

Paula Guilfoyle

After over 10 years in Accounting and Operations Paula turned her career to subject matter expert, consultant, content creation and online education. In 2010 Paula began teaching online and can now boast over 250K students in 186 different countries. In 2016 Paula began her learning journey around Blockchain and Cryptocurrency. By 2022 Paula pivoted her consultancy, content creation and online education to focus on Blockchain, Web3 and Digital Assets.

John Smith

Developer

Highly Recommended Course. Easy to Understand, Informative, Very Well Organized. The Course is Full of Practical and Valuable for Anyone who wants to Enhance their Skills. Really Enjoyed it. Thank you!!

Course Summary

Course Curriculum

Section 1

Section 2

Section 3

Section 4

Section 5

Paula Guilfoyle

John Smith

Highly Recommended Course. Easy to Understand, Informative, Very Well Organized. The Course is Full of Practical and Valuable for Anyone who wants to Enhance their Skills. Really Enjoyed it. Thank you!!

Course Pricing

One time payment