This seminar is designed to teach you a plethora of powerful features that Excel has to offer to take your data analysis and presentation to the next level. If you’re doing a lot with Excel already, get the tools you need to help you be quicker, more accurate and to provide more powerful data analysis.
DESIGNED FOR
CPAs and anyone who uses Excel and wants to analyze data.
BENEFITS
- Design spreadsheets with greater efficiency
- Debug formulas and find spreadsheet errors
- Setup spreadsheets for easy data analysis
- Use advanced analytical tools to present detailed data
- Introduction to the new Excel Power Business Intelligence tools
HIGHLIGHTS
- Understand the fundamentals of good Excel spreadsheet design
- Learn to leverage the power of Defined Names and tables to organize and manage your source data
- Advanced formula building and debugging
- How to audit your spreadsheets to detect errors in formula logic
- Best practices for setting up your spreadsheets for data analysis and reporting
- Learn to use Excel visual tools to make your data stand out
- Learn to use Pivot Tables to slice & dice your data
- Introduction to the new Excel Power Business Intelligence tools
COURSE LEVEL
Intermediate
PREREQUISITES
A good understanding of Excel.
ADVANCE PREPARATION
None
ADDITIONAL NOTES
This IS NOT a hands-on course, but to get the most out of the presentation we recommend that you bring your laptop to follow along. The instructor example files will be available prior to class. The course materials will be distributed in electronic format for viewing on your laptop or tablet device.