Whether you are relatively new to the accounting industry or have been around for a number of years, there is a good chance that you are developing your Excel spreadsheets the hard way and leaving them susceptible to errors and omissions of important data. This seminar will teach you the fundamentals of good spreadsheet design and increase your accuracy and efficiency when creating Excel spreadsheets. To get the most out of the presentation, we recommend that you bring your laptop to follow along.
DESIGNED FOR
CPAs and anyone who wants to optimize their use of Excel to build better spreadsheets.
BENEFITS
- Create spreadsheets with maximum efficiency
- Create formulas with greater accuracy
- Make your spreadsheets more professional in appearance
HIGHLIGHTS
- Getting to know the Excel interface
- How to efficiently enter data into Excel
- The art of building better formulas and making calculations that are more accurate
- The power of Defined Names and tables to create more accurate spreadsheets
- Using some of the most popular Excel Functions
- Best practices for printing your spreadsheets
- Tips & tricks for preparing your spreadsheets for distribution
COURSE LEVEL
Basic
PREREQUISITES
None
ADVANCE PREPARATION
Bring your laptop to follow along. The instructor example files will be available prior to class.
ADDITIONAL NOTES
- This IS NOT a hands-on course.