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 Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design 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 Coaching 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 Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling 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
30-Day Money-Back Guarantee

This course includes:

  • 8 hours on-demand video
  • 5 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Data Analysis

Microsoft Excel - Advanced Excel Formulas & Functions

Master 75+ Excel formulas with hands-on demos from a best-selling Microsoft Excel instructor (Excel '07 - Excel 2019)
Bestseller
Rating: 4.7 out of 54.7 (41,365 ratings)
197,467 students
Created by Maven Analytics, Chris Dutton
Last updated 11/2020
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch
  • Automate, streamline, and completely revolutionize your workflow with Excel
  • Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Get LIFETIME access to project files, quizzes, homework exercises, and 1-on-1 expert support
  • Build Excel formulas to analyze dates, text fields, values and arrays
Curated for the Udemy for Business collection

Requirements

  • Microsoft Excel 2007 - 2019 or Office 365 (Some features may not be available in earlier versions)
  • Experience with Excel formulas is recommended, but not required (we'll review some of the fundamentals)

Description

See why this is one of the TOP-RATED Excel courses on Udemy:

"One of the best Excel courses I've ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, and count me in for the next ones!"

-Julio Garcia

"This is an exceptionally valuable course. The information is vital with examples of best practices from a true Excel expert. Chris Dutton can teach!"

-Barbara S.

"Chris Dutton is an EXPERT in Excel. He makes comprehensible to the student the complex (sometimes super-complex) nature of the formulas he uses. Everything that is written at the course description, although it may seem pure marketing and publicity at first glance, is indeed true. If I could rate it higher I definitively would. THANKS Chris!"

-Bruno Ricardo Silva Pinho
__________


FULL COURSE DESCRIPTION:

__________

It's time to show Excel who's boss. Whether you're starting from square one or aspiring to become an absolute Excel power user, you've come to the right place.

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.

__________

By the end of the course you'll be writing robust, elegant formulas and functions from scratch, allowing you to:

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data

  • Go rogue and design your own formula-based Excel formatting rules

  • Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions

  • Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)

  • Manipulate dates, times, text, and arrays

  • Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)

__________

We'll dive into a broad range of Excel formulas & functions, including:

  • Lookup/Reference functions

  • Statistical functions

  • Formula-based formatting

  • Date & Time functions

  • Logical operators

  • Array formulas

  • Text functions

  • INDIRECT & HYPERLINK

  • Web scraping with WEBSERVICE & FILTERXML

__________

What gives you the right to teach this class? Can't I just Google this stuff?

I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and significant others. The only thing I love more than learning Excel is teaching it, and as the founder of Excel Maven and Maven Analytics I've been lucky enough to teach Excel to 200,000+ students across 180+ countries. My teaching style is conversational, authentic and to the point, and I will always communicate complex concepts in a framework that is clear and easy to comprehend.

As a full-time analytics consultant and Excel instructor, I cut my teeth using Excel to solve real-world business problems and develop award-winning analytics & data visualization tools for Fortune 500 companies. If you care about creds, I'm a card-carrying MOS Certified Excel Expert and my work has been featured by Microsoft and the New York Times. Ok so I don't actually carry the card, but you get the idea.

If you're looking for the ONE course with all of the advanced Excel formulas and functions that you need to know to become an absolute Excel ninja, you've found it.

See you in there!

-Chris (Founder, Maven Analytics)

__________

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!

*NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.

Who this course is for:

  • Excel users who have basic skills but want to get really, REALLY good
  • Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training
  • Excel users looking to build strong analytical thinking and business intelligence skills
  • Anyone looking to pursue a career in data analysis or business intelligence

Featured review

Wessels Theron
Wessels Theron
34 courses
7 reviews
Rating: 5.0 out of 56 months ago
Such an intuitive and amazing Excel course, coming from basic excel knowledge, this course has provided me with the tools needed to achieve so much more on my career path of BI Consultant. I highly recommend this course to anyone wanting to learn more about the advanced features in Excel. The course is really jam packed with content and the instructor is an absolute joy to listen to and makes learning interactive and fun, well worth the time and money.

Course content

