3D referencing
Auditing toolbar
Built in number formats / -Applying
Cell contents / -Adding
-Manipulating
Cell references / -Tracing
Chart / -Appearance modification
-Components & Types
-Copying
-Creation
-Data modification
-Default chart modification
-Legends, Axis & Titles
-Moving & Resizing
-Printing & Saving
-Setting printing options
-Style modification
Custom number formats / -Creating
Data consolidation
Data validation / -Error messages
-Using a list
Date functions
Drawing objects / -Adding word art
-Creating & Deleting
-Inserting 3D shapes
-Modifying
-Moving
Functions / -Including Financial
HTML files / Importing tables
IF logical function
Input message / -Creation
Invalid data / -Locating
Macro / -Assign to a command button
-Copying & Editing
-Deleting
-Recording & Executing
Multiple worksheets / -Previewing
Named range / -Using in a formula
Other applications / -Exporting data
-Importing data
Outlining / -Automatic
-Manual
-Outline symbols
Pictures / -Inserting
Protection / -Applying
-Clearing
-Selected worksheet access
-Using passwords
Report manager / -Using
Standard error messages
Text files / -Importing data
Tool bars / -Creating
-Customising display
-Deleting
-Modifying
Workbook / -Editing a webpage
-Hyperlinking
-Previewing as a web page
-Publishing to a web server
-Saving as a web page
Excel 2000 Introduction /Intermediate 2 day
Cell / -Accommodating text
Cell range / -Copying
-Moving
-Selecting
Data / -Copying & pasting
-Copying attributes
-Deleting
-Entering and editing
-Finding and replacing text
-Inserting and deleting cells
-Moving
-Spell checking
-Undo and redo commands
-Using auto complete
Formatting / -Auto format
-Borders and patterns
-Format painter
-List autofill
-Numerical data
-Rotation
-Style
-Text alignment
-Textual data
-Auto calculate
-Cell referencing
Formulas / -Entering
-Modifying accessed ranges
Help / -Accessing
-Office assistant
Printing / -Centred Data
-Inserting marginal data
-Orientation and scaling
-Previewing
-Setting print displays
-Worksheets and workbooks
-Selected Ranges
Row and column / -Deletion
-Freezing and unfreezing
-Hiding and unhiding
-Insertion
-Size modification
-Selecting
Sorting rows and columns
Workbook / -Closing
-Creating
-Location specific opening
-Location specific saving
-Open dialogue box
-Opening
-Previewing
-Save as dialogue box
-Searching before opening
-Sending
-Copying
-Custom reviewing
Workbook / -Deleting
-Inserting
-Linking
-Moving
-Navigating
-Page Breaks
-Renaming
Workbook / Simultaneous viewing