TUTORIAL MANUAL

Tips for Using Excel 2007

This tutorial brings together the most important ways to work efficiently and design the best possible spreadsheets as you start to work on your own.

Organizing Spreadsheet Data on Different Worksheet
Generating New Workbooks from Templates
Freezing Column and Row Headings
Creating Data Series with Autofil
Using Range Names
Preventing Data Entry Errors with Data Validation
Saving Memory by Using Array Formulas
Trapping Error Values in their Original Formulas
Controlling Display of Data in Tables Through Outlines
Using View Side by Side to Work with Two Workbooks