Etopia Computer Training
IT Computer Training Experts
Discounts of 25% & Tailored from £295!
25% Off Microsoft Application Courses!

Upcoming Courses

Call for any late availability offers on these upcoming courses.

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Excel Advanced 2002/3

Duration:1 day
Price:£250.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Wed 29th Feb 12,  Fri 30th Mar 12,  Mon 30th Apr 12,  Thu 31st May 12,  Thu 28th Jun 12,  Mon 30th Jul 12,  Thu 30th Aug 12
Edinburgh Dates:Wed 29th Feb 12,  Fri 30th Mar 12,  Mon 30th Apr 12,  Thu 31st May 12,  Thu 28th Jun 12,  Mon 30th Jul 12,  Thu 30th Aug 12

One Day Course

This course is intended to allow people with a good existing knowledge of working with Excel to become more expert in the application. Analysis, sorting and evaluating data within Excel using the more advanced functions from the basic course. The course allows people to return to work with a confidence that they can achieve tasks which require an advanced knowledge of spreadsheet applications

Course Aims to enable delegates to:

Have a full appreciation of Excel’s capabilities and functions with the aim of giving course attendees
expert levels of ability with their spreadsheets

Course Content

Advanced Formulas

  • Using Names
  • Decision-making
  • Nesting
  • Financial functions

Data Tables

  • Match and Index
  • Data Tables

Advanced List Managements

  • Subtotals
  • Data Validation
  • Database Functions
  • Data Forms

Analytical Options

  • Goal Seek and Solver
  • Scenarios
  • Views
  • Reports

Pivot Tables
 

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

Templates

  • Using templates
  • Built-in templates
  • Creating and managing templates
     

Importing and Exporting data
 

  • Importing data
  • Exporting data
  • Querying external databases

Macros
 

  • Recording and running a macro

Charts

  • Creating combination Charts

Advanced Web Topics

  • Creating interactive web spreadsheets
  • Pivot tables on the web

Follow-on Courses

Excel VBA – writing macros

Requirements before booking this course:

The course is designed for people wishing to expand on their current intermediate level knowledge of
Microsoft Excel. Anyone attending the course should either have attended both Excel Foundation and Excel
Advanced courses, or have equivalent knowledge

Notes

Training is available on all versions