Microsoft

Microsoft Excel Functions & Formulas ISI-1533

Not sure this is the right class? Read What Microsoft Excel Class Should I Take?

  • 1 day
  • 1 upcoming date
  • $350 per seat

Upcoming dates

Dates Where Status Seat Book
Nov 13 2026 Live Online 9:00 AM to 4:00 PM PT Scheduled $350

See every class on the schedule

About this class

In this one day, instructor-led course you will learn advanced Excel formulas and functions to bring your spreadsheets to the next level. Learn how to develop more complex formulas and learn the power of arrays. Learn formulas to help you automate your spreadsheets to simplify them for others to use, as well as yourself.

Audience: Individuals interested in gaining solid understanding of advanced excel formulas and functions that can help their more advanced projects.

Features and functions in Office 365 and Office 2019 / 2016 are nearly identical. For this reason, users for all three versions (365, 2019 and 2016) attend the same class. The instructor will explain the few visual differences in the versions to you; just let the instructor know what version you are using.

What you'll be able to do

  • Learn how to develop more complex Excel formulas
  • Learn formulas to automate your spreadsheets
  • Text and Additional Functions
  • Lookups
  • When to use Dynamic Drop-Down Lists
  • Creating filtered Columns
  • Combine the different functions

Before you attend

An understanding of Excel Intermediate and Advanced topics including basic formulas, IF Statements and basic Lookup formulas. This is an intense 1 day course just learning about functions and formulas.

Course outline

  1. Module 1Math Functions

    • Setting up conditional formatting
    • Cumulative totals
    • Rounding

  2. Module 2Date Functions

    • Creating a weekday due date
    • Date differences
    • Workdays

  3. Module 3Logical Functions

    • Performing multiple logical tests
    • Using a logical test with multiple criteria
    • Using the switch function

  4. Module 4Lookup and Reference Functions

    • Looking up values in data
    • Dynamic dropdowns
    • Index and match functions to search date
    • Creating a fiscal quarter for a pivot table

  5. Module 5Statistical Functions

    • Different count functions
    • Determine specific values
    • Finding largest/smallest with criteria

  6. Module 6Text Functions

    • Combining data and creating email addresses
    • Combining text series with textjoin
    • Trimming excess data from a cell
    • Writing sentences using data and formatting formulas

Download the full outline (PDF)

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More desktop applications classes

See all