Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Go to homepage The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: btec advanced diploma advanced excel course london excel courses london advanced illustrator course excel introduction excel courses in london advanced english course introduction to excel microsoft office microsoft excel
Homepage > IT, Computing, Telecommunications > PC Applications > Excel

Excel Advanced

in Pass training (England)

Classes Training

Place:

London, London,...

Price:

£200 + VAT Special offers 

Duration:

1 Day

Start:

17/09/2008 other dates
See course programme

Requirements:

Participants on this course should have a good working knowledge of Excel, gained from prior attenda

Request free information
Pass trainingPass trainingPass training
training room Chalk Farm
next image

Pass training

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

see more

Contact course provider

 

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 Inhouse / Classes in London, London,... where
Suitability This course is suitable for existing users of Excel who want to gain further in-depth knowledge in a short space of time.
Course objectives To give users an extended knowledge of Excel’s advanced features and functions. Delegates will learn how to manage, automate and customise workbooks.
Requirements
Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an Excel Intermediate course or from pass.
Price £200 + VAT
Special offer + Support
Request this special offer here
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel Advanced
Major Training Ltd
London - £220 VAT inc.
 
Advanced Microsoft Excel 2007™
Reed Learning
London - £275 VAT inc.
 
Excel 2007 Advanced
Sales 101 Ltd
Online - £125 + VAT
 
Microsoft Excel Vba Programming
WWP Training Limited
London - £650 + VAT
 
Microsoft Excel 2003, 2007, XP Advanced
Alpha Training
- Price: On request
Compare the selected courses
+ excel Courses + Excel Courses in London + Courses in London + Pass training Courses

Course programme

Excel Advanced
 
 
Excel / Advanced
 

 
Objective:                    To give users an extended knowledge of Excel’s advanced features and functions.  Delegates will learn how to manage, automate and customise workbooks.
 
Delegates:                    Maximum 8
 
This course is suitable for existing users of Excel who want to gain further in-depth knowledge 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 Intermediate” 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
Further Training:          Excel Expert
 

 
Course Outline:
 
Excel Advanced
·       Review Exercise
 
Custom Formatting
·       Formatting Numbers; Using Custom Formats
 
·       Custom Number Format Sections
 
·       Custom Number Format Codes
 
·       Custom Date Format Codes
 
·       Formatting SpeedKeys; Using Conditional Formats
 
Importing and Exporting Data
·       Using Paste Special
 
·       Object Linking and Embedding
 
·       Opening Text Files in Excel
 
·       Importing a Text File into Excel
 
·       Importing Data from Web Pages
 
Templates and Add-Ins
·       Creating Workbook Templates
 
·       Custom Templates; Storing Templates
 
·       The Default Template
 
·       Loading Add-In Programs
 
Working with Multiple Workbooks
·       Creating Custom Views
 
·       Creating a Workspace File
 
·       Using Workspace Files
 
·       Linking Workbooks
 
·       Creating Formulae to Link Data
 
Printing Workbooks
·       Printing Multiple Worksheets
 
·       Printing Multiple Workbooks
 
Lookup and Reference Functions
·       Using the LOOKUP Function
 
·       Using the VLOOKUP Function
 
·       Using the HLOOKUP Function
 
·       Preventing LOOKUP Errors
 
Working with Named Ranges
·       Creating Range Names
 
·       Using the Go To Command
 
·       Range Names in Calculations
 
Working with Toolbars
·       Displaying Different Toolbars
 
·       Creating a New Toolbar
 
Using Macros
·       Understanding Macros
 
·       Recording a Basic Macro
 
·       Relative References
 
·       Running a Macro
 
·       Assigning a Macro to a Toolbar
 
·       Button Image Editor
 
·       Editing a Macro
 
·       Macro Virus Protection
 
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: 17/09/2008 Finish: 17/09/2008 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 02/10/2008 Finish: 02/10/2008 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 16/10/2008 Finish: 16/10/2008 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 28/10/2008 Finish: 28/10/2008 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 13/11/2008 Finish: 13/11/2008 See calendar
 
Get direct information on how to enrol, venues and availability...
 

Course provider details

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?
Course provider history
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.
Get direct information on how to enrol, venues and availability...

Information related to Excel

More related courses
Excel 2007 Advanced £30 VAT inc. Distance
Microsoft Excel Advanced £300 + VAT Distance
Microsoft Excel Advanced £495 + VAT London
Excel 2002/3 - Intermediate £220 + VAT London
Excel 2007 Training £195 VAT inc. Distance
+ excel Courses + Excel Courses in London + Pass training Courses
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