ADVANCED FORMULAS:

Create more complex formulas using Absolute Cell References, and the Order of Operations.

3-D FORMULAS:

Combine data from different sheets located within the same workbook (file).

LINK WORKBOOKS & CONSOLIDATE DATA:

Link data from different workbooks (files).

VALIDATION:

Use Validation to improve speed and accuracy of data entry, set limits on what can be entered, add drop-down lists and pop-up explanation boxes.

PIVOT TABLES:

Use Pivot Tables to summarize rows of data for reports.

GROUP / OUTLINE / SORT / FILTER / SUBTOTAL DATA:

Sort and Filter data, Subtotal data, Group and Outline data. Create Forms to speed up data entry, editing, and searching.

TEMPLATES:

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

CONDITIONAL FORMATTING:

Use Conditional Formatting to change the appearance of values or cell background colors.

PREREQUISITES: Beginning Excel or comparable experience.

Course handout covers version 2007-2010. Students will use version 2007-2010 in class.

(858) 578-9476
Info@PC-Classes.com