Master Business Intelligence &
Pivot Tables

Finally, a step-by-step course to Wrangle, Crunch, and Visualize Your Data! 
Become a Business Intelligence Master with Pivot Tables

Excel MVP, book author, and Pivot Tables guru teaches you how to build awesome Business Intelligence with Excel!


Time is money. If you have to rebuild your business intelligence delivery each time, you're wasting your most valuable resource. This course will show you step-by-step how to quickly build business intelligence solutions once and then reuse them across your organization.


This video course will show you exactly how to transform everyday data sets into rich Pivot Tables, dashboards, and reports with little effort.


Don't waste time with Excel features and expensive third party platforms you don't need. Learn how best to collect, organize, transform, present, and secure your data from unwanted eyes and prying analysts!  


Acclaimed Excel and Business Intelligence expert, Ken Puls. brings decades worth of hard-won knowledge delivering business intelligence solutions to small business and enterprise-level leadership. He has been awarded the prestigious Microsoft MVP award every year since 2006, has authored two books on Excel development, and is founder of Excel Guru.

Building BI with Pivot Tables is the best, most comprehensive online course to quickly increase your data and Excel skills and master Excel reports!

Wrangle, Crunch, and Visualize Your Data with
8 Comprehensive Modules 
that will turn you into a Business Intelligence master
Module 1 -
The Value of Pivot Tables

Duration: 26m

- The Business Intelligence Lifecycle
- Why You Should Care About PivotTables
- Creating Your First Pivot Table

Module 2 -
Pivot Compliant Data Sets

Duration: 51m

- Learn the perfect data layout
- Easily connect to your source data
- Feed data directly into Pivot Tables, Excel Tables, and Data Models

Module 3 -
Pivot Table Look & Feel

Duration: 55m

- Learn tricky Pivot Tables formats
- Group important data together for reporting
- Best sorting techniques to show top and bottom metrics

Module 4 -
Sourcing Data

Duration: 1h 52m

- Mastery Power Query to manipulate data
- Consolidating data across platforms
- Fast unpivoting/flattening data
- Database joins in Excel!

Module 5 -
Pivot Table Calculations

Duration: 50m

- Statistical calculations
- Running totals
- Variances and differences
- Calculated fields & items

Module 6 -
Slicing and Filtering

Duration: 42m

- Slice and dice your data
- Working with slicers and timelines
- Keeping everything looking nice
- Toggling options

Module 7 -
Pivot Table Dashboards

Duration: 51m

- Conditional formatting key metrics
- Keeping pivots in sync
- Tricks for extracting key info
- Working with Pivot Charts

Module 8 -
Data Refresh and Security

Duration: 22m

- Working with external and local data sets
- Securing your data

About Ken Puls, Microsoft Excel MVP

Welcome to my course!

I've spent over twenty years working in public practice accounting and industry as both a Controller and an IT Director. I've lead led the installation of over a dozen systems—and have worked with business systems and data of all types. You name it—I’ve done it.

Today, I work on my own, helping businesses realize value with their data. And I want to share what I’ve learned with you!

I love teaching people how to build awesome business intelligence systems and reports with Excel. My work will save YOU time and make you more efficient. 

“Your data should work for you, not the other way around.”

Here's What You’ll Get

Over 6.5 hours, 8 amazing modules, and 79 lessons. Plus lifetime access!

Quizzes, demos, labs, and bonuses keep your sharp. Use what you learn immediately!

Get the help you need. Ken will be there to guide you throughout the course. Leave a question under any video when you need help!

What People are Saying...

Marc Stevens ( Web Design Media )

This course is worth taking, retaking and then taking again.

Within the first couple of modules it was apparent Ken has been through it all. He speaks in a way that resonates both with professionals out in the field today and for those only now starting their journey. I will say for all the years I fought kicking and screaming learning PivotTables I wish I would have had this course at my disposal. Even now as an experienced PivotTable user I found myself rushing back to my daily reports throughout his lessons with aggregate methods. They say a blackbelt becomes a whitebelt when they realize there's still more to learn.

Alex Powers, Excel Expert at

Wow, what a comprehensive course!

I’m certainly no BI or PivotTable newbie but there is so much to learn in this course!

Danielle Stein Fairhurst, author of Financial Modeling for Dummies

Is this Course Right for You?

This course is not for everybody.


  • You believe you can make better business intelligence and reports faster and quicker if given the right guidance and tools.
  • You are a longtime professional, student or junior employee, or recent career changer looking to get in front of leadership and management.
  • You want to differentiate yourself in your office by having the best skills for the job.
  • You love getting your hands dirty with data and visualizing data for insights.  


  • You are looking for a course with Visual Basic for Applications, macros, or Microsoft Access as a focus.
  • You are looking for a course that does not teach Pivot Tables (see Excel Dashboard Pro instead)
  • You are looking for a quick guide that does not require time, effort or work.
We Stand Behind our course!

When you buy this course, you get the Excel.TV Guarantee. We guarantee you'll immediately learn to build awesome Pivot Tables and deliver insightful Business Intelligence to your managers and stakeholders.

We're so confident in our product, we're happy to guarantee its success. If you don't find immediate value within the first thirty days, we promise to give your money back. And we don't play games.

That's right, it's our no-questions-asked policy. Let us know within 30 days of your purchase you'd like a refund. IT'S THAT SIMPLE.

Enroll now and get these bonuses!

These bonuses are just for this product launch! We can't promise to offer the same in the future!

Excel TV Courseware & Community

Join the Excel.TV community, which includes of a growing knowledgebase of free video content, special discounts to course members, and exclusive deals not available to the general public.

You also get access to our awesome courseware! When you purchase this course, you can begin immediately. Because we host everything ourselves, there are no third parties! You deal with us directly!


1-Hour Live Webinar Q&A Session with Ken

Have a question as you're going through the course? What to get live help from Ken? Join now and get access to a live Q&A session with Ken. (We'll follow up to schedule.)

Can't make it? That's OK, there will be more than one. And past videos will always be available in your online course library.


Free Copy of M is for Data Monkey

Sign up now and get free access to Ken's book, M is for (Data) Monkey. This book shows how to use Power Query to get difficult data sets into both Excel and Power Pivot for dashboards and reports.

Start Today! Choose Your Plan Below

Invest in your career.

​Building BI with PivotTables


  • Over 6.5 Hours of Content
  • Exclusive Q&A Webinar with Ken, free copy of M is for (Data) Monkey, and no-questions-asked, money back guarentee
  • Lifetime access

Building BI with PivotTables + Excel Dashboard Pro


  • Everything in Building BI with PivotTables
  • Complete Course Access to Excel Dashboard Pro
  • Save over $100 when bundled!

​​Building BI with PivotTables + Excel Dashboard ProData Modelling in Excel


Here are answers to some frequently asked questions:

Can I access the class from anywhere? Can I download the videos?

I'm not an Excel expert and don't know macros or VBA, is this course for me?

Once purchased, how long will this course be available?

How long does it take to complete this course?

What payment methods do you accept?

I need help! Who can I contact?!

Will course materials be available for download?

Do you offer in-person, hands-on training in addition to these courses?

Can I watch lessons using my mobile device?

Do you offer corporate discounts?

What version of Excel do I need? Can I use Excel for Mac?

Can my employer pay for this course?

Master Business Intelligence! Get Building BI with Pivot Tables Today!