Basic Excel

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.

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

Author/Instructor
Jeff Lenning CPA CITP

Basic Excel