Take your Excel skills to the next level and create formulas using parentheses, combine information from different sheets or files, use Validation to create look-up lists and limit what users can input, password protect all or part of a sheet, use Conditional Formatting to make important values stand out, and analyze large spreadsheets with PivotTables.
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. We will spend several hours on Pivot Tables.
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.
Conditional Formatting:
- 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.