Excel 201: Create and Use Templates
In this live training event, we focus on creating and using templates in Excel. Templates are created for worksheets that are used repeatedly. By saving a workbook as a template, users open an exact copy of the spreadsheet without affecting the original copy. Participants will learn how to create, protect, and save an Excel template.
Recommended Duration: 45-minutes + Q & A
Core Objectives
- Explore Excel’s templates interface
- Create a mileage form template
- Use range names in a spreadsheet
- Enter formulas in a worksheet
- Protect a specific range of cells
- Save a template
- Open and use a template
- Optional: Explore Excel’s online templates
