Excel Tools and

Tips for CPA’s

Course Description:

 This course is designed for Excel 2007 through Excel 2013 and people transitioning from Excel 2003. This EBook discusses some of the new features in Excel 2010 and 2013 however it does not cover all of them.

Learning Objectives:

Upon successful completion of this course, participants will be able to:

·          Recognize some of the new Excel features that have been added since version 2003

·          Differentiate between different Excel functions and which to select

·          Recognize Excel's sorting and subtotal capabilities

·          Recognize how to select data more efficiently

·          Recognize how to navigate and copy more efficiently

·          Identify existing Excel functions in the Text and Lookup categories

·          Recognize the steps needed to link external Excel files into a PowerPoint presentation