Recorded Online Course

COURSE CODE

EX03A4

SPEAKER

Simon Hurst

OBJECTIVES

Since the introduction of Office 365, significant Excel changes and enhancements have been delivered as frequently as monthly. The increased number of updates makes it increasingly easy to miss a change that could have the potential to dramatically improve your use of Excel. This course covers the most significant changes after the initial introduction of Excel 2016. If you are upgrading from an earlier version, we will also include a PDF detailing the changes from 2007 up to Excel 2016.

This is delivered as an online course using a narrated, high-definition screen recording. This allows an individual to access the course from anywhere, as often as they like, for as long as they like, within the month. Full notes are provided together with a comprehensive practice workbook and also email access to the speaker to answer queries. 

WHO WILL BENEFIT?

Users of Microsoft Excel that haven’t yet upgraded to the latest version and are wondering whether they should. Users of Microsoft Excel that have recently upgraded and want to make sure they’re getting the most out of the new version. The course is based on the use of Excel for Windows rather than Excel for Mac and, although the content might still be useful for Mac users, they should ensure that any key features are available in the version that they are intending to use.

This course is suitable for the levels “Basic User to General User” under the ICAEW IT Faculty Spreadsheet Competency Framework. For more information visit www.icaew.com/en/technical/information-technology/excel/spreadsheet-competency-framework.

TOPICS WILL INCLUDE

• Why VLOOKUP() is now an X function – a new better, safer, cleverer and easier way to create lookups in Excel
• Dynamic arrays – use one formula to populate hundreds of cells dynamically. One of the most significant structural changes ever made to the way that Excel works and one that can also affect existing workbooks, plus it comes with 7(ish) new functions.
• New functions, including supercharging IF()
• Maps and funnels – new chart types since Excel 2016
• New data types – stocks and geography
• The Excel Bl revolution - from spreadsheet to Business Intelligence engine. Where most of the Excel update effort is going. 
• Because of the way that Excel is now being continually updated, there are likely to be further significant changes between the production of this overview and the date of the course

VENUE

This is a 3 hour recorded online course accessed via the SESCA website: This recorded online course will be available anytime with one month’s access.

DISTRICT

South East

COURSE FEE

£100+VAT. (click here for information on the Flexiticket discount scheme - fees as low as £60.00+VAT per place). The courses ‘Why Power Query is the most important Excel development ever’, 'Good Spreadsheet practice', 'Using the Latest Versions of Excel to Revolutionise Your Spreadsheets',  ‘50 Advanced Techniques for Creating Inspirational Sreadsheets‘,  'More Power to your Pivot' and 'Essential Word Productivity Skills and Techniques for Accountants'  if booked individually are available to IT Faculty members  for £60+VAT each.