Creating Custom Financial Statements using Excel
SKU: 02-057-01-CPE
Credit Hours: 2
Level: Overview
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.
At the end of this course, students will be able to:
- Define certain text functions and use them to capture a portion of a general ledger account number
- Recognize the uses of the SUMIF function
- Define and use the VLOOKUP function
- Associate the INDIRECT function with referencing Excel worksheets