Excel Intermediate - $189
INTERMEDIATE EXCEL HANDS-ON CLASSES
Use Absolute Cell References and the Order of Operations to create advanced formulas.
Pull numbers from different spreadsheets within the same file.
LINK & CONSOLIDATE DATA:
Link and consolidate data from different files.
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.
Create a Template you can base new spreadsheets on - with formulas, functions, AutoSum, titles, borders, clip art, etc.
Use Conditional Formatting to make important values stand out.
Protect all or part of a Worksheet or Workbook so it cannot be changed, etc.
For more information call:858.578.9476