Your browser is not supported. Please download another browser to be able to use all of the Maven features.

Self-Paced Course

Excel Formulas & Functions

Master 75+ formulas & functions, and learn how to transform basic Excel worksheets into dynamic and powerful analytics tools.

Course Hours8 hours
Skills Learned
Data Prep
Data Analysis
Course Level

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.

Course Outline


  • Analysts looking to extract insight from raw data, and develop expert-level formula skills

  • Excel users who want to build interactive models or dashboards (forecasts, financial models, scenario tests, etc)

  • Anyone seeking to improve productivity and work more efficiently with data


  • Microsoft Excel 2007+ (some features may not be available in all versions)

  • Basic familiarity with Excel formulas recommended, but not required

Start learning for FREE, no credit card required!

Every subscription includes access to the following course materials

  • Interactive Project files
  • Downloadable e-books
  • Graded quizzes and assessments
  • 1-on-1 Expert support
  • 100% satisfaction guarantee
  • Verified credentials & accredited badges
Sign Up Today

Ready to become a

data rockstar?

Start learning for free, no credit card required!

Sign Up for Free