Must Know Excel Tips Tricks and Tools for CPAs
SKU: 02-073-01-CPE
Credit Hours: 5
Level: Overview
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Patricia McCarthy, MBA
Course Description:
This course covers a broad spectrum of topics and is designed with the idea that you will play with the features that are of interest to you which is why there are no associated exercise files.
At the end of this course, students will 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