What you'll learn:
- Learn in depth Power Query, PowerPivot, DAX, Power BI and Power Map tools
- Learn from the beginning – blank canvas – until a completed report & dashboard. We show you how to best use the core elements of Power BI to conduct meaningful
- Quickly turn mass quantities of data into meaningful information using Excel Power Pivot and DAX
- Create business intelligence reports and dashboards
- Analyze huge amounts of data fast and accurate
- Learn the most current version of Microsoft Excel (Excel 2019 & Office 365)
- Improve general Excel knowledge
- Follow along with included Excel project files
- Course updated regularly
- Learn from an instructor with over 20 years of experience, teaching thousands of students in his own computer learning school
- An instructor ready to answer your questions in less than 24 hours
- Watch high-quality video lectures with lifetime access
- Certificate of completion
Master Power Query, Power Pivot & Power BI – Build Professional Dashboards and Data Models in Excel!
If you work with data in Excel and feel like you're spending hours on tasks that should take minutes — this course will change how you work. You'll go from manually copying and cleaning data to building automated, professional-grade dashboards that update with a click.
You'll learn how to use the Excel BI Toolkit – Power Query, Power Pivot, DAX (Data Analysis Expressions), Power Map (3D Maps), and Power BI Desktop – tools that are underutilized but incredibly powerful. These features will empower you to analyze, visualize, and present your data like a pro.
Whether you're an analyst, business professional, or Excel enthusiast, you’ll discover how to create dynamic reports, stunning dashboards, and complex data models—all within Excel.
Before You Begin
Please note: Power Pivot and Power Map are only available in specific versions of Excel for Windows. They are not available on Excel for Mac.
To confirm compatibility, preview Lecture (free preview): Versions, Compatibility and Installing Power Pivot & Power Map.
Why Learn These Tools?
Today, data analysis is expected in virtually every job role. Sure, anyone can sum up a column—but not everyone can:
Automate data imports and transformations with Power Query
Build efficient data models with Power Pivot
Write powerful custom calculations with DAX
Present insights with interactive 3D maps and dashboards
Connect multiple data sources and build a single source of truth with Power BI Desktop
That’s where this course comes in. It’s your step-by-step guide to mastering these advanced tools—no programming needed.
What You’ll Learn
How to install and enable Power Query, Power Pivot, Power Map & Power BI Desktop
Import data from various sources (Excel, Access, SQL, text files & more)
Save hours of manual work by automating data cleaning with Power Query
Create complex models and relationships across multiple tables
Build custom KPIs and time-intelligence metrics using DAX — no programming needed
Build interactive Excel dashboards with slicers, KPIs & dynamic charts
Present geographic data interactively using 3D Maps
Share your reports via Power BI Desktop
By the end of the course, you’ll combine everything to create a stunning, fully-interactive dashboard from scratch.
What’s Included
Full lifetime access to all course materials
Downloadable working Excel files for hands-on practice
Certificate of Completion
Fast & friendly support
30-day money-back guarantee – no questions asked!
Who Should Take This Course?
This course is perfect for:
Excel users ready to level up their skills
Business professionals and analysts seeking to build smarter reports
Financial analysts, project managers, or operations professionals who rely on Excel daily
Anyone with basic Excel knowledge who wants to work smarter with data
You don’t need to be an Excel expert—just a willingness to learn and a Windows version of Excel that supports Power Pivot.
What Students Are Saying
“I automated a report that used to take me 3 hours. The instructor is excellent!” – Troy N.
“A thorough and well-presented tutorial on Excel BI tools. Helped me build effective dashboards.” – Albert L.
“Highly recommended for those looking to level up their data presentation skills with Excel.” – David A.
Your next data project deserves better tools. Enroll now and build your first professional dashboard today.
