Microsoft Excel 2007 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.