TEMPLATES: 

Create and edit a Workbook Template, complete with formulas, functions, AutoSum, titles, borders, clip art, etc., so you can base new spreadsheets on it. 

ADVANCED FORMULAS: 

Use 3-D Formulas to combine data from multiple spreadsheets located within the same workbook (file). Link Workbooks to combine data located in separate workbooks (files).

FUNCTIONS:

Use Functions such as Average, Max, Min, Sum, If, CountIf, and SumIf to calculate text or numeric values. Learn how to "Nest" one function within another. 

SORTING, FILTERING, & SUB-TOTALING: 

Sort and filter data using multiple criteria. Add sub-totals to a worksheet, etc.

HLOOKUP & VLOOKUP: 

Use HLookup and VLookup to locate and display text or numeric values contained in rows/columns of a large spreadsheet.

VALIDATION: 

Use Validation to improve speed and accuracy of data entry with drop-down lists and pop-up explanation boxes.

PIVOT TABLES: 

Summarize large database spreadsheets with Pivot Tables and Charts.

MACROS:

Create simple Macros to automate basic tasks such as formatting text /numbers, calculating numbers, etc.

PASSWORD PROTECT ALL OR PART OF WORKBOOK:

Password Protect an entire workbook (file) or individual cells within a worksheet so they cannot be opened and/or edited.

MISC.:

Add Hyperlinks to connect spreadsheets to Word documents and other files. Add Comments to provide documentation for user.  Copy data from one spreadsheet to another. Name cell ranges. Split panes to view different parts of spreadsheet simultaneously. Freeze and Unfreeze panes to view titles while scrolling down a page. Use Conditional Formatting.