Must Know Excel Tips Tricks and Tools for CPAs
SKU: CPE-07-073
Credit Hours: 5
Level: Basic
Field of Study: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Patricia McCarthy, MBA
Upon completion of this course, you should be able to:
- Recognize different short cut keys and what they do
- Recognize the steps needed to pin a file
- Identify and create range names
- Recognize different ways to navigate within and between Excel workbooks
- Identify some of Excel’s new features and functions
- Recognize different copy and move methods
- Identify different types of formatting and how to apply them
- Identify different functions and formulas and when to apply them
- Recognize the different components of a Pivot Table and how to create and edit them
- Identify types of charts to use and how to create them
- Identify features that allow you to evaluate the workings of formulas and functions