Excel Pro Tips for Power Users

Course Preview:

ABOUT THIS COURSE

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.

WHAT WILL YOU LEARN?

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

~~$199~~

Today's Price

Only $49

Savings

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.

WHAT'S INCLUDED IN THE COURSE?

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
100% MONEY-BACK GUARANTEE

who IS THIS COURSE FOR?

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 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

Getting Started

Available in days

days after you enroll

Productivity Tips

Available in days

days after you enroll

Formatting Tips

Available in days

days after you enroll

Formula Tips

Available in days

days after you enroll

Visualization Tips

Available in days

days after you enroll

PivotTable Tips

Available in days

days after you enroll

Analytics Tips

Available in days

days after you enroll

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.