Free Excel 2003 Essentials Training Manual

Excel allows you to create and manage tables (worksheets) of data that are cross-referenced by rows, columns and other worksheets, and include calculations and graphs on that data. The data can be set up with various levels complexity, from containing simple formulas to complex functions and mathematical models.

Here is an excellent Free Excel 2003 Essentials Training Manual, from microsofttrainingcourses.co.uk. This training document is 216 pages in length, the zipped download size is 2.3mb doc file, and the resulting doc file size is 5.8mb. Essential Excel features and functionality covered by this Excel training manual include: Excel Screen Layout, Toolbars, Editing and Referencing Cells, Formulas, Functions, Moving And Copying Data, Formatting Data and Cells, Names, Working With Multiple Sheets, Printing, Manipulating Large Worksheets, Sorting & Subtotalling Data, and Customizing Excel. The Appendix shows all of the Excel toolbars with their functions referred to in the manual, along with tables of shortcut keys and an Excel glossary. For step-by-step instructions for each Excel command taught, look for the hand icon.


Table Of Contents of Excel 2003 Essentials Training Manual:

Introduction
How To Use This Guide
Objectives
Instructions
Commands
Notes
Tips

Section 1
The Basics
Windows Concepts
Excel Basics
The Spreadsheet Concept
The Excel Screen Layout
Use Toolbars
Use Menus
Getting Help

Section 2
Move Around And Enter Information
Data Entry
Autocomplete
Pick From List
Editing
Select Information
Select Cells The Mouse
Select Cells With The Keyboard
Clear Cells
The Fill Handle
Select Cells To Limit Data Entry
Select Cells For Multiple Entry

Section 3
Formulas And Functions
Entering Formulas By Pointing
Errors In Formulas
Filling Formulas
Functions
Function Box
Type Functions
Function Argument Tool Tips
Cell References
Absolute And Relative References

Section 4
File Operations
Save Files
Close Files
Open Files
New Files
Create Workspace Files

Section 5
Moving And Copying Data
Moving and Copying Items
Drag And Drop
Shortcut Menus
Moving And Copying Between Files
Moving And Copying Between Worksheets
Paste Special

Section 6
Formatting
Background Fill Colour
Borders
Alignment
Merge Cells
Number Formats
Advanced Formats
Format Cells Dialog
Custom Number Formats
Formatting Columns And Rows
Hide Columns And Rows
Insert and Delete Cells
Shortcut Keys For Formatting
Conditional Formatting

Section 7
Names
Rules When Naming Cells
Define and Create Name
Selecting Names
Names In Formulas
Apply and Delete Names
Intersecting Names

Section 8
Working With Multiple Sheets
Moving Between The Workbook Sheets
Move And Copy Worksheets
Insert And Delete Worksheets
Group Adjacent Sheets
Group Non-Adjacent Sheets
Fill Data Across Worksheets
3-D Formulas
External References
Protect Worksheet Data
View Worksheets Side By Side
Watch Window

Section 9
Printing
Print Preview
Page Setup
Page and Margine Tab
Header and Footer Tab
Sheet Tab
Page Breaks
Printing Large Spreadsheets

Section 10
Manipulating Large Worksheets
Split Screen
Freeze Panes
Zoom

Section 11
Sorting & Subtotalling Data
Lists
Sorting List Data
Subtotals
Summarising A Subtotalled List
Show And Hide By Level
Sort List Data With Sort Tools

Section 12
Customizing Excel
Customize Toolbars
Set Options
General Tab
View and Edit Tabs
Edit Tab
Transition Tab

Appendix
Standard Toolbar
Auditing Toolbar
Movement Keys
Mouse Selection Methods
Selection Keys
Keyboard Shortcuts For Formatting
Glossary