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, DAX, Power Map, and Power BI Desktop – and Become an Excel Power User!
If you're ready to move beyond basic Excel and unlock its full analytical and business intelligence potential, this course is for you.
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.
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
Share professional reports 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.
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.
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)
Use Power Query to clean, transform, and automate data prep
Create complex models and relationships across multiple tables
Write advanced calculations using the DAX (Data Analysis Expressions) formula language
Build interactive Excel dashboards with slicers, KPIs & dynamic charts
Visualize data in 3D with Power Map
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 (responses within 48 hours)
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
Dashboard creators and BI enthusiasts
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
“Exactly what I needed to jump start my career. I learned far more than expected. 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.
Ready to transform your Excel skills and take your analysis to the next level?
Click Enroll Now and let's get started!
