Must Know Excel Functions for CPAs
SKU: 02-072-01-CPE
Credit Hours: 6
Level: Basic
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Joseph P. Helstrom, CPA
Course Description:
This course covers basic functions and then goes into logic functions, text functions, lookup functions and financial functions. This course also provides step by step instruction and Excel practice exercises.
At the end of this course, students will be able to:
- Recognize functions used to sum and count data and their uses
- Define logical functions to locate items to test and to locate and handle exceptions
- Define text functions to manipulate text data
- Define the vlookup function and a combination of the index and match functions
- Compute a payment, rate, term, present value or future value using time value of money functions