EXCEL PRO TIPS FOR POWER USERS from Chris Dutton

EXCEL PRO TIPS FOR POWER USERS from Chris Dutton

Sale page

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

“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

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

Course Structure & Outline (1:58)

DOWNLOAD: Course Resources

Setting Expectations (1:45)

Productivity Tips

Introduction (0:29)

Customizing the Footer (4:03)

CTRL Shortcuts (8:01)

ALT Key Tips (6:53)

“Go To” Special Options (4:36)

Removing Blank Rows (3:17)

Data Validation Drop-Downs (7:11)

Autofill & Flash Fill (8:26)

Customizing the Ribbon (6:53)

Splitting Text to Columns (7:39)

Synchronous Scrolling (2:58)

Extracting Unique Values (4:06)

Named Range & Table References (8:12)

Protecting Cells & Formulas (8:09)

Multi-Level Row & Column Sorting (10:54)

Advanced Filter Criteria (9:27)

QUIZ: Productivity Tips

Formatting Tips

Introduction (0:26)Formatting Shortcuts (4:28)

Snap to Grid (4:30)

Hiding Workbook Elements (4:03)

Format Painter (6:41)

Color & Border Design (7:03)

Freezing Panes (5:58)

Center Across Selection (4:33)

Invisible Text Formatting (3:55)

Zip Codes & Phone Numbers (5:09)

Grouping Columns & Rows (6:25)

Formatting Errors with IFERROR (5:50)

Converting Text to Date Values (10:39)

Formula-Based Formats (10:41)

Advanced Number Formats (10:37)

QUIZ: Formatting Tips

Formula Tips

Introduction (0:28)

Manual vs. Automatic Calculation (4:19)

Formula Line Breaks (4:05)

Converting Units of Measurement (5:50)

Real-Time Tools with TODAY & NOW (10:18)

Formula Auditing Tools (11:18)

Pivot-Style Reports with Formulas (8:37)

Counting Words in a Cell (7:24)

Dependent Drop-Downs with INDIRECT (8:28)

Hyperlinking Between Worksheets (8:13)

“Fuzzy Match” Lookups (7:15)

Random Selection with OFFSET & RANDBETWEEN (6:26)

Combining INDEX & MATCH (8:40)

Matching Items Between Lists (11:00)

Counting Duplicates with SUMPRODUCT (8:59)

Many-to-Many Lookups (9:53)

QUIZ: Formula Tips

Visualization Tips

Introduction (0:24)

Chart Properties (Move & Size) (5:08)

Hidden Chart Source Data (2:43)

Filled Maps (Excel 2016+) (5:10)

Customizing Charts to Tell a Story (8:53)

Adding Sparklines (7:44)

Custom Chart Templates (6:06)

Heat Maps with Color Scales (7:11)

Analyzing Distribution with Histograms (9:28)

Goal Pacing with Gauge Charts (10:26)

Highlighting Time Periods (8:05)

Dynamic Source Ranges (12:08)

Interactive Form Controls (11:48)

QUIZ: Visualization Tips

PivotTable Tips

Introduction (0:18)

Customizing the Field List (4:07)

Autofitting Column Width (4:21)

Outline & Tabular Layouts (7:46)

Counting Non-Numerical Fields (6:05)

Grouping Dates (8:03)

Enabling Multiple Filters (5:00)

Grouping Values (6:50)

Adding Value Calculations (9:01)

Showing Empty Items (6:22)

Configuring Slicers & Timelines (10:23)

Conditional Formatting (8:23)

Removing & Reviving Source Data (8:19)

Adding Custom Sort Lists (5:23)

Solve Order & List Formulas (6:16)

QUIZ: PivotTable Tips

Analytics Tips

Introduction (0:29)

Quick Analysis Tools (6:03)

Scenario Manager (7:55)

Optimizing with Goal Seek (6:33)

Basic Forecasting (11:09)

Outlier Detection (9:24)

Automated Data Tables (8:06)

Power Query Tools (10:41)

Data Modeling 101 (10:23)

CUBE Functions (16:21)

Monte Carlo Simulation (11:38)

Advanced Optimization with Solver (12:16)

Analysis ToolPak (Preview) (8:10)

QUIZ: Analytics Tips

Wrapping Up

Get immediately download EXCEL PRO TIPS FOR POWER USERS from Chris Dutton