Excel 365 New Functions
Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course objective
Excel 365 has many exciting new functions which are not included in other versions of Office (2019 and earlier). These either have been a part of Excel 365 for years, or have been added through monthly updates to the software. In this class, students will learn how to use these new Logical, Lookup, and Dynamic Array functions in formulas.
Prerequisites
Students should be familiar with how to create formulas using intermediate functions in Excel like SUMIFS, COUNTIFS, AVERAGEIFS and have been exposed to VLOOKUP.
Course outline
- The superior lookup function, XLOOKUP
- Return a position or count values with XMATCH
- Summarize data using MINIFS, MAXIFS
- Test multiple conditions with IFS
- Joining data strings using CONCAT and TEXTJOIN
- Replace values with SWITCH
- FILTER returns a filtered array
- Create a sorted array with either SORT or SORTBY
- UNIQUE builds an array of all distinct values
- Use SEQUENCE to create consecutive data
- Build an array of random values with RANDARRAY
- LET function
- Use FILTER and SEQUENCE in LET