Excel Intermediate - $99 (3.5 hours)
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).
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.
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.
Evaluate formulas to discover and resolve errors, view the relationship between different cells, etc.
Create and edit a Workbook Template so you can base new spreadsheets on it - complete with formulas, functions, AutoSum, titles, borders, etc.
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.