1. Lessons
Click each one of the links.
Read the lessons and try the examples.
Legs, Eggs, and
Pigs Page 75
Intermediate
Guide to Microsoft Excel
Format the Date and Time page 78
Calculate Revenue page 84
Link Worksheets page 90
Use Relative References page 92
Troubleshoot the equation page 95
Use Absolute References page 96
Use the Auditing Toolbar page 97
What If Scenarios page 99
Use Goal Seek page 102
Sounds Good To Me Page 11
Advanced Guide to Microsoft Excel
Data Analysis page 2
Paste Special page 5
Sort and Filter Data page 8
Text Formulas page 14
Conditional Formulas page 21
Named Ranges page 30
Convert Text to Columns page 35