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
Popularity: 26% [?]
Related Posts:12 Free Office XP Training ManualsFree Advanced Excel 2003 Training Manual12 Free Office 2000 Training ManualsFree Access 2003 Training Manual11 Microsoft Office eBooks
Tags for this post>>
Excel |
Excel 2003