PCA 832 - Excel for Bookkeepers
1.2 Continuing Education Units (CEU). This course is not for Credit(s).
This course is designed to enable the student to learn Excel functions to perform basic bookkeeping responsibilities. Topics include creating basic financial statements, use of merged cells, basic formatting, linking spreadsheets, SUM formulas, creating pivot tables, using VLOOKUP, automating financial tasks, and creating an amortization table.
Course Objectives:
Upon completion of this course, the students should be able to:
1. demonstrate use of merged cells and basic formatting,
2. create basic financial statements,
3. create financial reports,
4. create an amortization schedule,
5. demonstrate use of a pivot table, and
6. discuss how excel can be used to automate financial tasks.
Add to Portfolio (opens a new window)
|