Excel’s newer features – from easier navigation to powerful dynamic arrays

05dec11:00 am12:30 pmExcel’s newer features – from easier navigation to powerful dynamic arrayswith Jessica Slack

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.

Time

(Tuesday) 11:00 am - 12:30 pm(GMT-11:00)