Refresher of the Basics
- Tips for Creating Spreadsheets
- Basic Formulae / Functions
- Absolute References ($)
Names
- Naming Cells
- Editing and Deleting
Tips for Working with Large Spreadsheets
- Freezing Screen Titles
- Splitting Windows
- Displaying Multiple Sheets / Files on Screen
Worksheet and File Linking
- Creating Simple Links
- Hyperlinks
- Links to other Programs
Page Setup Options
- Headers and Footers
- Repeat Headings for Printing
- Scaling
- Page Break Preview
- Setting Print Areas
List Data
- Sorting a List
- Filters
Charts
- Creating, Formatting and Editing Basic Charts
- Sparklines