Excel tips and tricks for business - Session 6 - Modern Excel

Excel tips and tricks for business - Modern Excel - what you may have missed in the last ten years forms the last part of our six-course series that covers the essentials of using Excel in a business context.

Excel has changed a lot over time – if you’re just learning about Power Pivot and Power Query, consider that they’ve been a part of Excel for the better part of 10 years now. There have been even more recent changes – this session will cover a number of them, in addition to some items outside of, but still within, the Excel ecosystem.

• Dynamic arrays
• LET and LAMBDA
• Analyze Data
• Data Types
• Forms
• Office Scripts
• Power Automate

In the 'Excel tips and tricks for business' series we look at the core functions and features in Excel that help people build up spreadsheets and solve problems in a manner that is consistent, robust, flexible and transparent.

You can find more information about the other five sessions in the 'Agenda' tab.