Distinguish critical spreadsheet design fundamentals

Use Excel’s Table feature as a foundational component of spreadsheets

Differentiate between the three different methods for consolidating data

Apply four techniques for sharing an Excel workbook and collaborating with others

Identify different practices for auditing and error-checking Excel workbooks, including Trace Precedents, Trace Dependents, and Formula Auditing

Differentiate between multiple techniques for securing Excel data