Etopia Computer Training

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Excel Advanced IT Training Course

Duration:1 day
Price:£200.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Wed 7th Nov 18,  Thu 13th Dec 18,  Wed 16th Jan 19
Edinburgh Dates:

Dates above and cost (excludes VAT) are for joining a scheduled course. 

Or book Private Group from £395 + VAT or book 1-to-1 from £200 + VAT.

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 Intermediate courses, or have equivalent knowledge

Notes

Training is available on all versions