Basic Excel Skills for Accountants
SKU: 06-500-01-CPE
Credit Hours: 2
Category: Computer Software & Applications - Non-Technical
Delivery Method: Online Video
Instructor: David H. Ringstrom, CPA
Course Description:
This course contrasts the SUM, SUBTOTAL, SUMIF, and SUMIFS functions, along with the Subtotal feature. You'll also learn how to use the Table feature to streamline sifting through lists of data, create self-expanding charts, and PivotTables that have much better integrity.
This course has the following learning objectives:
- Select the formula that would drill through multiple sheets to add up a cell as well as automatically include any new sheets added later.
- Recall the menu in Excel where the Table feature resides.
- Recognize valid filtering options in Excel.