Many accountants who use Excel daily and consider themselves advanced users are not aware of some of the software’s most powerful features. Discover how these underutilized tools could increase your productivity. Many are easy to use and provide great benefits in situations accountants encounter regularly. Learn how to eliminate all rounding errors with the flip of a switch and work with live accounting data from inside Excel. Would it help to automate the process of updating spreadsheet data? You’ll be amazed at how much more productive you can be with Excel!

Who Should Attend
Accountants who work with Excel and want to learn some of its best features and functions

Topics Covered

• How to eliminate all rounding problems with the flip of a switch
• Using the “Tables” feature to work with lists of data (best new feature in Excel 2007)
• Accessing accounting data from inside Excel
• Modifying Excel’s default template (including headers, footers, margin, default format, etc.)
• Form controls
• Cleaning up imported accounting data quickly and easily
• And much, much more

Learning Objectives

• Learn how to be more efficient and effective with Excel in doing accounting work
• Reduce the risk of errors in Excel based accounting reports and projections

Level
Intermediate

Format
Live webcast

Instructional Method
Group: Internet-based

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
Good working knowledge of Excel

Advance Preparation
None