Excel Intermediate

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.