Classes End User Application
ISI-1533 Microsoft Taught by us
Microsoft Excel Functions & Formulas
- 1 days
- 2 upcoming dates
Upcoming dates
All times shown in the class's own timezone. Dates we teach ourselves run once 1 people are booked, so a pair of seats confirms one.
| Dates | Starts | Where | Status | Seat | Book |
|---|---|---|---|---|---|
| Thu, Oct 8 | 9:00 AM to 4:00 PM PDT Taught by us | Live virtual | RUNS WITH 1+ | $350 | |
| Fri, Nov 13 | 9:00 AM to 4:00 PM PST Taught by us | Live virtual | RUNS WITH 1+ | $350 |
About this class
We have 2 scheduled dates of Microsoft Excel Functions & Formulas, from Thu, Oct 8 through Fri, Nov 13. We teach this one ourselves, with our own instructors and courseware. Seats are $350 each over 1 day, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.
Which Microsoft Excel Course should I take?
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
Course outline
Module 1 Math Functions
- Setting up conditional formatting
- Cumulative totals
- Rounding
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 Statistical 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
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.
How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.
Request a quote
Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.