Excel Essentials Part 3
On-Track is excited to offer LIVE virtual training classes to our beloved students. Enjoy all the benefits a live expert instructor from the comfort of your own home or office computer.
Please contact us at learn@on-track.com to receive additional information about our virtual classes and training platform.
Duration: Half Day (3.5 hours)
COURSE OUTLINE
- Window Management
- Splitting Panes
- Freezing Panes
- Viewing and Arranging Multiple Worksheet Windows
- Viewing and Arranging Multiple Workbooks
- Hiding and Unhiding
- Hiding and unhiding rows and columns
- Hiding and unhiding worksheets
- Hiding and unhiding windows
- More on Formatting
- Using text alignment options
- Using borders
- Creating custom number formats
- Using conditional formatting rules
- Auditing Worksheets
- Revealing formulas in a worksheet
- Using the Watch Window
- Using the Formula Evaluator
- Tracing Precedents and Dependents
- Using the Error Checker
- Protecting Data
- Understanding what the “locked” status means
- Protecting a worksheet
- Unlocking cells
- Hiding data including formulas
- Password-protecting a range
- Protecting the structure (tabs) of a workbook
- Making a workbook “read-only”
- Password-protecting a workbook