Layout Table~~~~6963~6963~~

Excel Training Available as Online, Customizable Courseware or Printable Quick References~With CustomGuide training users master topics they need quickly with bite-sized lessons, available as either customizable courseware or interactive online training. Printable quick references provide double-sided “cheat sheets” with frequently-used commands and shortcuts.

Online Interactive Training
Who ever became David Beckham by watching football ?
Instant bite-sized fully interactive tutorials answer “how to” computer questions Click to preview sample

Customizable Courseware
Why write your own courseware when CustomGuide have done it for you ?
Fully customizable content, unlimited printing rights, covers all areas. Click to preview sample

Printable Quick References
Save time and support calls with these single-page, double-sided “cheat sheets” that put frequently used commands, tips, and shortcuts at your fingertips. Click to preview sample~~~6963~6964~~

Course Outline Table~~~~6963~6965~~

Excel 2007~Coming soon !~~~6963~7067~~

Excel 2003~The Fundamentals
Starting Excel
What's New in Excel 2003?
Understanding the Excel Program Screen
Using Menus
Using Toolbars and Creating a New Workbook
Hiding, Displaying, and Moving Toolbars
Filling Out Dialog Boxes
Keystroke and Right Mouse Button Shortcuts
Opening a Workbook
Saving a Workbook
Moving the Cell Pointer
Navigating a Worksheet
Entering Labels in a Worksheet
Entering Values in a Worksheet and Selecting a Cell Range
Calculating Value Totals with AutoSum
Entering Formulas
Using AutoFill
Previewing and Printing a Worksheet
Getting Help from the Office Assistant
Changing the Office Assistant and Using the "What's This" Button
Closing a Workbook and Exiting Excel
Editing a Workbook
Entering Date Values and using AutoComplete
Editing, Clearing, and Replacing Cell Contents
Cutting, Copying, and Pasting Cells
Moving and Copying Cells with Drag and Drop
Collecting and Pasting Multiple Items
Working with Absolute and Relative Cell References
Using the Paste Special Command
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Checking Your Spelling
Finding and Replacing Information
Advanced Printing Options
File Management
Inserting Cell Comments
Formatting a Worksheet
Formatting Fonts with the Formatting Toolbar
Formatting Values
Adjusting Row Height and Column Width
Changing Cell Alignment
Adding Borders
Applying Colors and Patterns
Using the Format Painter
Using AutoFormat
Creating a Custom Number Format
Creating, Applying, and Modifying a Style
Formatting Cells with Conditional Formatting
Merging Cells, Rotating Text, and using AutoFit
Creating and Working with Charts
Creating a Chart
Moving and Resizing a Chart
Formatting and Editing Objects in a Chart
Changing a Chart's Source Data
Changing a Chart Type and Working with Pie Charts
Adding Titles, Gridlines, and a Data Table
Formatting a Data Series and Chart Axis
Annotating a Chart
Working with 3-D Charts
Selecting and Saving a Custom Chart
Using Fill Effects
Mapping Data
Modifying a Map
Managing Your Workbooks
Switching Between Sheets in a Workbook
Inserting and Deleting Worksheets
Renaming and Moving Worksheets
Working with Several Workbooks and Windows
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
Adding Print Titles and Gridlines
Changing the Paper Size and Print Scale
Protecting a Worksheet
Hiding Columns, Rows and Sheets
Viewing a Worksheet and Saving a Custom View
Working with Templates
Consolidating Worksheets
More Functions and Formulas
Formulas with Several Operators and Cell Ranges
Using the Formula Palette to Enter and Edit Formulas
Creating and Using Range Names
Selecting Nonadjacent Ranges and Using AutoCalculate
Using the IF Function to Create Conditional Formulas
Using the PMT Function
Displaying and Printing Formulas
Fixing Errors in Your Formulas
Mathematical Functions (Reference)
Financial Functions (Reference)
Date and Time Functions (Reference)
Statistical Functions (Reference)
Database Functions (Reference)
Working with Lists
Creating a List
Using the Data Form to Add Records
Finding Records
Deleting Records
Sorting a List
Filtering a List with the AutoFilter
Creating a Custom AutoFilter
Filtering a List with an Advanced Filter
Copying Filtered Records
Using Data Validation
Automating Tasks with Macros
Recording a Macro
Playing a Macro and Assigning a Macro a Shortcut Key
Adding a Macro to a Toolbar
Editing a Macro's Visual Basic Code
Inserting Code in an Existing Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If?Then?Else Statement
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
Opening and Saving Files in Different Formats
Using Excel with the Internet
Adding Hyperlinks to a Worksheet
Browsing Hyperlinks and using the Web Toolbar
Saving a Workbook as a Non-Interactive Web Page
Saving a Workbook as an Interactive Web Page
Using Queries to Retrieve Information from the Web
Data Analysis and PivotTables
Creating a PivotTable
Specifying the Data a PivotTable Analyzes
Changing a PivotTable's Calculation
Selecting What Appears in a PivotTable
Grouping Dates in a PivotTable
Updating a PivotTable
Formatting and Charting a PivotTable
Creating Subtotals
Using Database Functions
Using Lookup Functions
Grouping and Outlining a Worksheet
What-If Analysis
Defining a Scenario
Creating a Scenario Summery Report
Using a One and Two-Input Data Table
Understanding Goal Seek
Using Solver
Advanced Topics
Creating and Using Custom Toolbars
Creating a Custom AutoFill List
Changing Excel's Options
Password Protecting a Workbook
File Properties and Finding a File
Sharing a Workbook and Tracking Changes
Merging and Revising a Shared Workbook
Using Detect and Repair~~~6963~6966~~

