INTERMEDIATE EXCEL HANDS-ON CLASSES

ADVANCED FORMULAS:

Use Absolute Cell References and the Order of Operations to create advanced formulas.

3D FORMULAS:

Pull numbers from different spreadsheets within the same file.

LINK & CONSOLIDATE DATA:

Link and consolidate data from different files.

VALIDATION RULES:

Apply Validation Rules to speed-up data entry and accuracy, limit what can be entered into a spreadsheet, include drop-down lists, etc.

PIVOT TABLES & PIVOT CHARTS:

Create Pivot Tables and Pivot Charts to summarize large amounts of data.

GROUP, OUTLINE, SORT, FILTER, & SUBTOTAL DATA:

Sort and Filter, Subtotal, Group, and Outline data.

TEMPLATES:

Create a Template you can base new spreadsheets on - with formulas, functions, AutoSum, titles, borders, clip art, etc.

CONDITIONAL FORMATTING:

Use Conditional Formatting to make certain values stand out.