Upcoming dates
| Dates | Where | Status | Seat | Book |
|---|---|---|---|---|
| Oct 8 2026 | Live Online 9:00 AM to 4:00 PM PT | Scheduled | $350 | |
| Nov 13 2026 | Live Online 9:00 AM to 4:00 PM PT | Scheduled | $350 |
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
- 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
Excel Functions & Formulas ISI -1533 1 Day Instructor -led, Hands on Course Information In this one day, instructor -led course you will learn advanced Excel formulas and functions and learn the power of arrays. Learn formulas to help you automate your spr eadsheets 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 At Course Completion Upon successful completion of this course, students will understand: 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 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 Prerequisites Setting up conditional formatting Cumulative totals Rounding Module 1: Math Functions Module 2: Date Functions Creating a weekday due date Date differences Workdays Module 3: Logical Functions Performing multiple logical tests Using a logical test with multiple criteria Using the switch function Module 4: Lookup 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 Module 5: S tatistical Functions Different count functions Determine specific values Finding largest/smallest with criteria Module 6: Text 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)
Before you attend
Setting up conditional formatting Cumulative totals Rounding Module 1: Math Functions Module 2: Date Functions Creating a weekday due date Date differences Workdays Module 3: Logical Functions Performing multiple logical tests Using a logical test with multiple criteria Using the switch function Module 4: Lookup 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 Module 5: S tatistical Functions Different count functions Determine specific values Finding largest/smallest with criteria Module 6: Text 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
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.
More desktop applications classes
Introduction to Microsoft Planner
- $350 per seat
Introduction to Relational Database Design
- $395 per seat
Microsoft Access Level 1
- $650 per seat
2 dates on the calendar