Excel XP~The Fundamentals
Starting Excel
What's New in Excel 2002?
Understanding the Excel Program Screen
Using Menus
Using Toolbars and Creating a New Workbook
Filling Out Dialog Boxes
Keystroke and Right Mouse Button Shortcuts
Opening a Workbook
Saving a Workbook
Moving the Cell Pointer
Navigating a Worksheet
Entering Labels in a Worksheet
Entering Values in a Worksheet and Selecting a Cell Range
Calculating Value Totals with AutoSum
Entering Formulas
Using AutoFill
Previewing and Printing a Worksheet
Getting Help from the Office Assistant
Changing the Office Assistant and Using the "What's This" Button
Closing a Workbook and Exiting Excel
Editing a Workbook
Entering Date Values and using AutoComplete
Editing, Clearing, and Replacing Cell Contents
Cutting, Copying, and Pasting Cells
Moving and Copying Cells with Drag and Drop
Collecting and Pasting Multiple Items
Working with Absolute and Relative Cell References
Using the Paste Special Command
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Checking Your Spelling
Finding and Replacing Information
Advanced Printing Options
File Management
Inserting Cell Comments
Understanding Smart Tags
Recovering Your Workbooks
Formatting a Worksheet
Formatting Fonts with the Formatting Toolbar
Formatting Values
Adjusting Row Height and Column Width
Changing Cell Alignment
Adding Borders
Applying Colors and Patterns
Using the Format Painter
Using AutoFormat
Creating a Custom Number Format
Creating, Applying, and Modifying a Style
Formatting Cells with Conditional Formatting
Merging Cells, Rotating Text, and using AutoFit
Finding and Replacing Formatting
Creating and Working with Charts
Creating a Chart
Moving and Resizing a Chart
Formatting and Editing Objects in a Chart
Changing a Chart's Source Data
Changing a Chart Type and Working with Pie Charts
Adding Titles, Gridlines, and a Data Table
Formatting a Data Series and Chart Axis
Annotating a Chart
Working with 3-D Charts
Selecting and Saving a Custom Chart
Using Fill Effects
Managing Your Workbooks
Switching Between Sheets in a Workbook
Renaming and Moving Worksheets
Working with Several Workbooks and Windows
Splitting and Freezing a Windowv
Referencing External Data
Creating Headers, Footers, and Page Numbers
Specifying a Print Area and Controlling Page Breaks
Adjusting Page Margins and Orientation
Adding Print Titles and Gridlines
Changing the Paper Size and Print Scale
Protecting a Worksheet
Hiding Columns, Rows and Sheets
Viewing a Worksheet and Saving a Custom View
Working with Templates
Consolidating Worksheets
More Functions and Formulas
Formulas with Several Operators and Cell Ranges
Using the Insert Function Feature
Creating and Using Range Names
Selecting Nonadjacent Ranges and Using AutoCalculate>
Using the IF Function to Create Conditional Formulas>
Using the PMT Function
Displaying and Printing Formulas
Fixing Formula Errors
Mathematical Functions (Reference)
Financial Functions (Reference)
Date and Time Functions (Reference)
Statistical Functions (Reference)
Database Functions (Reference)
Working with Lists
Creating a List
Using the Data Form to Add Records
Finding Records
Deleting Records
Sorting a List
Filtering a List with the AutoFilter
Creating a Custom AutoFilter
Filtering a List with an Advanced Filter
Copying Filtered Records
Using Data Validation
Automating Tasks with Macros
Recording a Macro
Playing a Macro and Assigning a Macro a Shortcut Key
Adding a Macro to a Toolbar
Editing a Macro's Visual Basic Code
Inserting Code in an Existing Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If?Then?Else Statement
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
Opening and Saving Files in Different Formats
Using Excel with the Internet
Adding and Working with Hyperlinks
Browsing Hyperlinks and using the Web Toolbar
Saving a Workbook as a Non-Interactive Web Page
Saving a Workbook as an Interactive Web Page
Import an External Data Source
Refresh a Data Source and Set Data Source Properties
Create a New Web Query
Data Analysis and PivotTables
Creating a PivotTable
Specifying the Data a PivotTable Analyzes
Changing a PivotTable's Calculation
Selecting What Appears in a PivotTable
Grouping Dates in a PivotTable
Updating a PivotTable
Formatting and Charting a PivotTable
Creating Subtotals
Using Database Functions
Using Lookup Functions
Grouping and Outlining a Worksheet
What-If Analysis
Defining a Scenario
Creating a Scenario Summery Report
Using a One and Two-Input Data Table
Understanding Goal Seek
Using Solver
Advanced Topics
Hiding, Displaying, and Moving Toolbars
Customizing Excel's Toolbars
Creating a Custom AutoFill List
Changing Excel's Options
Password Protecting a Workbook
File Properties and Finding a File
Sharing a Workbook and Tracking Changes
Merging and Revising a Shared Workbook~~~6963~6967~~

