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
Inserting Clip Art
