Shop Courses > Excel Tools and Tips for CPAs

Excel Tools and Tips for CPAs#292617

This course has been archived and cannot be purchased.

Credit
Amount
CPA
3

Course Description

Course publication/revision date: This course was updated on 3/25/2017.

This course is designed for the intermediate users of Excel 2010 and 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.