Intermediate Excel Class - San Diego
PC/Windows Users: Excel 2010-2013-2016-365
This Excel class continues where the Intro class left off: we cover advanced formulas, link workbooks, and Pivot Tables.
Learn the proper use of these special characters in formula syntax:
Order of Operations
Understand how the Order of Operations affects formulas containing different types of math operators, and the proper use of inner and outer parentheses.
Use 3D formulas to combine data from different worksheets within the same workbook or file.
Link cells from different workbooks (files) so you always see the latest information with automatic updates. Much better than the Copy and Paste approach.
Consolidate data from different worksheets and workbooks, even if the worksheets have radically different layouts.
Use Validation to improve the speed and accuracy of data entry. Set limits on what can be entered into a spreadsheet. Add drop-down lists and pop-up explanation boxes.
Learn to harness the power of PivotTables and PivotCharts to analyze large spreadsheets.
- Create a PivotTable
- Layout & Design
- Copy a PivotTable
- Move a PivotTable
- Sort a PivotTable
- Expand & Collapse Columns
- Change PivotTable Report Layout
- Include or Exclude Grant 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
- Use GetPivotData
- Refresh Data
- Group by Dates (Week, Month, Year)
- Calculated Fields (Create, Edit, Delete, List Formulas, Change Solve Order)
- Slicers (visual filters)
Group / Outline / Sort / Filter / Subtotal Data
Group and Outline spreadsheets to simplify them, apply multiple Sorts and Filters, and Subtotal data.
Evaluate formulas to discover and resolve errors. View Precedents and Dependents to better understand the relationships between different cells.
Create and edit a Workbook Template so you can base new spreadsheets on it - complete with formulas, functions, titles, borders, etc. This is better than the "File, Save As" approach.
Use Conditional Formatting to make important numbers stand out. Make negative numbers turn red automatically or change the background color of cells to highlight certain ranges of values. Make rows change color based on specific criteria.
Password Protect All or Part of Workbook
Password Protect an entire workbook or file to limit access and/or editing capabilities. Restrict editing to specific cells within a worksheet so users cannot alter other parts of the spreadsheet.
Excel Intermediate Training Reviews:
Rated 4.7/5 based on 543 student reviews.
► More reviews...