Display & Accessibility Options

Skip to navigation

Skip to main content

Contact Us

Accessibility Statement

Text Only Version

Site map

A- A A+
You are here: Home > IT Training > Excel Advanced Level 2

Excel Advanced Level 2

Microsoft Office 2000, 2002, 2003

Next available Norwich date:  22 September 2010
Book Now

Course Aims:

This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Excel.

In particular, delegates will learn how to use what if analysis techniques, and perform formula auditing.  Additionally to manipulate, consolidate and chart data using the various techniques, functions and facilities available with Excel including Pivot Tables.

Assumed Knowledge:

Delegates must have a good working knowledge of Excel.  They must be regular users who are able to create, edit, format and print Excel spreadsheets.  They must be able to use basic calculations, functions and charts.  It is an advantage to have attended our Excel Advanced - Level 1 course.

Versions:

Microsoft Office 2000, 2002 and 2003

Excel 2007 Advanced Level 2 course profile 

What people say:

   

Good course today. I feel much more confident to go ahead and play / practice with excel.

Thanks

H J Heinz - Jan 2010

Special Offer

Book one person onto any two levels of Excel training and receive £30 off the total price.

Profile Outline:

Macros

  • Revision of macros
Goal Seek
  • Changing a single cell
  • Applying a global change
Scenario Manager
  • Creating scenarios
  • Editing scenarios
  • Showing scenarios
  • Summarising scenarios
Custom Views
  • Creating custom views
  • Using custom views
Auditing
  • Auditing Features
  • Precedents and Dependants
  • Tracing Errors & Invalid Data
Consolidating Data
  • Working with multiple sheets
  • Linking files with formulas
  • Paste special
  • Data consolidation

Working With Text Files

  • Importing text files
  • Text to columns
  • Text functions
Data Manipulation
  • Sorting data
  • Using subtotals
  • AutoFilter
  • Advanced filter
Pivot Tables
  • Using the pivot table wizard
  • Editing the pivot table
  • Drilling down in a pivot table
Advanced Calculations
  • Lookup functions
  • Cross-multiplication
  • Conditional calculations
Advanced Charting
  • Creating combination charts
  • Adding & removing data
  • Adding trend lines
  • Forecasting forward

DO NOT DELETE THIS TEXT
Profile Details:
  • Price: £165.00
  • Duration: 1 day
Norwich Dates:
  • 22 September 2010
    Book Now
  • 21 October 2010
    Book Now
  • 17 November 2010
    Book Now
  • 15 December 2010
    Book Now
Training Options
People who attended this course, also booked:
Information & print: