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