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 Office Systems Courses

Excel Expert

in Pass training (England)

Classes Training

Place:

London

Price:

£220 + VAT Special offers 

Duration:

1 Day

Start:

19/12/2008 other dates
See course programme

Requirements:

Participants on this course should have good knowledge of Excel, gained from prior attendance on an ... see more

Request free information
Pass trainingPass trainingPass training
training room Chalk Farm
More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
Pass training
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 Training Duration 1 Day
Method / place Contact course provider Classes in London where
Students per class 8
Suitability This course is suitable for existing users of Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time.
Course objectives To give users an extended knowledge of Excel’s advanced features. Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.
Requirements
Participants on this course should have good knowledge of Excel, gained from prior attendance on an “Excel Advanced” course or from a user environment.
Price £220 + VAT
Special offer + Support + Price details
Request this special offer here
Get direct information on how to enrol, venues and availability...

Office Systems courses (from other course providers)

 
Outlook Standard
Major Training Ltd
London - £220 + VAT
 
Outlook XP Fundamentals
2e2 Training
London - £199 + VAT
 
EUROPEAN COMPUTER DRIVING LICENSE - ECDL
London College of Management Studies
London - £250 + VAT
 
Microsoft Visio Professional Level 1
WWP Training Limited
London - £325 + VAT
 
Access Proficient
Pitman Training London
Blended - £366 + VAT
Compare the selected courses

Course programme

Excel Expert

Excel / Expert
 
Objective:                    To give users an extended knowledge of Excel’s advanced features.  Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.
 
Delegates:                  Maximum 8
This course is suitable for existing users of Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time.  Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an “Excel Advanced” course or from a user environment. Delegate numbers are restricted to 8, to ensure personal attention from the trainer.
 
Structure:                   PC for every delegate All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.
 
Duration:                1 day   9.30 am – 4.30 pm
Course Outline:

Excel Expert
·       Review Exercise

Auditing a Worksheet
·       Using Worksheet Auditing Tools
·       Data Entry Validation
·       Validating the Whole Worksheet
·       Auditing Data Dependency
·       Finding and Replacing Data

Working with Data Lists
·       Setting Up Lists
·       Sorting Lists
·       Filtering Lists
·       Using Forms

Data Management
·       Searching for Data with Advanced Filters
·       Compiling Consolidations
·       Summarising Data with Outlines
·       Querying a Database
·       Data Sources
·       Controlling Formatting and Layout
·       Refreshing External Data

PivotTables
·       Creating a PivotTable
·       Modifying a PivotTable
·       Creating a PivotTable Chart
·       Creating Interactive PivotTables for the Web

Using Analysis Tools
·       Goal Seeking
·       Using Solver
·       The Scenario Manager
·       Scenario Summaries
·       Merging Scenarios

Collaborating with Workgroups
·       Applying Worksheet Protection
·       Password Protecting a File
·       Changing Workbook Properties
·       Adding Comments to the Worksheet
·       Shared Workbooks
·       Tracking Changes
·       Resolving Conflicts
·       Merging Workbooks
·       E-mailing Workbooks for Review
 
 
Fee £220+ VAT
 

 
see the full course programme

on request

get more information on the programme directly from Pass training.

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

Venues and dates



Where London, 100a Chalk Farm Road
When Start: 19/12/2008 Finish: 19/12/2008 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 23/01/2009 Finish: 23/01/2009 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 12/02/2009 Finish: 12/02/2009 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 26/02/2009 Finish: 26/02/2009 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 12/03/2009 Finish: 12/03/2009 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 26/03/2009 Finish: 26/03/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 Pass training

Provider description
Pass training have been providing excellence in training for over 21 years. From Computer training to Personal Development and CPD for Accountants, pass training covers a wide range of courses. IT Training computer courses are all fully Microsoft certified to a gold standard and last between one and two days per skill level. They are aimed at teaching delegates features relevant to their jobs to enhance knowledge of the software and to maximise efficiency in the workplace. With no fewer then 37 different Computer courses you are almost guaranteed to find what you are looking for.Personal Development courses cover a variety of essential core skills.With over 80 courses to choose from you are spoilt for choice.From Appraisal interviewing to Stress; Thrive under pressure, pass training offers a wide variety of practical courses aimed at developing individuals and teams. All courses also incorporate their own discount structure based upon fees and quantity of bookings. Why not book today?
Advantages of studying with Pass training
Microsoft Certified certificate of attendance on Microsoft courses, &also get training manuals& a USB stick to record the days training to be recalled at home or back in the office. Regarding the CPD candidates, they will receive CPD points for computer courses as well as CPD courses to count towards their end of year total.Pass training have experienced&reliable trainers,constantly learning more so that you are at the fore front of each technical area. Pass also benefit from trainers that have real life experience,&so can truly go into great depth & detail to which you wish to know, even if it is not on the course syllabus. Trainers are carefully selected so we can ensure that they are not only great trainers, but approachable&easy to talk to also. Within this process we can supply professional,affordable,practical,intelligent, relevant training that will really help individuals&teams develop & grow as separate entities & also team entities for the greater good of all concerned.
Course provider history
Pass training have been established for over 21 years, and training in IT Computing, Personal Development and CPD. Pass training was set up as the training division for what is now Vantis Plc, and originally trained in the CPD for accountants with updates and topical courses. Pass training's computer training has its own established training rooms, with top of the range computers to enhance the learning experience. Whilst the Personal Development is headed by dynamic and charismatic team of individuals who inspire confidence and a well balanced learning environment by not only lecturing technique, but allowing active participation and practical situations to put what you are learning into immediate practise. Across the board Pass training are well known for interactive, dynamic and cost effective training, with a ruthless reputation for efficiency and customer satisfaction. This is why we are the correct and logical choice for so many, and are dedicated to encouraging you to join too.
Specialises in
Pass training specialise in Accountancy Software training, as well as Microsoft Office courses such as Excel and Word. We also have the benefit of expert lecturers who know how to interact and bring the best out of our PD courses, whilst boasting experienced up to date presenters for our CPD course both in updates and topical courses. It is by combining these fields with the best of experience and knowledge that we can bring you the very best learning experience to affect your working life in a positive way, and keep customers returning for this unique and refreshing training experience.

All courses

by Pass training on emagister.

See list of courses

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

Training related to Office Systems

 
International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina

Words related to the courses viewed: excel office management excel introduction microsoft office office 2007 excel training office manager microsoft excel excel vba excel advanced

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