Objective
- List critical spreadsheet design fundamentals
- Identify techniques used to minimize data input errors
- Utilize Excel’s Table feature as a foundational component of spreadsheets
- Identify and implement three different techniques for consolidating data
- Utilize various Excel features, such as Go To Special to solve specific spreadsheet issues
- List and apply four techniques for sharing an Excel workbook and collaborating with others
- Implement various techniques for auditing and error-checking Excel workbooks, including Trace Precedents, Trace Dependents, and Formula Auditing
- Identify the advantages of working with Defined Names in Excel
- List and apply six techniques for securing Excel data
Prerequisite
Fundamental knowledge of Microsoft Office Excel 2007 or newerAdvanced Preparation
None