Excel – Master the Latest & Greatest 365-Only Functions

Elevate your Excel prowess with this training. Aimed at users already versed in Excel’s core functions (SUM, X/VLOOKUP, COUNTIF etc), this course introduces users to some of the new innovative functions added since 2020, exclusively available to Microsoft 365 and Excel 2021 users.

These cutting-edge tools are designed to streamline your formula creation process, enhance your data interaction, and expand your analytical capabilities. Embrace the simplicity of extracting unique values, sorting and filtering datasets, creating dynamic, self-updating lists and much more!

Whether you’re looking to improve efficiency, accuracy, or both, these features will set you on a path to becoming an Excel ninja. Ensure your skill set remains at the forefront of technological advancements with these essential, transformative functions that redefine what’s possible in Excel.

Topics We’ll Explore

• UNIQUE: Extract distinct values effortlessly
• FILTER: Refine your data with precision
• SEQUENCE: Generate ordered lists automatically
• SORT & SORTBY: Arrange your data with ease
• CHOOSECOLS & CHOOSEROWS: Select specific data segments
• TEXSPLIT, TEXTBEFORE, and TEXTAFTER: Manipulate text data like never before
• VSTACK: Merge arrays vertically with simplicity

Who Should Attend?

This intermediate-level training is tailored for Excel users eager to learn the cutting-edge functions exclusive to Microsoft 365 subscribers and Excel 2021 users. Prior to attending, confirm with your IT department whether your subscription includes these features.