This course is designed for the intermediate user of Excel 2010, through 2016 who are looking to improve their productivity and to learn some cool new Excel skills. The course covers some basics, along with some advanced tips and tricks on selecting, navigating as well as copying and moving data efficiently. It also covers a spectrum of functions that can be used in everyday practice. Functions such as SUBTOTAL, SUMIF, SUMIFs as well as INDEX MATCH are discussed. The 2013 AGGREGATE and IFNA functions are covered. Comparing lists using arrays is overviewed. Pivot tables are discussed in detail. Other topics include: functions and tools for importing data into Excel, conditional formatting as well as charts. There are no associated Excel files. Table of Contents
Delivery Method: QAS Self Study.
Version: Excel 2013 and 2016. Excel 2010 should have little difficulty although you will not be able to try some of the features.
Prerequisites: Knowledge of Excel and how to create a formula and use functions.
Advanced Preparation: None