382-page Excel 2003 Training Manual Free Downloads—pdf from Purdue University—online office course

Here is a well written, illustrated 382-page Excel 2003 Training Manual, hosted by Purdue University. This Excel training document shows you how to use all of the basics features of Excel, along with most of the intermediate and advanced topics as well. Its divided into 12 chapters, each having detailed lessons demonstrating Excel tasks using step-by-step instructions and exercises for applying what you've learned. A review is included at the end of each chapter to help you remember the topics presented. It also offers a quiz and a homework assignment where you can put your new skills into practice. This Excel training manual is 13.2mb in size and is in pdf format. Purdue also provides this illustrated Excel 2003 Quick Reference document (2 pages, 155kb, pdf format).


Table of Contents of Excel Training Manual:

Chapter One: The Fundamentals
- Menus, Toolbars and Creating a New Workbook
- Worksheets: Navigation, Entering Labels and Values
- Calculating Value Totals with AutoSum
- AutoSum, AutoFill, and Entering Formulas
- Previewing and Printing a Worksheet
- Getting Excel Help

Chapter Two: Editing a Worksheet
- Entering Dates and using AutoComplete
- Editing, Cutting, Copying, and Pasting Cells
- Absolute and Relative Cell References
- Inserting and Deleting Cells, Rows, and Columns
- Using Undo, Redo, and Repeat
- Spell Check and Find / Replace Data
- Inserting Cell Comments
- Recovering Workbooks

Chapter Three: Formatting a Worksheet
- Formatting Fonts and Values
- Adjusting Row Height and Column Width
- Cell Alignment, Borders, Colors and Patterns
- Using AutoFormat and Creating a Custom Number Format
- Creating, Applying, and Modifying a Style
- Formatting Cells with Conditional Formatting
- Merging Cells, Rotating Text, and using AutoFit

Chapter Four: Creating and Working with Charts
- Creating, Moving and Resizing Chart s
- Formatting and Editing Objects in a Chart
- Changing a Chart’s Source Data and Type
- Adding Titles, Gridlines, and a Data Table
- Formatting a Data Series and Chart Axis
- Using Custom and 3-D Charts
- Chart Fill Effects

Chapter Five: Managing Your Workbooks
- Switching, Inserting and Deleting Worksheets
- Renaming and Moving Worksheets
- Splitting and Freezing a Window
- Referencing External Data
- Creating Headers, Footers, and Page Numbers
- Specifying a Print Area and Controlling Page Breaks
- Adjusting Page Margins and Orientation
- Protecting a Worksheet and Hiding Columns, Rows and Sheets
- Working with Templates
- Consolidating Worksheets

Chapter Six: More Functions and Formulas
- Formulas with Several Operators and Cell Ranges
- Insert Function Feature
- Using the IF Function to Create Conditional Formulas
- Displaying and Printing Formulas
- Fixing Formula Errors
- Mathematical, Financial, Date and Time, Statistical, and Database Functions

Chapter Seven: Working with Lists
- Working with Lists and Adding Records
- Finding, Deleting, and Sorting Records in a List
- Filtering and Creating a Custom AutoFilter
- Using an Advanced Filter
- Copying Filtered Records
- Data Validation

Chapter Eight: Automating Tasks with Macros
- Recording and Playing Macros
- Adding a Macro to a Toolbar
- Editing a Macro’s Visual Basic Code
- Prompting for User Input
- Using the If…Then…Else Statement

Chapter Nine: Working with Other Programs
- Inserting an Excel Worksheet into a Word Document
- Modifying an Inserted Excel Worksheet
- Inserting a Linked Excel Chart in a Word Document
- Inserting a Graphic into a Worksheet

Chapter Ten: Using Excel with the Internet
- Adding and Working with Hyperlinks
- Workbook as a Non-Interactive or an Interactive Web Page
- Import an External Data Source
- Refresh a Data Source and Set Data Source Properties
- Create a New Web Query

Chapter Eleven: Data Analysis and PivotTables
- Creating a PivotTable
- Specifying the Data a PivotTable Analyzes
- Updating PivotTable's Calculation and Display
- Formatting and Charting a PivotTable
- Subtotals for PivotTables
- Using Database and Lookup Functions

Chapter Twelve: Advanced Topics
- Hiding, Displaying, and Moving Toolbars
- Customizing Excel’s Toolbars
- Password Protecting a Workbook
- Sharing a Workbook and Tracking Changes
- Merging and Revising a Shared Workbook
- Using Detect and Repair