Working with large worksheets

	Viewing options
	Hiding/displaying data
	Printing large worksheets

Multiple worksheets and workbooks

Linking worksheets using 3-D formulas

Data Consolidation

	Consolidating data across worksheets
	Consolidating data across workbooks

Advanced Formatting

	Rotating and Indenting
	Styles
	Custom formats
	Conditional formatting

Formulae

	Lookups
	Logical statements
	Text functions
	Using IF & SUMIF
	Using absolute references
	Date & Time Functions

Documenting and Auditing

	Comments and text boxes
	Auditing features

Collaborating with a workgroup

	Protection
	Using templates
	Creating and managing templates
	Naming cells and ranges
	Sharing workbooks
	Managing changes
	Merging a shared workbook