Any Excel user that wants to learn how to create controls within Excel to improve accuracy
Learning Objectives
After attending this presentation you will be able to ...
- Apply best practices when creating your spreadsheets
- Determine which controls you need to develop for your spreadsheets
- Use controls to build more accurate spreadsheets
Major Topics
The major topics that will be covered in this class include:
- Learn best practices when designing your spreadsheets
- How to create a proper worksheet structure
- Learn to use Excel's built in features to find errors
- How to create your custom controls to prevent and find errors
- Using links to quickly move to controls
- Using Conditional Formatting to highlight errors
