Excel Intermediate (Full-Day) - $159
This class is intended for:
PC/Windows Users: Excel 2007-2010-2013-2016-365
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: 7 hours
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.
Create a Pivot Table
Layout & Design
Move a PivotTable
Filter a Pivot Table
Sort a Pivot Table
Expand & Collapse Columns
Grand Totals and Subtotals
Functions (Sum, Average, Min, Max)
Change Data Source (change range of cells, use Access as data source, etc.)
Append (Add) Data to a Pivot Table
Convert Underlying Data Into a Table
Combine Multiple Data Sources
Use GetPivotData Function
Group by Dates (Week, Month, Year)
Calculated Fields (Create, Edit, Delete, List Formulas, Change Solve Order)
Layout & Design
Chart Styles & Formatting
Change Chart Type
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.
Click to Call: (858) 578-9476
Click to Contact Us
Click to View Map / Directions