Below you will find links to many more useful text based (with screen shots) tutorials on Microsoft Excel 2007 from the University of Wisconsin-Eau Claire

Working with Excel

• Getting Started with Excel
• The Office 2007 Environment
• Pointer Shapes
• Worksheet Terms
• Formatting Cells
• Formatting Numbers
• Working with Conditional Formatting
• Editing Cell Contents
• Calculating with Functions
• Calculating Subtotals
• Working with Rows and Columns
• Importing an External Data File

Printing with Excel

• Printing Basics
• Using Printing Options
• About the Page Setup Dialog Box
• Customizing Page Layout
• Adding Headers and Footers
• Modifying Headers and Footers
• Other Printing Options
• Using Print Preview

Special Features

• Working with Comments
• Using the Fill Command
• Using the Paste Special Feature
• Using the Find and Replace Features
• Hiding Columns, Rows, and Cells
• Separating Cell Data
• Sorting Data

Working with Tables (database functions)

• Tables Overview
• Creating Tables
• Establishing Criteria
• Filtering Your Table
• Analyzing Your Tables with Functions
• Working with Pivot Tables href=”Excel07/subtotal.htm” mce_href=”Excel07/subtotal.htm”>

Managing Your Excel Worksheet

• Organizing Worksheets
• Working with Groups of Worksheets
• Referenceing Cells with Names
• Navigating Your Large Workbook
• Performing Calculations with Formulas
• Cell References: Relative and Absolute
• Correcting Circular References
• Protecting Your Files and Worksheets

Charting with Excel

• About Charting
• Guidelines for Charting
• Getting Ready to Chart
• Creating a Basic Chart
• Formatting Your Chart
• Working with Chart Elements
• Charting Extras

Favorite Excel Functions

• Rank
• Countif and Sumif
• Concatenate
• Subtotal
• Inserting Dates and Times

Automating Excel with Macros

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art from the Web

Using Microsoft Office Help