Working with Contiguous Groups

Working with Non-Contiguous Groups

Graphing

Updating Several Sheets Simultaneously

Absolute Cell References

Using Names

“Split the Sheets”

• To Split A Window
• Restore a Split Window to a Single Pane

Freeze Panes

Unfreeze Panes

Using AutoComplete

Filters—Picking and Choosing

• Advanced Filters
• Undoing the Advanced Filters

Sorting Your Table is Easier Than Sorting Your Laundry

• Simple Sort
• Advanced Sort

Subtotals

Paste Functions

• If Statements
• Future Value (aka: can you afford to retire?)
• Payments

Goal Seek

Working with Dates

What if Data Tables

Lookup Functions

Pivot Tables

• Creating a PivotTable
• Format Numbers in a PivotTable
• Modifying the Data Displayed in a PivotTable

Macros

• To Create Macros
• To Run A Macros
• To Edit or Delete Macros

Customize the Tool Bar

Create a Tool Bar for your Macros

Conditional Formatting

Stock Quotes