Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-15 20:11:10
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

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
Bestseller
Rating: 4.7 out of 54.7 (2,231 ratings)
17,108 students
Created by Maven Analytics, Chris Dutton
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

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

Requirements

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

Description

COURSE DESCRIPTION:

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 video

  • Downloadable PDF ebook

  • Excel project files & solutions

  • Expert-support and Q&A forum

  • 30-day money-back guarantee


Happy 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

Who this course is for:

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

Featured review

Hector Cordova
Hector Cordova
74 courses
27 reviews
Rating: 5.0 out of 5a year ago
Comprehensive, well detailed and useful course that will up your Excel dexterity. This is the 4th course I´ve taken from Chris and all of them have been totally worth it. Good pace, great tips, very valuable course overall.

Course content

8 sections • 93 lectures • 10h 31m total length

  • Preview01:58
  • READ ME: Important Notes for New Students
    01:54
  • DOWNLOAD: Course Resource Files
    00:19
  • Preview01:45

  • Introduction
    00:29
  • Customizing the Excel Footer
    04:03
  • Navigating Workbooks with CTRL Shortcuts
    08:01
  • Accessing Ribbon Tools with ALT Key Tips
    06:53
  • Accessing Excel's "Go To" Special Options
    04:36
  • Removing Blank Rows in Excel Worksheets
    03:17
  • Preview07:11
  • Filling Patterns with Autofill & Flash Fill
    08:26
  • Customizing the Excel Ribbon Tools
    06:53
  • Splitting Text to Columns in Excel
    07:39
  • Synchronous Scrolling Across Multiple Workbooks
    02:58
  • Extracting Unique Values from a List in Excel
    04:06
  • Using Named Range & Table References in Excel Formulas
    08:12
  • Preview08:09
  • Multi-Level Row & Column Sorting
    10:54
  • Configuring Advanced Filter Criteria in Excel
    09:27
  • QUIZ: Excel Productivity Tips
    10 questions

  • Introduction
    00:26
  • Excel Formatting Shortcuts
    04:28
  • Snapping Objects to the Excel Grid
    04:30
  • Hiding Excel Workbook Elements
    04:03
  • Replicating Formats & Styles with Excel's Format Painter
    06:41
  • Color & Border Design Tips in Excel
    07:03
  • Preview05:58
  • Centering Across a Selection
    04:33
  • Creating an "Invisible" Format
    03:55
  • Zip Codes & Phone Numbers
    05:09
  • Grouping Worksheet Columns & Rows
    06:25
  • Formatting Excel Errors with IFERROR
    05:50
  • Converting Excel Text to Dates
    10:39
  • Creating Dynamic Formats with Excel Formulas
    10:41
  • Preview10:37
  • QUIZ: Excel Formatting Tips
    10 questions

  • Introduction
    00:28
  • Manual vs. Automatic Calculation Modes in Excel
    04:19
  • Adding Line Breaks to Excel Formulas
    04:05
  • Converting Units of Measurement with Excel Formulas
    05:50
  • Building Real-Time Tools with TODAY & NOW Functions
    10:18
  • Excel Formula Auditing Tools
    Preview11:18
  • Designing Pivot-Style Reports with Excel Formulas
    08:37
  • Counting Words in Excel with LEN & SUBSTITUTE Functions
    07:24
  • Configuring Dependent Drop-Down Menus with INDIRECT
    08:29
  • Creating Custom Hyperlinks Between Excel Worksheets
    08:13
  • Using Approximate Match VLOOKUP Functions
    07:15
  • Preview06:26
  • Combining INDEX & MATCH Functions
    08:40
  • Finding Matching Items Across Lists in Excel
    11:00
  • Counting Duplicate Values with SUMPRODUCT
    08:59
  • Using Many-to-Many Lookups in Excel
    09:53
  • QUIZ: Excel Formula Tips
    10 questions

  • Introduction
    00:24
  • Configuring Excel Chart Properties (Move & Size)
    05:08
  • Managing Hidden Chart Source Data in Excel Worksheets
    02:43
  • Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365)
    05:10
  • Customizing Excel Charts to Tell a Story
    08:54
  • Adding Sparklines to Worksheet Cells
    07:44
  • Designing Custom Chart Templates in Excel
    06:06
  • Preview07:11
  • Analyzing Distribution with Histograms
    09:28
  • Goal Pacing with Custom Excel Gauge Charts
    10:26
  • Highlighting Time Periods with Combo Charts
    08:05
  • Configuring Dynamic Chart Source Ranges
    12:08
  • Preview11:48
  • QUIZ: Excel Visualization Tips
    10 questions

  • Introduction
    00:18
  • Customizing the Pivot Table Field List
    04:07
  • Autofitting Column Width in Pivot Tables
    04:21
  • Pivot Table Outline & Tabular Layouts
    07:46
  • Counting Non-Numerical Fields Using Pivots
    06:05
  • Grouping & Ungrouping Dates with Pivot Tables
    08:03
  • Enabling Multiple Pivot Table Filters
    05:00
  • Preview06:50
  • Adding Value Calculations to Pivot Tables
    09:01
  • Configuring Pivot Table Errors & Empty Items
    06:22
  • Configuring Pivot Table Slicers & Timelines
    10:23
  • Advanced Pivot Table Conditional Formatting
    08:23
  • Removing & Reviving Pivot Table Source Data
    08:19
  • Preview05:23
  • Solve Order & List Formula Reports
    06:16
  • QUIZ: Excel Pivot Table Tips
    10 questions

  • Introduction
    00:29
  • Excel Quick Analysis Tools
    06:03
  • Comparing Outcomes Using the Scenario Manager
    07:55
  • Solving Simple Optimizations with Goal Seek
    06:33
  • Creating Basic Forecasts in Excel
    11:10
  • Preview09:24
  • Generating Automated Data Tables
    08:06
  • Connecting & Transforming Data with Power Query
    10:41
  • Creating Relational Data Models in Excel
    10:23
  • Accessing the Data Model with CUBE Functions
    16:21
  • Building a Monte Carlo Simulation in Excel
    11:38
  • Preview12:16
  • Excel Analysis ToolPak (Preview)
    08:10
  • QUIZ: Excel Analytics Tips
    10 questions

  • BONUS LECTURE: More from Maven Analytics
    00:55

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 146,216 Reviews
  • 445,738 Students
  • 20 Courses

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.

Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.

Chris Dutton
Founder, Maven Analytics
Chris Dutton
  • 4.6 Instructor Rating
  • 134,629 Reviews
  • 446,102 Students
  • 6 Courses

Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling analytics instructor.

As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur, and the New York Times, reaching more than 500,000 students around the world.

A leader in analytics education, Maven Analytics empowers everyday people to change the world with data.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.