Microsoft Excel Pro Tips Go from Beginner to Advanced Excel

Master 75+ Excel tips to build advanced Excel skills: formulas, pivot tables, charts, data analysis & data visualization
Microsoft Excel Pro Tips Go from Beginner to Advanced Excel
File Size :
7.10 GB
Total length :
10h 31m


Maven Analytics


Last update




Microsoft Excel Pro Tips Go from Beginner to Advanced Excel

What you’ll learn

Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel
Explore 75+ unique tips, tools and case studies that you won’t find in ANY other Excel course, guaranteed
Get LIFETIME access to resources, Excel project files, quizzes, and 1-on-1 expert support
Master Excel’s powerful data analysis tools like Goal Seek, Scenario Manager, Solver, and Analysis ToolPak
Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor
Become an absolute Excel POWER USER

Microsoft Excel Pro Tips Go from Beginner to Advanced Excel


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


This course is designed to transform everyday people into Excel POWER USERS.It’s not about comprehensive, 101-style deep dives into Excel’s core capabilities, or about showing off cheesy, impractical Excel “hacks”. It’s about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.Unlike most Excel courses, this one is non-linear and constantly evolving. This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis.  Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons.The best part? I’m including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.The Excel tips and techniques covered in this course fall into six core categories:Excel Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)Excel Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)Excel Visualization Tips (sparklines, filled maps, custom templates, Excel form controls, etc.)Excel Pivot Table Tips (slicers & timelines, custom layouts, value calculations, etc.)Excel Analytics Tips (outlier detection, monte carlo simulation, forecasting, CUBE functions, etc.) While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).It’s time to start working smarter, not harder. If you’re looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.Join today and get immediate, lifetime access to the following:10+ hours of high-quality videoDownloadable PDF ebookExcel project files & solutionsExpert-support and Q&A forum30-day money-back guaranteeHappy learning!-Chris (Founder, Maven Analytics)NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online)__________Looking for the full business intelligence stack? Search for “Maven Analytics” to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!See why this is one of the TOP-RATED Excel courses on Udemy:”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 Excel courses!”- Judit Bekker”One of the very best Excel classes I’ve taken – great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!”- Ernie Atkins”I’ve been using Excel for over 20 years and consider myself to be an Excel “power user”. As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, 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 Maven Analytics!”-Ryan Hughes


Section 1: Getting Started

Lecture 1 Course Structure & Outline

Lecture 2 READ ME: Important Notes for New Students

Lecture 3 DOWNLOAD: Course Resource Files

Lecture 4 Setting Expectations

Section 2: Excel Productivity Tips

Lecture 5 Introduction

Lecture 6 Customizing the Excel Footer

Lecture 7 Navigating Workbooks with CTRL Shortcuts

Lecture 8 Accessing Ribbon Tools with ALT Key Tips

Lecture 9 Accessing Excel’s “Go To” Special Options

Lecture 10 Removing Blank Rows in Excel Worksheets

Lecture 11 Creating Drop-Down Menus with Data Validation

Lecture 12 Filling Patterns with Autofill & Flash Fill

Lecture 13 Customizing the Excel Ribbon Tools

Lecture 14 Splitting Text to Columns in Excel

Lecture 15 Synchronous Scrolling Across Multiple Workbooks

Lecture 16 Extracting Unique Values from a List in Excel

Lecture 17 Using Named Range & Table References in Excel Formulas

Lecture 18 Protecting Cells & Formulas in Excel Workbooks

Lecture 19 Multi-Level Row & Column Sorting

Lecture 20 Configuring Advanced Filter Criteria in Excel

Section 3: Excel Formatting Tips

Lecture 21 Introduction

Lecture 22 Excel Formatting Shortcuts

Lecture 23 Snapping Objects to the Excel Grid

Lecture 24 Hiding Excel Workbook Elements

Lecture 25 Replicating Formats & Styles with Excel’s Format Painter

Lecture 26 Color & Border Design Tips in Excel

Lecture 27 Freezing Panes in Excel Worksheets

Lecture 28 Centering Across a Selection

Lecture 29 Creating an “Invisible” Format

Lecture 30 Zip Codes & Phone Numbers

Lecture 31 Grouping Worksheet Columns & Rows

Lecture 32 Formatting Excel Errors with IFERROR

Lecture 33 Converting Excel Text to Dates

