43
Download Workbooks - 1. IMPORT/LOAD DATA
Download Workbooks - 2. TABLE RELATIONSHIPS
Download Workbooks - 3. PIVOT TABLES & SLICERS
Download Workbooks - 4. MEASURES & CALCULATED COLUMNS
Power Pivot Cheat Sheet
Power Pivot Cheat Sheet
[JULY 2018 UPDATE] Power Pivot is now available in all versions of Excel
Installing Power Pivot in Excel 2010
Download Link for Power Pivot in Excel 2010
Enabling Power Pivot in Excel 2013, 2016, 2019 and Office 365
Import From Workbook
Import From Worksheet
Import From Separate Workbooks
Create Relationships
Create Relationships via the Diagram View
Create a Pivot Table
Insert a Slicer
Intro to DAX Formulas
Intro to DAX Formulas: Measures vs Calculated Columns - Part 1
Intro to DAX Formulas: Measures vs Calculated Columns - Part 2
DAX Syntax
Date and Time Functions
Time Intelligence Functions
Filter Functions
Information Functions
Logical Functions
Math and Trig Functions
Statistical Functions
Text Functions
Other Functions
DISTINCTCOUNT() - Create a "Unique Order Dates" Measure
SUM() - Create a "Total Sales" Measure
Combine 2 Measures to get "Average Sales Per Date"
CALCULATE() - Filter & Show Individual Product Sales
CALCULATE() - Show Largest Sales Values
Calculated Column - Extract Years from Order Date
CALCULATE() - Group Years
Link a Calendar Table
Sort Month Dates Into The Correct Order
Add a Hierarchy to the Calendar
Combine a Calculated Column with a Measure - Net Profit Analysis
[Quiz] - Advanced - Power Pivot
Unlock your Certificate of Completion

But Don’t Just Take Our Word For It

Thousands of managers, accountants, finance analysts, administrators, CFOs and other corporate professionals, trust MyExcelOnline to enhance their professional development and every day.

Some of our course students work at...

Save with our Courses Bundles!

Intro to Excel Bundle

An introduction to Microsoft Excel to get you up to speed and confident using the most common features!

  • Introduction to Excel
  • Formulas
  • Formatting
  • Charts
  • Printing
  • 5 Hours | 56 Lectures | Beginner Level | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Intermediate Excel Bundle

Learn the must know Microsoft Excel features to elevate your Excel level!

  • Formulas
  • Pivot Tables
  • Macros & VBA
  • Data & Analysis
  • Charts
  • 11 Hours | 216 Lectures | Intermediate Level | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Advanced Excel Bundle

Learn the must know Microsoft Excel features to advance your Excel level!

  • Formulas
  • Pivot Tables
  • Macros & VBA
  • Power Query
  • Power Pivot
  • Power BI
  • Excel Dashboards
  • Financial Modeling
  • Charts
  • 40 Hours | 569 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Microsoft Office Bundle

Learn the must know Microsoft Office applications to make you more productive at work!

  • Outlook
  • PowerPoint
  • Word
  • Teams
  • OneNote
  • Access
  • Power Automate
  • Power Apps
  • Project
  • SharePoint
  • Visio
  • Forms
  • 14 Hours | 291 Lectures | All Levels | Certificate of Completion | 24x7 Support | Lifetime Access

Learn More

Frequently Asked Questions

  • You're starting to learn Microsoft Excel late in life or you've been using it for decades, you're a manager, accountant, finance analyst, administrator, CFO or any other corporate professional, and have wondered how to get an advantage over your colleagues or peers.
  • You're preparing for job interviews, wishing for a quicker way to become confident at Excel, so you’ll have a greater chance of landing a job!
  • You often search on Google and YouTube to find answers to your Excel problems. Wishing for a more comprehensive, reliable, and up-to-date source of answers with quick support whenever you get stuck.
  • You spend hours each month running reports and analyzing data. Wondering if there’s a better, more efficient way of doing things, so you can save hours from your busy schedule and go home early to your loved ones.
  • You’ve been given new data handling, analysis, and reporting responsibilities with little or no Excel training.

Anyone who wants to elevate their Excel knowledge & skills, including…

  • New users, beginners, intermediates and advanced Excel users.
  • Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and reporting.
  • People who want to change careers and apply for a new job that requires knowledge of Microsoft Excel
  • If you want to dramatically reduce repetition, stress, and overtime and exponentially increase your chances of a promotion, pay raise or new job!
  • It doesn’t matter if you are completely new to Excel. No prior Excel knowledge is necessary to participate in this course.


The tutorials were recorded using Excel 2010, 2013, 2016, 2019, 2022 and Microsoft 365.

Most of the concepts taught are compatible with:

  • Excel for Windows: 2007, 2010, 2013, 2016, 2019, 2022 & Microsoft 365
  • Excel for Mac: 2011, 2016, 2019, 2022 & Microsoft 365

No - this isn’t like school - this is self-paced learning - you decide when you start and when you finish.

You get access to all the training materials for life. 

You can access the course site from your work computer, home computer, tablet, smartphone or any other device with an internet connection.

The course site remembers your progress, so you can pick-up right where you left off on any device. That means you can watch a few videos at work, then continue right where you left off on your home computer.

Yes! You will be able to download and keep all the excercise files in each of the courses as well as our PDF Cheat Sheets.

This makes it easy to follow along and practice with our data, whether you are online or offline.

Yes, this course and all the training materials can be accessed on any tablet or smartphone, and it looks beautiful. 

You can watch the course on your iPad, Tablet or mobile phone anywhere and anytime!

Each video has a discussion section. You can use this section to ask questions and see what questions other students have. We will be there helping to answer your questions.


You can also send an email to our dedicated email support if you cannot find your answer.

Yes, you can use your company's credit card to pay for the course. A receipt will also be emailed to you that you can submit for reimbursement to your employer. 

Most companies are willing to invest in making their employees even more awesome at Excel!

We accept all major credit cards like Visa, MasterCard, American Express, Apple Pay and PayPal.

Through our partners like Klarna, Afterpay, and Affirm, we can give you the flexibility of breaking up your purchase into easy installments.

The course fees are shown in USD $

Get in contact with us if you want to pay via bank transfer or check at [email protected]

If you need a Tax Invoice for your records, then this can be emailed to you. We are happy to complete any paperwork your company or government may require.

Yes! Each course comes with lifetime access to all course materials.

There are team packages available at a discounted price!

Each team member will have their own account and be able to track their progress in the course. 

Get a quote by filling in this form here: https://www.myexcelonline.com/corporate-academy-team-packages

Yes! You will receive a Completion Certificate at the end of each course.

You can cancel at any time within the first 30 days and receive a full refund.


Plus, you get to keep all our downloadable course Cheat Sheets and Workbooks!