Excel Formulas & Functions

COURSE DESCRIPTION:

This course is all about using formulas & functions to transform basic Excel worksheets into dynamic and powerful analytics tools.

We’ll cover 75+ core functions, using hands-on demos designed to showcase why they are important and how they can be applied in a variety of ways. This isn’t about memorizing syntax; it’s about learning how to THINK like Excel.

By the end of the course, you’ll have the skills to build interactive models and dashboards, automate tedious and time-consuming tasks, and explore your data using functions like VLOOKUP, INDEX/MATCH, OFFSET, SUMPRODUCT, and more. Whether you’re looking to brush up on the basics or develop expert-level formula skills, you’ve come to the right place.