Most staff accountants learned Excel in college and many others learned Excel on their own; however, most users never learned the important productivity tips that could help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness.
Learning Objectives
- Identify all the ways you can select cells and ranges
- Recall ways to leverage custom number formats
- Recognize the importance of proper worksheet structure
Major Topics
- Navigating around worksheets
- Selecting cells and ranges
- How to use custom number formatting
- How to leverage Views
- How to build better formulas with referenced variables and defined names
- How to quickly format cells with Cell Styles
- Proper worksheet structure
