Excel – EXCEL 365 New Features

This training focuses on using dynamic arrays with Excel functions available in Microsoft 365. We will show you how to leverage the power of dynamic arrays to create more efficient and dynamic reports. Thus, analyzing complex data becomes accessible to everyone. You will be able to create reports that seem very complex to set up, but that you can design using simple functions. The introduction of dynamic arrays represents the biggest change in Excel in years.

Technical precision: You must have the Microsoft 365 version of Excel.

Lesson Plan

Review :

• Tables and Named Fields

Introduction

• Formula Spill
• Availability
• Absolute and Relative References ($) - impact
• New Error Messages

Dynamic Functions

• UNIQUE
• SORT
• SORTBY
• FILTER
• SEQUENCE
• RANDARRAY

New Functions

• XLOOKUP
• IFS
• IFS + LET

Multiple Functions

• SUMIFS
• Charts
• Dropdown Lists
• Dependent Dropdown Lists
• Automating an Asset Schedule