Microsoft Excel – Advanced Excel Formulas & Functions

Description

It’s time to show Excel who’s boss. Whether you’re starting from scratch or aiming to become an Excel powerhouse, you’re in the right place.

This course delivers a deep understanding of the advanced formulas and functions that turn Excel from a basic spreadsheet app into a powerful analytics engine. While many Excel courses only teach what each formula does, this one goes further—using hands-on, real-world examples to show why these formulas matter and how to apply them in practical scenarios.

I won’t just train you to memorize function syntax—I’ll teach you how to think like Excel.

By the end of the course, you’ll be confidently writing robust, elegant formulas from scratch, enabling you to:

  • Build dynamic tools and Excel dashboards to filter, display, and analyze your data

  • Create custom, formula-driven formatting rules

  • Join data from multiple sources using lookup, index, and match functions

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

  • Manipulate dates, times, text, and arrays

  • Automate repetitive analytics tasks using formulas—no VBA required!

You’ll explore a wide range of Excel formulas and functions, including:

  • Lookup & Reference functions

  • Statistical functions

  • Formula-based formatting

  • Date & Time functions

  • Logical operators

  • Array formulas

  • Text functions

  • Advanced tools like INDIRECT, HYPERLINK, WEBSERVICE, and FILTERXML

Course Content

Module 1 - Before We Dive In
05:55
Module 2 - Excel Formulas 101
39:28
Module 3 - Conditional Statements & Logical Operators
31:12
Module 4 - Statistical Functions
32:33
Module 5 - Lookup/Reference Functions
67:46
Module 6 - Text Functions
35:35
Module 7 - Date & Time Functions
48:37
Module 8 - Formula-Based Formatting
24:41
Module 9 - Array Formulas
46:38
Module 10 - Badass Bonus Functions
26:13
Module 11 - Conclusion
00:41