Onsite training solutions for Microsoft Excel

  • Excel 2003
  • Excel 2007 & 2010

Course Level

Introductory
Intermediate
Advanced
  • Tab 1
  • Tab 2
  • Tab 3

Excel 2003

THE SCREEN

  • Row and Column Headings
  • The Active Cell
  • Cell Address and Formula Bar
  • Mode Indicator
  • Sheet Tabs
  • Renaming Sheet Tabs
  • Changing the View
  • Inserting & Delleting a Sheet

CREATING A NEW SPREADSHEET

  • Open a New Workbook File
  • Open an Existing Workbook
  • Saving a Workbook
  • Closing Workbooks
  • Moving in the Worksheet

ENTERING TEXT AND LABELS

  • Text Entry
  • Alignment
  • Align Text Using the Button Bar
  • Align Text Using the Menu Bar
  • Centre Headings over Columns

ENTERING AND FORMATTING VALUES

  • Entering Values
  • Formatting Values using the Button Bar
  • Formatting Values using the Menu Bar

ENTERING FORMULAE

  • Spreadsheet Mathematics
  • Circular References
  • Editing Calculations

WORKING WITH RANGES

  • Selecting a Range using the Mouse
  • Selecting a Column or a Row
  • Selecting a Range using the Keyboard
  • Selecting Non-Continuous Areas

USING BUILT IN FUNCTIONS

  • Auto Sum

TEXT ENHANCEMENTS

  • Changing Fonts and Attributes
  • Text Enhancements
  • Wrapping Text within Cells

FORMATTING THE SHEET

  • Column Width
  • Resizing Columns
  • Row Height
  • Borders and Shading
  • Format Painter
  • Headers and Footers

MOVING AND COPYING

  • Cut or Move Cells
  • Copy Cells
  • Paste Cell Contents
  • Drag and Drop
  • Auto Fill
  • Fill Right/Left or Down/Up

PREVIEWING AND PRINTING A DOCUMENT

  • Previewing a Document
  • Printing A Document

CHARTS AND GRAPHS

  • Introduction to creating charts
  • Modifying charts

 

 

 

Excel 2003

REVIEW OF BASIC FORMULAE

  • Review of basic formula + BODMAS
  • Review of AutoSum and shortcuts

CELL REFERENCING

  • Using a Name
  • Naming Ranges
  • Moving using Range names
  • Absolute and Relative Cell Referencing
  • Making a Cell Address Absolute

CONDITIONAL PROCESSING

  • IF
  • Nested IF
  • Nested AND and OR
  • The Function Wizard
  • Using Sumif and Countif Functions
  • Inserting/Editing Comments
  • Conditional Formatting

EDITING LARGE WORKSHEETS

  • Setting Panes with Freeze
  • Splitting Worksheets
  • Creating an automatic Outline

DATABASES

  • Creating a Database
  • Entering Records
  • Adding Records Using Data Form
  • Creating a Calculated Field
  • Searching the Database
  • Finding Records using the Data Form
  • Filtering Records
  • Totalling Filtered Lists
  • Summarising Data in a Database List
  • Database Statistical Functions

LINKING DATA

  • Linking cells within spreadsheets
  • Linking cells between spreadsheets
  • Changing cell references

CREATING STYLES

  • Creating a Number Code
  • Removing a Code

PROTECTING CELLS

  • Protecting Cells in a Sheet or File
  • Protecting the Sheet
  • Protecting the Workbook
  • Locking Individual Cells
  • Hiding Formulae

 

Excel 2003

VLOOKUP and HLOOKUP

  • Creating catalogues
  • V vs H Lookup

ADVANCED LIST MANAGEMENT 

  • Advanced Filter
  • Subtotals.
  • Data validation.
  • Database functions
  • Data Forms

CUT, COPY AND PASTE

  • Dynamic Data Exchange
  • Using Excel as a Client
  • Using Excel as a Server
  • Editing a DDE Link
  • Object Linking and Embedding
  • Object Linking
  • Object Embedding
  • Inserting an Object

OUTLINES

  • Collapsing and Expanding the Outline
  • Creating an Outline using the Query and Pivot Toolbar
  • Clearing the Outline

CREATING A VIEW

  • Creating a View
  • Storing the View

PIVOT TABLES 

  • Creating a pivot table.
  • Rearranging pivot tables.
  • Formatting pivot tables.
  • Pivot charts.

CONSOLIDATION OF DATA

  • Consolidating the Data by Position
  • 3D Functions/Formulae

AUTOMATING SPREADSHEETS 

  • Recording and running macros
  • Multiple Functions Database Functions DSum, DAverage,DMax,DProduct

TEMPLATES 

  • Using templates.
  • Built-in templates.

ADVANCED FILTER

  • Setting up the Criteria Range
  • Applying the Advanced Filter

