There have been a huge number of changes and new functions introduced to Excel in the last few years.
This session aims to provide you with the highlights of the most
Event Details
There have been a huge number of changes and new functions introduced to Excel in the last few years.
This session aims to provide you with the highlights of the most universally useful new features.
This session will cover;
New navigation options and shortcuts
Newer, simpler formulas for cleaning dirty data – eg TEXTBEFORE/TEXTAFTER
Upgrades to tried and tested formulas – XLOOKUP, IFS
Dynamic array formulas such as FILTER, LARGE and some practical examples of where these might be used
This session is suitable for anyone who uses Excel regularly. It’s primarily designed for everyday or intermediate users of Excel, so does not assume prior knowledge of any formulas. It will be demonstrated on the Office 365 version of Excel.