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
Tools
Excel
Course Level
Basic
Credentials
Paths

Not Sure Which COURSE or PATH is right for you?

Take our customized survey to find the perfect courses & paths for your skill level and goals!

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

WHO SHOULD TAKE THIS COURSE?

  • 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

WHAT ARE THE COURSE REQUIREMENTS?

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

  • Basic familiarity with Excel formulas recommended, but not required

Are you ready to become a DATA ROCKSTAR? Start learning today with your FREE 7-Day trial!

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?

Sign up today for a 7-Day Free Trial and start learning today!

Sign Up for Free