Excel 2007 Tutorial

Getting Started:

• Spreadsheets

• Microsoft Office Button

• Ribbon

• Quick Access Toolbar

• Mini Toolbar

Customize Options

• Popular

• Formulas

• Proofing

• Save

• Advanced

• Customize

Working with Cells:

• Entering Data

• Select a Row or Column

• Copy and Paste

• Undo and Redo

• Auto Fill

• Select Data

• Format Cells Dialog Box

• Insert Cells, Rows, and Columns

• Delete Cells, Rows, and Columns

• Add Borders and Colors to Cells

• Find and Replace

• Go to Command

• Spell Check

• Basic Sorts

• Custom Sorts

• Filtering

• Merge Cells

• Align Cell Contents

Macros:

• Recording a Macro

• Running a Macro

Working with Workbooks:

• Create a Workbook

• Save a Workbook

• Open a Workbook

Calculations:

• Excel Formulas

• Calculate with Functions

• Function Library

• Relative, Absolute and Mixed References

• Linking Worksheets

Worksheets:

• Format Worksheet Tab

• Reposition Worksheets in a Workbook

• Insert and Delete Worksheets

• Copy and Paste Worksheets

Graphics:

• Create a Chart

• Modify a Chart

• Chart Tools

• Copy a Chart to Word

Modifications:

• Convert Text to Columns

• Modify Fonts

• Change Column Width and Row Height

• Hide or Unhide Rows or Columns

• Adding a Picture

• Adding Clip Art

• Editing Pictures and Clip Art

• Adding Shapes

• Adding SmartArt

Page Setup/Print:

• Set Print Titles

• Create a Header or Footer

• Set Page Margins

• Change Page Orientation

• Set Page Breaks

• Print a Range

• Split a Worksheet

• Freeze Rows and Columns

• Hide Worksheets