image  
 

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
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 TABLES:



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
Refresh Data
Group by Dates (Week, Month, Year)
Calculated Fields (Create, Edit, Delete, List Formulas, Change Solve Order)
Slicers

PIVOT CHARTS:

Layout & Design
Chart Styles & Formatting
Change Chart Type
Filtering Options
Sorting Options

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.












Click to Call: (858) 578-9476
Click to Contact Us
Click to View Map / Directions