Excel 365 has changed with Microsoft adding a tranche of powerful new functions to simplify tasks, streamline formulas, and make your spreadsheets more dynamic. If you're still using VLOOKUP, IF, and COUNTIF, you're missing out on what's now possible.
On this session, we will investigate the latest Excel 365 time saving functions for filtering, sorting, and extracting data; ways to manipulate text, and stack arrays.
What will you learn?
At the end of this Microsoft Excel New Functions course, delegates will be able to take advantage of Excel’s latest functions to transform how you work with data.
Audience?
Experienced Excel users ready to learn new functions that can bridge the gap between what’s new and this is how we always used to do it.
Course Contents
Filter & Sort Functions
- Sort
- Sortby
- Unique
- Filter
- Unique
Lookup Functions
- Xlookup
- Xmatch
Logic
- IFS
Text Function
- Textafter / Textbefore
- Textsplit
- Regexextract
- Regexreplace
Array Functions
- Tocol / Torow
- Vstack / Hstack
- Trimrange
- Scan
- Choosecols / Chooserows
- Wrapcols / Wraprows
- Drop / Take
- Randarray / Sequence
Dynamic Tables
- Groupby
- Pivotby
- Percentof
Course Materials
Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable. These may be either paper based or in Adobe pdf format or a combination thereof.
“"Excellent course really enjoyed it. Trainer friendly, down to earth and easy to understand."”
Helen, Great Bear Distribution, Excel Advanced
Prerequisites
This course assumes attendance of our Excel Intermediate course (or equivalent knowledge).
Additional Information
Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.
The suggested course duration is a guideline. Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.