11 sections • 105 lectures • 8h 4m total length

  • Preview01:28
  • READ ME: Important Notes for New Students
    01:54
  • DOWNLOAD: Course Resources
    00:27
  • Preview03:36

  • Introduction: Excel Formulas 101
    01:48
  • Excel Formula Syntax
    11:03
  • Preview08:42
  • Common Excel Error Types
    08:47
  • Preview10:15
  • Formula Auditing: Evaluate Formula & Error Checking (PC Only)
    07:48
  • Navigating Excel Worksheets with Ctrl Shortcuts
    07:30
  • Saving Time with Function Shortcuts
    09:44
  • Accessing Tools with Alt Key Tips
    04:17
  • BONUS: Mac Shortcuts
    00:00
  • PRO TIP: Creating Drop-Down Menus with Data Validation
    06:12
  • Congrats, You're a Developer!
    05:07
  • Excel Formulas 101
    6 questions
  • HOMEWORK: Excel Formulas 101
    00:25

  • Introduction
    01:11
  • Anatomy of the IF Statement
    04:01
  • Nesting Multiple IF Statements
    04:53
  • Adding Conditional AND/OR Operators
    08:47
  • Using NOT & "<>" Conditionals
    03:17
  • Fixing Errors with IFERROR
    04:03
  • Common IS Statements
    04:00
  • Excel Logical Operators
    5 questions
  • HOMEWORK: Excel Logical Operators
    00:44

  • Introduction
    01:09
  • Basic Excel Statistical Functions
    05:17
  • Extracting Values with SMALL/LARGE & RANK/PERCENTRANK
    06:15
  • Randomization with RAND() & RANDBETWEEN
    02:12
  • Row-Level Calculation with SUMPRODUCT
    03:55
  • Preview04:57
  • Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
    04:49
  • DEMO: Building a Basic Dashboard with COUNTIFS & SUMIFS
    08:09
  • DEMO: Counting Duplicates with COUNTIF & SUMPRODUCT
    07:57
  • PRO TIP: Data Profiling with COUNT & SUMPRODUCT
    16:06
  • Excel Stats Functions
    5 questions
  • HOMEWORK: Excel Stats Functions
    00:35

  • Introduction
    01:18
  • Working with Named Ranges
    03:30
  • Counting Rows & Columns with ROW/ROWS & COLUMN/COLUMNS
    03:18
  • Introduction to VLOOKUP/HLOOKUP
    05:53
  • Joining Data with VLOOKUP
    06:23
  • Fixing Errors with IFERROR & VLOOKUP
    04:30
  • VLOOKUP Reference Array Options
    06:18
  • Approximate Match Lookups
    05:05
  • Navigating Cell Ranges with INDEX
    01:59
  • Matching Text & Values with MATCH
    02:32
  • Combining INDEX & MATCH to Dynamically Search Ranges
    06:08
  • Combining MATCH & VLOOKUP for More Flexible Lookups
    04:47
  • TROUBLESHOOTING: VLOOKUP with Duplicate Keys
    05:05
  • SNEAK PEEK: XLOOKUP (Office 365 Only)
    04:29
  • DEMO: Building Dashboards with XLOOKUP (Office 365 Only)
    18:16
  • Selecting List Items with CHOOSE
    13:15
  • Defining Ranges with OFFSET
    02:05
  • Combining OFFSET with COUNTA to Create a Flexible Range
    02:58
  • PRO TIP: Using OFFSET to Create Interactive Charts
    09:51
  • Excel Lookup & Reference Functions
    5 questions
  • HOMEWORK: Excel Lookup & Reference Functions
    00:55

  • Introduction
    00:50
  • Capitalization with UPPER, LOWER, PROPER & TRIM
    03:32
  • Combining Text with CONCATENATE (&)
    03:26
  • Extracting Strings with LEFT, MID, RIGHT & LEN
    03:31
  • Converting Text to Values with TEXT & VALUE
    04:20
  • Searching Text String with SEARCH & FIND
    05:04
  • Categorizing Data with IF(ISNUMBER(SEARCH))
    05:39
  • Combining RIGHT, LEN, and SEARCH
    05:44
  • Replacing Text with SUBSTITUTE
    02:21
  • Excel Text Functions
    5 questions
  • HOMEWORK: Excel Text Functions
    00:59

  • Introduction
    02:08
  • Understanding Excel Date Syntax with DATEVALUE
    05:06
  • Formatting Dates & Filling Date Series
    03:39
  • Creating Real-Time Functions with TODAY & NOW
    02:16
  • Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND
    03:04
  • Calculating the Month Start or End with EOMONTH
    06:17
  • Calculating % of Year with YEARFRAC
    02:27
  • Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS
    07:22
  • Calculating Differences Between Dates with DATEDIF (Legacy Function)
    04:23
  • DEMO: Building a Simple Budget Pacing Tool
    11:07
  • Excel Date & Time Functions
    5 questions
  • HOMEWORK: Excel Date & Time Functions
    00:35

  • Introduction
    01:26
  • Creating, Editing & Managing Formula-Based Rules
    04:39
  • Highlighting Rows Using the MOD Function
    03:50
  • Formatting Based on the Value of Another Cell
    03:29
  • Formatting Cells Using Stats Functions
    05:28
  • Formatting Cells Using Text Functions & Logical Operators
    05:08
  • Excel Formula-Based Formatting
    5 questions
  • HOMEWORK: Excel Formula-Based Formatting
    00:34

  • Introduction
    01:24
  • READ ME: Array Formulas are Changing!
    00:33
  • Rules of Excel Array Functions
    03:24
  • Pros & Cons of Array Functions
    02:15
  • Defining Vertical, Horizontal, and 2-Dimensional Arrays
    06:26
  • Using Array Constants in Formulas
    03:38
  • Defining & Referencing Named Array Constants
    04:31
  • Restructuring Data with TRANSPOSE
    04:22
  • Linking Data Between Sheets (Array vs. Non-Array Comparison)
    02:36
  • Returning the Largest Values in a Range
    03:09
  • Counting Characters Across Cells
    01:52
  • Creating a "MAX IF" Array Formula
    03:09
  • Creating a "MAX IF" Array Formula with Multiple Criteria
    06:54
  • Converting Boolean Values Using the Double Unary ("--")
    03:49
  • Excel Array Formulas
    5 questions
  • HOMEWORK: Excel Array Functions
    02:09

  • Introduction
    01:38
  • Creating Custom References with INDIRECT
    10:55
  • Linking to Worksheet Locations with HYPERLINK
    06:19
  • Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1)
    07:16
  • Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2)
    09:14
  • Bonus Excel Functions
    3 questions

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 137,065 Reviews
  • 424,432 Students
  • 18 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
  • 126,860 Reviews
  • 424,338 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.