Excel — Power Tools · Course on Udemy

Clean, model and analyse data with Power Query, Power Pivot and DAX

Stop copying and pasting reports together. Clean your data once, refresh it in one click, and build data models that answer real business questions.

★ 4.4 from 4,212 ratings on Udemy · 199 lessons · 17 hours

Enroll on Udemy →Watch a free lesson first

30-day refund through Udemy · Lifetime access · Certificate of completion

Watch the course trailer (5:23)

Is this course for you?

The power tools built into Excel turn hours of monthly copy-and-paste into a refresh button.

You will get the most from it if you…

combine data from several files or systems every month
join tables with VLOOKUP and copy and paste
work with more rows than a normal sheet handles comfortably
want to move towards Power BI

By the end you will be able to…

import and clean data from CSV files, workbooks, databases and folders
merge, append, pivot and unpivot data in Power Query
build a data model with relationships in Power Pivot
write DAX calculated columns and measures, including analysis over time
create your first Power BI dashboard and a 3D map

Prefer to start with charts and dashboards? See the Excel Dashboard Masterclass.

Five tools in one course

Each tool picks up where the last one stops, from raw data to a finished report.

01Power QueryImport, clean and combine data

02Power PivotBuild a data model with relationships

03DAXCalculated columns and measures

04Power BIYour first interactive dashboard

053D MapsPlot your data on a map

What is inside

Four parts, with practice challenges and projects along the way.

1. Power Query

Importing CSV files, workbooks, databases and folders, transforming and cleaning data, merging and appending queries, pivoting and unpivoting, a project and four practice challenges with answers.

2. Power Pivot and DAX

The Excel data model, DAX calculated columns, DAX measures, analysing data over time, and a milestone project.

3. Power BI

Data sources, designing your first dashboard, Power Query inside Power BI, reports, visuals, filters and Q&A, the data model, and DAX functions in Power BI.

4. 3D Maps and a final project

Mapping your data with Power Map, then building a complete dashboard with Power Pivot.

What students say

Reviews from students of this course on Udemy.

“I am very impressed with the course layout and execution. The structured approach significantly enhanced my retention of the material, and I now feel confident using the full range of Excel’s tools and features.”Brian R.

“I found this course very precise and helpful. The instructor is knowledgeable and really guides you through the course smoothly.”Chitrali K.

“It is a Fruitful Class that always reviews what we learned from previous lessons! Though we don't require Advanced Excel Knowledge to learn PowerBI Family, it's good to have some basic knowledge of the formulas, so you can really pick up the DAX formulas quickly. Love the course!”Hui-An H.

What is included

199 video lessons, 17 hours
Practice files, challenges and projects
Lifetime access on any device, including the Udemy app for offline viewing
Certificate of completion
A Q&A section on every lesson
30-day refund through Udemy

Your instructor

Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.

More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.

Questions before you start

Anything else? Write to info@mellontraining.com.

What do I need to know first?

You should be comfortable with everyday Excel, including tables, formulas and pivot tables. No database experience is needed.

Which version of Excel do I need?

Microsoft 365 or a recent Windows version of Excel. Power Pivot is not included in every edition, so the first section shows how to check your version and turn it on.

Does it work on a Mac?

No. Power Pivot and 3D Maps are not available in Excel for Mac, so you need Excel for Windows for the full course.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free Power Pivot dashboard lesson on this site, or the preview lessons on the Udemy course page.

Ready to stop copying and pasting reports?

199 lessons across Power Query, Power Pivot, DAX, Power BI and 3D Maps.

Enroll on Udemy →