ANALYTICAL OPTIONS 

  • Goal Seek and Solver.
  • Scenarios.
  • Views.
  • Reports

 

Course Level

Introductory
Intermediate
Advanced
  • Tab 1
  • Tab 2
  • Tab 3

Excel 2007 & 2010

THE SCREEN

  • The Ribbon
  • The Quick Access toolbar
  • Row and Column Headings
  • The Active Cell
  • Cell Address and Formula Bar
  • Mode Indicator
  • Sheet Tabs / Renaming Sheet Tabs
  • Changing the View
  • Inserting & Deleting a Sheet

CREATING A NEW SPREADSHEET

  • Open a New Workbook File
  • Open an Existing Workbook
  • Saving a Workbook
  • Save Workbook as Compatible Format
  • Closing Workbooks
  • Moving in the Worksheet

ENTERING TEXT AND LABELS

  • Text Entry
  • Alignment
  • Menu Bar
  • Centre Headings over Columns

ENTERING AND FORMATTING VALUES

  • Entering Values
  • Formatting Values using the Button Bar

ENTERING FORMULAE

  • Spreadsheet Mathematics
  • Circular References
  • Editing Calculations

WORKING WITH RANGES

  • Selecting a Range using the Mouse
  • Selecting a Column or a Row
  • Selecting a Range using the Keyboard
  • Selecting Non-Continuous Areas

USING BUILT IN FUNCTIONS

  • Auto Sum

TEXT ENHANCEMENTS

  • Changing Fonts and Attributes
  • Text Enhancements
  • Wrapping Text within Cells

FORMATTING THE SHEET

  • Column Width
  • Resizing Columns
  • Row Height
  • Borders and Shading
  • Format Painter
  • Headers and Footers

MOVING AND COPYING

  • Cut or Move Cells
  • Copy Cells
  • Paste Cell Contents
  • Drag and Drop
  • Auto Fill
  • Fill Right/Left or Down/Up

PREVIEWING AND PRINTING A DOCUMENT

  • Previewing a Document
  • Printing A Document

CHARTS AND GRAPHS

  • Introduction to creating charts
  • Modifying charts

 

 

Excel 2007 & 2010

REVIEW OF BASIC FORMULAE

  • Review of basic formula + BODMAS
  • Review of AutoSum and shortcuts

CELL REFERENCING

  • Using a Name
  • Naming Ranges
  • Moving using Range names
  • Absolute and Relative Cell Referencing
  • Making a Cell Address Absolute

CONDITIONAL PROCESSING

  • IF
  • Nested IF
  • Nested AND and OR
  • The Function Wizard
  • Using Sumif and Countif Functions
  • Inserting/Editing Comments
  • Conditional Formatting

EDITING LARGE WORKSHEETS

  • Setting Panes with Freeze
  • Splitting Worksheets
  • Creating an automatic Outline
  • Grouping Rows or Columns

CONDITIONAL FORMATTING

  • Applying conditional formatting rules
  • Applying pre-set styles

DATABASES

  • Creating a Database
  • Entering Records
  • Adding Records Using Data Form
  • Creating a Calculated Field
  • Searching the Database
  • Finding Records using the Data Form
  • Filtering Records
  • Totalling Filtered Lists
  • Summarising Data in a Database List
  • Database Statistical Functions

LINKING DATA

  • Linking cells within spreadsheets
  • Linking cells between spreadsheets
  • Changing cell references

CREATING STYLES

  • Creating a Number Code
  • Removing a Code

PROTECTING CELLS

  • Protecting Cells in a Sheet or File
  • Protecting the Sheet
  • Protecting the Workbook
  • Locking Individual Cells
  • Hiding Formulae

 

Excel 2007 & 2010

VLOOKUP and HLOOKUP

  • Creating catalogues
  • V vs H Lookup

ADVANCED LIST MANAGEMENT

  • Advanced Filter
  • Subtotals.
  • Dynamic Lists (Tables)

DATABASE FUNCTIONS

  • DSum, DAverage,DMax,DProduct

OUTLINES

  • Collapsing and Expanding the Outline
  • Clearing the Outline

CREATING A VIEW

  • Creating a View
  • Storing the View

DATA VALIDATION

  • Setting Entry Rules
  • Creating Lists
  • Displaying errors

PIVOT TABLES

  • Creating a pivot table.
  • Rearranging pivot tables.
  • Formatting pivot tables.
  • Pivot charts.

CONSOLIDATION OF DATA

  • Consolidating the Data by Position
  • 3D Functions/Formulae

TEMPLATES

  • Using templates.
  • Built-in templates.

ANALYTICAL OPTIONS

  • Goal Seek and Solver.
  • Scenarios.
  • Views.
  • Reports

PROTECTING & SHARING FILES

  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Inserting comments

MACROS

  • Recording Macros
  • Running Macros
  • Assigning Macros to Quick Access Toolbar