Excel 2000~The Fundamentals
Starting Excel
Understanding the Excel Program Screen
Using Menus and Toolbars
Filling Out Dialog Boxes
Keystroke and Right Mouse Button Shortcuts
Opening and Saving a Workbook
Moving the Cell Pointer
Navigating a Worksheet
Entering Labels in a Worksheet
Entering Values in a Worksheet and Selecting a Cell Range
Calculating Value Totals with AutoSum
Entering Formulas
Using AutoFill
Previewing and Printing a Worksheet
Closing a Workbook and Exiting Excel
Editing a Workbook
Entering Date Values and using AutoComplete
Editing, Clearing, and Replacing Cell Contents
Cutting, Copying, and Pasting Cells
Moving and Copying Cells with Drag and Drop
Working with Absolute and Relative Cell References
Using the Paste Special Command
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Checking Your Spelling
Advanced Printing Options
Finding and Replacing Information
File Management
Inserting Cell Comments
Getting Help from Excel
Getting Help from the Office Assistant
Getting Help by Contents
Getting Help with the Help Index
Finding Help
Formatting a Worksheet
Formatting Fonts with the Formatting Toolbar
Formatting Values
Adjusting Row Height and Column Width
Changing Cell Alignment
Adding Borders
Applying Colors and Patterns
Using the Format Painter
Using AutoFormat
Creating a Custom Number Format
Creating, Applying, and Modifying a Style
Formatting Cells with Conditional Formatting
Merging Cells, Rotating Text, and using AutoFit
Creating and Working with Charts
Creating a Chart
Moving and Resizing a Chart
Formatting and Editing Objects in a Chart
Changing a Chart's Source Data
Changing a Chart Type and Working with Pie Charts
Adding Titles, Gridlines, and a Data Table
Formatting a Data Series and Chart Axis
Annotating a Chart
Working with 3-D Charts
Selecting and Saving a Custom Chart
Using Fill Effects
Mapping Data
Modifying a Map
Managing Your Workbooks
Switching Between Sheets in a Workbook
Inserting and Deleting Worksheets
Renaming and Moving Worksheets
Working with Several Workbooks and Windows
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
Adding Print Titles and Gridlines
Changing the Paper Size and Print Scale
Protecting a Worksheet
Hiding Columns,Rows and Sheets
Viewing a Worksheet and Saving a Custom View
Working with Templates
Consolidating Worksheets
More Functions and Formulas
Formulas with Several Operators and Cell Ranges
Using the Formula Palette to Enter and Edit Formulas
Creating and Using Range Names
Selecting Nonadjacent Ranges and Using AutoCalculate
Using the IF Function to Create Conditional Formulas
Using the PMT Function
Displaying and Printing Formulas
Fixing Errors in Your Formulas
Mathematical Functions (Reference)
Financial Functions (Reference)
Date and Time Functions (Reference)
Statistical Functions (Reference)
Database Functions (Reference)
Working with Lists
Creating a List
Using the Data Form to Add Records
Finding Records
Deleting Records
Sorting a List
Filtering a List with the AutoFilter
Creating a Custom AutoFilter
Filtering a List with an Advanced Filter
Copying Filtered Records
Using Data Validation
Automating Tasks with Macros
Recording a Macro
Playing a Macro and Assigning a Macro a Shortcut Key
Adding a Macro to a Toolbar
Editing a Macro's Visual Basic Code
Inserting Code in an Existing Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If?Then?Else Statement
Working with Other Programs and the Internet
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
Opening and Saving Files in Different Formats
Adding Hyperlinks to a Worksheet
Browsing Hyperlinks and using the Web Toolbar
Converting an Excel File to a Web Page
Data Analysis and PivotTables
Creating a PivotTable
Modifying a PivotTable's Structure
Adding a Page Field to a PivotTable
Grouping Dates in a PivotTable
Updating a PivotTable
Creating Subtotals
Using Database Functions
Using Lookup Functions
Grouping and Outlining a Worksheet
What-If Analysis
Defining a Scenario
Creating a Scenario Summery Report
Using a One and Two-Input Data Table
Understanding Goal Seek
Using Solver
Advanced Topics
Adding, Positioning, and Removing Toolbars
Creating and Using Custom Toolbars
Creating a Custom AutoFill List
Changing Excel's Options
Password Protecting a Workbook
File Properties and Finding a File
Sharing a Workbook and Tracking Changes
Merging and Revising a Shared Workbook~~~6963~6968~~

Ordering~~~~6963~6969~~

Excel Training Course by CustomGuide~Per Seat Licencing Available

Call 01223 894136 for quotes for NETWORK and ONLINE Solutions

Online training is Scorm and AICC compliant~~PER USER%3A ONLINE Course 12 month licence|!104348|Customizable Courseware 12 month licence|1479|Printable Quick References 12 month licence|1480|~6963~6970~access microsoft end user 2003~