Course Description
Course publication/revision date: This course was updated on 1/22/2016.
This course is designed for the intermediate users of Excel 2010 through 2016 who are looking to improve their productivity and to learn new Excel skills. The course covers the basics and advanced tips and tricks on selecting, navigating, copying, and moving data. Also covered are functions that can be used in everyday practice, such as SUBTOTAL, SUMIF, SUMIF, and INDEX MATCH. The AGGREGATE and IFNA functions are also covered. An overview is provided for list comparison, pivot tables, functions and tools for importing data into Excel, conditional formatting, and charts.
