Excel Pro Tips for Power Users

75+ tools & techniques to work smarter, boost productivity, and become an Excel POWER USER

   Watch Video

Course Preview:


This course is NOT an introduction to Excel.

It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical "hacks".

It's about featuring powerful and effective tools and techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.

This is a non-linear course, meaning that you can jump to individual sections or lectures freely. Each video is designed to be an independent and self-contained demo, to help you learn these tools and techniques in quick, bite-sized lessons.

Course access includes a PDF ebook and downloadable Excel project file containing every single demo and dataset covered in the course -- ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.

It's time to start working smarter, not harder. If you're looking to maximize efficiency, supercharge productivity, and become an Excel POWER USER, this is the course for you.


The tips and techniques covered in this course fall into six categories:

  • Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)
  • Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)
  • Formula Tips (auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)
  • Visualization Tips (sparklines, filled maps, custom templates, form controls, etc.)
  • PivotTable Tips (slicers & timelines, custom layouts, value calculations, etc.)
  • Analytics Tips (outlier detection, simulation, forecasting, CUBE functions, etc.)

While the level of difficulty varies considerably, the demos generally start simple and become progressively more complex within each section. There are no strict prerequisites, but keep in mind that some demos may be challenging without a strong foundational knowledge.

Students who have completed the full Master Class will be well-positioned for this course:

  • Advanced Excel Formulas & Functions
  • Data Visualization with Excel Charts & Graphs
  • Data Analysis with Excel PivotTables
  • Intro to Power Query, Power Pivot & DAX

Regular Price


Today's Price

Only $49


Over 75% OFF

"At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other courses!"

- Judit B.

"I've been using Excel for over 20 years and consider myself to be a "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different; I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with the Excel Maven!"

-Ryan H.

"Although I work with Excel on a daily basis and do pretty advanced stuff, I always learn something new or acquire a new perspective with Chris' courses. Couldn't ask for anything more!"

- Francesca C.


  • LIFETIME access to all current and future content
  • Downloadable Excel project files and PDF ebook
  • Unique, hands-on demos and case studies
  • Quizzes and practice exercises
  • 1-on-1 expert support
  • Certificate of Completion


  • Excel users looking to level-up and master the same tools used by Excel MVPs
  • Anyone hoping to maximize productivity, work efficiently, and supercharge their career
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel training

Some Things to Note:

  • Microsoft Excel 2007-2019 or Office 365 recommended (some tips may not apply to all versions)
  • Experience with formulas & functions, basic charts, and PivotTables strongly encouraged
  • This course is designed for PC users (some tools may not be available for Mac)


Meet Your Instructor

Chris Dutton
Chris Dutton

Chris Dutton is a certified Excel expert, EdTech entrepreneur, and best-selling instructor with 10+ years specializing in data visualization and business intelligence.

As Founder and COO of Maven Analytics, Chris’ work has been featured by Microsoft, HuffPost, Entrepreneur.com and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics seeks to empower everyday people to change the world with data. Chris graduated summa cum laude and received the Charles Bluhdorn Prize in Economics at Tufts University.

Course Curriculum

  Wrapping Up
Available in days
days after you enroll

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Regular Price


Today's Price

Only $49


Over 75% OFF