Excel Intermediate - $189 (full-day) ADVANCED FORMULAS:
Create more complex formulas using Absolute Cell References and the Order of Operations.
Combine data from different sheets located within the same workbook (file).
LINK WORKBOOKS & CONSOLIDATE DATA:
Link data from different workbooks (files).
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.
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.
Create and edit a Workbook Template so you can base new spreadsheets on it - complete with formulas, functions, AutoSum, titles, borders, clip art, etc.
Use Conditional Formatting to change the appearance of values or cell background colors.
PROTECT A WORKSHEET/WORKBOOK:
Protect a Worksheet or Workbook so it cannot be changed, etc. Allow users to change certain cells.