|
This is a Microsoft Excel course designed specifically for CPAs. We focus on the features of Excel that are most applicable to the accountant. The goals of the course are to help you use Excel more fully, more efficiently and more effectively.
All spreadsheets used in class are available for download at clickconsulting.com.
Objectives
· Continue the advancement of your Excel knowledge
· Learn how to use the program more effectively
· Understand how to delegate work to Excel to make you more efficient
Major Topics
· Named ranges
· Function wizard
· Absolute/relative cell reference
· Copy/fill cells
· Hyperlinks
· Link workbooks
· Subtotal functions
· Keyboard shortcuts
· Best practices
· Data validation
· Custom menus
· Conditional formatting
· IF function for error checking
· VLOOKUP
· Autofilter
· Data group
· Concatenate
|
