Whether you are relatively new to the accounting profession or have been around for many years, there is a good chance that you are developing your Excel spreadsheets the hard way, leaving them susceptible to errors and omissions of important data. You'll learn the fundamentals of good spreadsheet design that will increase your accuracy and efficiency when creating Excel workbooks. You will also learn how to perform powerful data analysis using Excel. It will be well worth attending this course because of all the time it will save you in building your spreadsheets and analyzing your data. This is a fast-paced course that is sure to provide valuable knowledge to every Excel user.
DESIGNED FOR
Anyone who wants to optimize their use of Excel to build better spreadsheets.
BENEFITS
- Design spreadsheets with greater efficiency and accuracy
- Understand how to use advanced Excel functions
- Use auditing techniques to build more accurate spreadsheets
- Use advanced analytical tools to summarize detailed data
- Make your spreadsheets more professional in appearance
HIGHLIGHTS
- Building your spreadsheets for maximum efficiency and accuracy
- The most popular functions and formulas
- How to audit your spreadsheets to detect errors in formula logic
- How to analyze your data with PivotTables and Excel’s Power BI tools
- Tools for presenting your spreadsheets in a meaningful way
PREREQUISITES
None
ADVANCE PREPARATION
Bring your Laptop with Excel pre-installed. Excel practice files will be provided.
ADDITIONAL NOTES
- Bring your Laptop with Excel pre-installed.
Course materials are distributed electronically. To access the materials visit My Events. Download to your laptop or tablet prior to the seminar, handouts are added as received.