Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
  Most popular search | Share this page  
open My list: 0 courses
Homepage IT, Computing, Telecommunications Courses PC Applications Courses Excel Courses

Microsoft Excel Advanced

in Etopia Solutions (Scotland)

Classes Course

Place:

Glasgow, Edinburgh

Price:

£250 + VAT Special offers 

Duration:

1 Day

Start:

12/01/2009 other dates
See course programme

Requirements:

The course is designed for people wishing to expand on their current intermediate level knowledge ofMicrosoft ... see more

Request free information

Course objectives:

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

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
Etopia Solutions
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 1 Day
Method / place Contact course provider Inhouse / Classes in Glasgow, Edinburgh where
Suitability This course is intended to allow people with a good existing knowledge of working with Excel to become more expert in the application.
Course objectives Have a full appreciation of Excel's capabilities and functions with the aim of giving course attendees expert levels of ability with their spreadsheets
Requirements
The course is designed for people wishing to expand on their current intermediate level knowledge ofMicrosoft Excel. Anyone attending the course should either have attended both Excel Foundation and ExcelAdvanced courses, or have equivalent knowledge.
Price £250 + VAT
Special offer
Request this special offer here
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Microsoft Excel Training
Net Resources Ltd
Edinburgh - £279 + VAT
 
Microsoft Excel 2003, 2007, XP Advanced
Alpha Training
- Price: On request
 
Microsoft Excel Advanced
Prolog Training
Distance - £300 + VAT
 
Microsoft Excel 2007
Career Vision Training Ltd
Multimedia - £60 + VAT
Compare the selected courses

Course programme

Microsoft Excel Advanced

Microsoft Excel Advanced
 

Duration:1.00 day
 

Price:£250.00
 

Locations:Glasgow, Edinburgh
 

Glasgow Dates:Fri 28th Nov
 

Edinburgh Dates:Wed 17th Dec
 

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 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
 

see the full course programme

on request

get more information on the programme directly from Etopia Solutions.

Request information for free
Get direct information on how to enrol, venues and availability...
 

Venues and dates



Where Glasgow, Lord Hope Building 141 St James Road
When Start: 12/01/2009 Finish: 12/01/2009 See calendar
 
Where Edinburgh, 16 St. Mary Street see map
When Start: 16/02/2009 Finish: 16/02/2009 See calendar
 
Where Glasgow, Lord Hope Building 141 St James Road
When Start: 13/03/2009 Finish: 13/03/2009 See calendar
 
Where Edinburgh, 16 St. Mary Street see map
When Start: 17/04/2009 Finish: 17/04/2009 See calendar
 
Where Glasgow, Lord Hope Building 141 St James Road
When Start: 26/05/2009 Finish: 26/05/2009 See calendar
 
Where Edinburgh, 16 St. Mary Street see map
When Start: 26/06/2009 Finish: 26/06/2009 See calendar
 
Where Glasgow, Lord Hope Building 141 St James Road
When Start: 28/07/2009 Finish: 28/07/2009 See calendar
 
Where Edinburgh, 16 St. Mary Street see map
When Start: 17/08/2009 Finish: 17/08/2009 See calendar
 
Where Glasgow, Lord Hope Building 141 St James Road
When Start: 25/09/2009 Finish: 25/09/2009 See calendar
 
Where Edinburgh, 16 St. Mary Street see map
When Start: 28/10/2009 Finish: 28/10/2009 See calendar
 
Where Glasgow, Lord Hope Building 141 St James Road
When Start: 18/11/2009 Finish: 18/11/2009 See calendar
 
Where Edinburgh, 16 St. Mary Street see map
When Start: 07/12/2009 Finish: 07/12/2009 See calendar
 
Get direct information on how to enrol, venues and availability...
 

Ex-students

 
Opinions
 
Have you attended this course?

Voice your opinion and help thousands of other users

opinions

from users who have attended
this course.
Get direct information on how to enrol, venues and availability...
 

On Etopia Solutions

Provider description
Etopia are based in Glasgow and provide training courses in Glasgow, Edinburgh, and all around Scotland - and often in other parts of the UK.

We offer closed courses, public schedule courses and consultancy on software applications.

Etopia Consultants are both skilled and experienced.

Etopia enable your staff to release the potential of current or forthcoming software.

We achieve results through:

* A unique 'mentor' service, building a partnership between in-house client skills and Etopia expertise
* Building tailored solutions that match the unique requirements of each client
* Flexible event delivery across the UK
Advantages of studying with Etopia Solutions
Since Etopia focus on the APPLICATION of business software, our courses are all geared to meet real-life demands of people using computers. Rather than teaching in too little detail (or too much) the available large number of functions of, say, Microsoft Excel, we aim to teach people what they need to know to perform their work better. An expert trainer is the best judge of what people really need to know - so Etopia trainers apply their extensive knowledge of what any application can do - in order to make everyday differences to individual's workloads.
Course provider history
Since 2001, Etopia have been offering courses to both the business and public sector markets. Based in Glasgow, with a training centre in Edinburgh too, Etopia have built a reputation on providing training that meets real needs. Etopia has built up a client base that includes being chosen as regular providers to, for example, HBoS, Fife Council, Martin Currie, and Scottish and Newcastle. In addition to this our clients include organisations like Housing Associations, and many other private and public sector clients.
Specialises in
Closed courses specifically for one organisation, public courses in Glasgow and Edinburgh. Etopia can bring laptops to client sites for training if it helps.

All courses

by Etopia Solutions on emagister.

See list of courses

Get direct information on how to enrol, venues and availability...

Training related to Excel

More related courses
Excel 2007 Training £195 + VAT Distance
Excel - Intermediate I £360 + VAT Distance
Excel 2007 Advanced £30 + VAT Distance
Excel 2007 Advanced £125 + VAT Online
 
International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina

Words related to the courses viewed: microsoft office microsoft excel microsoft office specialist

emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights