Excel classes in San Diego near me

Excel Intermediate


This class is intended for:

PC/Windows Users: Excel 2016-2019-365
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: 1 Day

san diego computer training classes

More Complex Formulas:

  • Formula Syntax
  • Absolute Cell References
  • Order of Operations

3D Formulas:


Combine data from different sheets located within the same workbook (file).

Link Workbooks | Consolidate Data:


Link cells from different workbooks (files) so you always see the latest information with automatic updates.

Apply Validation Rules:


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 and Pivot Charts:


Use Pivot Tables to summarize large spreadsheets. We also offer a separate in-depth class on Pivot Tables.

Group | Outline | Sort | Filter | Sub-Total:


Apply multiple Sorts and Filters, Subtotal data, Group and Outline spreadsheets.

Formula Auditing:


Evaluate formulas to discover and resolve errors, view the relationship between different cells, etc.

Templates:


Create and edit a Workbook Template so you can base new spreadsheets on it - complete with formulas, functions, AutoSum, titles, borders, etc.

Conditional Formatting:


Use Conditional Formatting to make important numbers stand out. Examples: make negative numbers turn red automatically, or change the background color of cells to highlight certain ranges of values.

Password Protect All or Part of a Workbook:


Password Protect an entire workbook (file) or individual cells within a worksheet so they cannot be edited.

san diego computer training classes