|
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 in class.
San Diego Computer Training
|