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 course is designed to teach you the fundamentals of good spreadsheet design that will increase your accuracy and efficiency when creating Excel spreadsheets.
DESIGNED FOR
ALL Excel users who want to create accurate spreadsheets and analyze data using Excel
BENEFITS
Upon completing this course, you will …
- 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
The key topics that will be covered in this course include:
- 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
COURSE LEVEL
Intermediate
PREREQUISITES
Good understanding of Excel
ADVANCE PREPARATION
None