Intermediate Microsoft Excel

Versions available: 00 & 03

Length:  Two 3˝ hour Classes
Prerequisite: Excel Essentials

When you want to move up to using more of Excel's power, take the Intermediate class! Topics include advanced formatting commands, creating cell, working with inserted objects. Then you’ll learn how to manage data from multiple worksheets and workbooks, and set up an easy-to-use data form to create and modify a list. Within lists, you’ll learn to sort and filter data in any combination, and create a PivotTable to display data interactively. Formulas will become easier to use when you master relative and absolute references, or formulas that link data between cells, worksheets, and workbooks. If you use Excel more than occasionally, this class will significantly improve your efficiency!

Formatting Techniques

  • Copy formats to other cell(s)

  • Wrap text within a cell

  • Customize a toolbar

  • Create a style by example

  • Apply style to other cells

  • Exclude formats from a style

  • Change a style (by definition)

  • Change a style (by example)

Create cell names

  • Understand why names are created 

  • Define a name for cell(s) 

  • Go to cell name references 

  • Create cell name(s) from an adjacent cell 

  • Replace formula cell references with new name

Understand Workbooks

  • Understand purpose of workbooks 

  • Rename a worksheet 

  • Insert, delete and rearrange worksheets 

  • Move a worksheet to another workbook

  • Use group edit mode

Work With Lists

  • Understand lists 

  • Understand data forms 

  • Use a form to enter data 

  • Find a record 

  • Delete a record 

  • Sort a list (by column & multiple criteria) 

  • Apply a filter to a list

Create PivotTables

  • Understand how a PivotTable works 

  • Create a PivotTable 

  • Create a PivotChart

  • Change and Format a PivotTable layout 

  • Display details on charts and PivotTables 

  • Change PivotTable source range

Cell References in Formulas

  • Understand relative vs. absolute cell references

  • Use relative cell references in a formula

  • Use absolute cell references in a formula

  • Use a shortcut for maintaining cell references

Link Data Cells

  • Understand data links

  • Link data between worksheets or workbooks