
Excel Intermediate - $99
This class is intended for:
PC/Windows Users: Excel 2007-2010-2013-2016-365
Version Used in Class: Excel 2010
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: 3.5 hours
ADVANCED FORMULAS:
Create more complex formulas using Absolute Cell References and the Order of Operations. Learn the proper use of Formula Syntax - Example: =SUM('[Sales.xlsx]January'!B4:E4.B5:E5).
3-D 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.
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 TABLE BASICS:
Use Pivot Tables to summarize large spreadsheets. We also offer a separate in-depth class on Pivot Tables.
GROUP / OUTLINE / SORT / FILTER / SUBTOTAL DATA:
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 WORKBOOK:
Password Protect an entire workbook (file) or individual cells within a worksheet so they cannot be edited.