Lecture 34 Creating Dynamic Formats with Excel Formulas

Lecture 35 Advanced Excel Number Formats

Section 4: Excel Formula Tips

Lecture 36 Introduction

Lecture 37 Manual vs. Automatic Calculation Modes in Excel

Lecture 38 Adding Line Breaks to Excel Formulas

Lecture 39 Converting Units of Measurement with Excel Formulas

Lecture 40 Building Real-Time Tools with TODAY & NOW Functions

Lecture 41 Excel Formula Auditing Tools

Lecture 42 Designing Pivot-Style Reports with Excel Formulas

Lecture 43 Counting Words in Excel with LEN & SUBSTITUTE Functions

Lecture 44 Configuring Dependent Drop-Down Menus with INDIRECT

Lecture 45 Creating Custom Hyperlinks Between Excel Worksheets

Lecture 46 Using Approximate Match VLOOKUP Functions

Lecture 47 Randomizing a Selection with OFFSET & RANDBETWEEN Functions

Lecture 48 Combining INDEX & MATCH Functions

Lecture 49 Finding Matching Items Across Lists in Excel

Lecture 50 Counting Duplicate Values with SUMPRODUCT

Lecture 51 Using Many-to-Many Lookups in Excel

Section 5: Excel Visualization Tips

Lecture 52 Introduction

Lecture 53 Configuring Excel Chart Properties (Move & Size)

Lecture 54 Managing Hidden Chart Source Data in Excel Worksheets

Lecture 55 Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365)

Lecture 56 Customizing Excel Charts to Tell a Story

Lecture 57 Adding Sparklines to Worksheet Cells

Lecture 58 Designing Custom Chart Templates in Excel

Lecture 59 Building Excel Heat Maps Using Color Scales

Lecture 60 Analyzing Distribution with Histograms

Lecture 61 Goal Pacing with Custom Excel Gauge Charts

Lecture 62 Highlighting Time Periods with Combo Charts

Lecture 63 Configuring Dynamic Chart Source Ranges

Lecture 64 Creating Interactivity with Excel Form Controls

Section 6: Excel Pivot Table Tips

Lecture 65 Introduction

Lecture 66 Customizing the Pivot Table Field List

Lecture 67 Autofitting Column Width in Pivot Tables

Lecture 68 Pivot Table Outline & Tabular Layouts

Lecture 69 Counting Non-Numerical Fields Using Pivots

Lecture 70 Grouping & Ungrouping Dates with Pivot Tables

Lecture 71 Enabling Multiple Pivot Table Filters

Lecture 72 Grouping Values into Buckets with Pivot Tables

Lecture 73 Adding Value Calculations to Pivot Tables

Lecture 74 Configuring Pivot Table Errors & Empty Items

Lecture 75 Configuring Pivot Table Slicers & Timelines

Lecture 76 Advanced Pivot Table Conditional Formatting

Lecture 77 Removing & Reviving Pivot Table Source Data

Lecture 78 Adding Custom Sort Lists in Excel

Lecture 79 Solve Order & List Formula Reports

Section 7: Excel Analytics Tips

Lecture 80 Introduction

Lecture 81 Excel Quick Analysis Tools

Lecture 82 Comparing Outcomes Using the Scenario Manager

Lecture 83 Solving Simple Optimizations with Goal Seek

Lecture 84 Creating Basic Forecasts in Excel

Lecture 85 Building an Outlier Detection Tool in Excel

Lecture 86 Generating Automated Data Tables

Lecture 87 Connecting & Transforming Data with Power Query

Lecture 88 Creating Relational Data Models in Excel

Lecture 89 Accessing the Data Model with CUBE Functions

Lecture 90 Building a Monte Carlo Simulation in Excel

Lecture 91 Advanced Optimization with Solver

Lecture 92 Excel Analysis ToolPak (Preview)

Section 8: Wrapping Up


Excel users looking to level-up and master the same tools and techniques used by Excel MVPs,Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level,Students looking for an engaging, hands-on, and highly interactive approach to Excel training,Anyone looking to pursue a career in data analysis or business intelligence,This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged)

Course Information:

Udemy | English | 10h 31m | 7.10 GB
Created by: Maven Analytics

You Can See More Courses in the Office Productivity >> Greetings from

New Courses

Scroll to Top