Microsoft Excel 2003 Level 2 Training Course

Managing Data

Pre-requisites:

Delegates should have knowledge of the topics from the Excel Level 1 course. It is essential that they have an understanding of and are able to use simple calculations.

Objectives:

  • Working with large worksheets and workbooks
  • Apply styles to data
  • Link data
  • Use date and text functions
  • Utilise Excel’s database and filtering features
  • Import and export data
  • Create charts / graphs
  • Protect data
  • Identify and locate formulas

Topics:

Working with Large Worksheets / Workbooks
  • Navigate around large worksheets
  • Styles
  • Freeze panes and split screen
  • Find and replace
  • Arranging worksheets/ workbooks
Linking Data
  • Linking data
  • Calculating across worksheets
  • Hyperlinks
  • Consolidate worksheets / workbooks
Functions
  • Date
  • Text
Importing and Exporting
  • Import data from another program
  • Copy and/or link data
Excel’s Database & Filtering Features
  • Creating a table/list
  • AutoFilter and advanced filter
  • Sorting
  • Sub totals and outlining
Create Charts / Graphs
  • Inserting a chart
  • Chart types
  • Formatting
  • Adding/removing data
Documenting & Auditing
  • Comments
  • Identifying formulas
  • Auditing
Protect Data
  • Lock cells
  • Applying passwords to a workbook

Topics not what you require? More information required? Contact us to discuss.

The topics in this course can be mixed and matched with Excel Level 1 and/or Excel Level 3 if required.


Prices

1 to 1 training: £299 + VAT per day
Each additional person: £40 + VAT per day

We come to you.  Courses take place at your offices.


Topics not what you require? More information required? Contact us to discuss. The topics in this course can be mixed and matched with Excel Level 2 and/or Excel Level 3 if required.