Here are 60
Excel 2007 Tutorials, hosted by the University of
Wisconsin – Eau Claire. These will help you understand and learn how to
use Excel’s spreadsheets, cells, rows, and columns, and also teach
these Excel features: printing options and layouts, paste special, find
and replace, hiding columns and rows, separating cell data, sorting
data, tables and databases, navigating, calculations, charting,
functions, and clip art. These tutorials are available for both Windows
and Macintosh platforms.
Working with Excel
- Getting Started with Excel (Win | Mac)
- The Office 2007 Environment
- Pointer Shapes
- Worksheet Terms
- Formatting Cells (Win | Mac)
- Formatting Numbers (Win | Mac)
- Working with Conditional Formatting (Win | Mac)
- Editing Cell Contents
- Calculating with Functions
- Calculating Subtotals (Win | Mac)
- Working with Rows and Columns (Win | Mac)
- Importing an External Data File
Printing with Excel
- Printing Basics (Win | Mac)
- Using Printing Options (Win | Mac)
- About the Page Setup Dialog Box
- Customizing Page Layout (Win | Mac)
- Adding Headers and Footers (Win | Mac)
- Modifying Headers and Footers (Win | Mac)
- Other Printing Options (Win | Mac)
- Using Print Preview (Win | Mac)
Special Features
- Working with Comments
- Using the Fill Command (Win | Mac)
- Using the Paste Special Feature
- Using the Find and Replace Features (Win | Mac)
- Hiding Columns, Rows, and Cells (Win | Mac)
- Separating Cell Data
- Sorting Data (Win | Mac)
Working with Tables and Databases – Windows:
- Tables Overview
- Creating Tables
- Establishing Criteria
- Filtering Your Table
- Analyzing Your Tables with Functions
- Working with Pivot Tables
Working with Tables and Databases – Macintosh:
- Database Basics
- Establishing Criteria
- Filtering Your Database
- Analyzing Your Database with Functions
- Working with Pivot Tables
Managing Your Excel Worksheet
- Organizing Worksheets (Win | Mac)
- Working with Groups of Worksheets
- Referencing Cells with Names (Win | Mac)
- Navigating Your Large Workbook (Win | Mac)
- Performing Calculations in Your Workbook (Win | Mac)
- Cell References: Relative and Absolute
- Correcting Circular References (Win | Mac)
- Protecting Your Files and Worksheets (Win | Mac)
Charting with Excel
- About Charting
- Guidelines for Charting
- Getting Ready to Chart
- Creating a Basic Chart
- Formatting Your Chart (Win | Mac)
- Working with Chart Elements (Win | Mac)
- Charting Extras
- Creating a Business Organization Chart
Favorite Excel Functions
- Rank (Win | Mac)
- Getting a Random Sample (Win | Mac)
- Countif and Sumif (Win | Mac)
- Concatenate (Win | Mac)
- Subtotal (Win | Mac)
- Inserting Dates and Times
- Automating Excel with Macros
Inserting Clip Art
Excel Gradebook
- Phase 1: Capturing Student Names
- Phase 2: Cleaning Up the Data for Use
- Phase 3: Entering the Grades
- Phase 4: Calculating Subtotals & Percentages
- Phase 5: Assigning Grades
- Phase 6: Online Submission of Grades
- Transferring Data into Other Gradebook Software
- Other Helpful Calculations
- Printing Tips
- Adding and Deleting Rows or Columns
- Additional Tips
Popularity: 42% [?]
Related Posts:
Tags for this post>> Excel | Excel 2007