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

Excel 2002/3 - Intermediate

in Laidlaw & Constable (England)

Classes Course

Place:

London

Price:

£220 + VAT

Duration:

1 Day

Start:

01/12/2008 calendar
See course programme

Requirements:

To fully benefit from this course, attendees are expected to be confident users of Excel and be familiar ... see more

Request free information

Course objectives:

This hands-on course is designed to enhance the skill of Excel users who have set up simple workbooks including basic calculations. Delegates will be introduced to the techniques associated with large and multiple spreadsheet design, including using links, worksheet consolidation and more complex functions and formulae.

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
Laidlaw & Constable
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 Classes in London where
Suitability Microsoft Excel Intermediate is designed for users who are keen to extend their understanding and knowledge of the software. In particular, delegates should be familiar with the various data types, basic formulae and functions, the differences between Absolute & Relative Cell References and opening, closing and saving files.
Course objectives This hands-on course is designed to enhance the skill of Excel users who have set up simple workbooks including basic calculations. Delegates will be introduced to the techniques associated with large and multiple spreadsheet design, including using links, worksheet consolidation and more complex functions and formulae.
Requirements
To fully benefit from this course, attendees are expected to be confident users of Excel and be familiar with the topics covered in the Excel Foundation course.
Price £220 + VAT
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel Intermediate
Pass training
London - £210 + VAT
 
Intermediate Microsoft Excel 2007™
Reed Learning
London - £275 + VAT
 
Excel 2003 Intermediate
2e2 Training
London - £495 + VAT
 
Excel Intermediate
Major Training Ltd
London - £220 + VAT
 
Microsoft Excel Vba Programming
WWP Training Limited
London - £650 + VAT
Compare the selected courses

Course programme

Excel 2002/3 - Intermediate
Excel 2002/3 Intermediate
At the completion of the course you should be able to:

· Set up spreadsheet models across multiple worksheets
· Work with linked workbooks
· Combine data in separate worksheets/workbooks using data consolidation
· Apply workbook and worksheet protection
· Apply names to ranges of cells or values
· Use the range of Paste Special options
· Use more advanced functions including logical and lookup functions
· Set up a simple database (list/table)
· Manage a database with sorts, filters and advanced filters
· Add data to an existing chart
· Use a range of advanced chart formatting techniques
· Use the various printing features to produce a variety of reports
Working With Linked Worksheets/Workbooks
Copy/Move/Rename/Insert/Delete Worksheet(s) · Grouping Worksheets · Hide & Unhide Worksheets · Formulae Using Data from Multiple Worksheets
Protection
Password Protect a Workbook  · Protect Workbook Structure  · Protect All/Part of a Worksheet
Consolidation
Consolidating Data with Identical/Different Layout
Range Names
Create or Define Range Names  · Use Range Names in Formulae
Paste Special
Paste Special to Copy Formulae/Formats/Validations · Paste Special for Arithmetic & Transpose Options
Logical & Lookup Functions
Use the IF/AND/OR/NOT Functions  · Nested Functions  · Use VLOOKUP/HLOOKUP Functions · Use the Insert Function Feature
Database (List) Features
Create a Database (List) · Use Data Forms With List Data  · Sort List Data  · Select Rows Using AutoFilter and Custom AutoFilter · Use Advanced Filter Feature for Complex Selection · Large Worksheet Viewing Options
Chart Editing Techniques
Add Data to a Chart  · Chart Options
Printing Techniques
Printing a Selection · Setting the Print Area · Setting Margins with Page Setup · Specifying Print Title Rows/Columns · Printing Row/Column Headings & Gridlines
see the full course programme

on request

get more information on the programme directly from Laidlaw & Constable.

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

Venues and dates



Where London, Suite 501, Albany House, 324-326 Regent Street
When Start: 01/12/2008 Finish: 01/12/2008 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 Laidlaw & Constable

Provider description
About Laidlaw & Constable

In today's competitive global market place, the need for skilled people has become increasingly acute as companies seek to add value within the knowledge economy. As a company, we are committed to working with our clients to help harness and develop the personal skills of their staff. Our aim is to encourage individuals to fulfil their potential and maximise their efficiency.
Laidlaw & Constable's Mission Statement

Our Purpose
Laidlaw & Constable Ltd is a private limited company committed to providing high value training and consultancy services to organisations within the private, public and non-profit sectors. Our purpose is simple: it is to deliver practical, innovative training solutions and consultancy services designed to add value for our clients by helping develop one of their most important assets - their people.

Our Ethos
At Laidlaw & Constable a culture exists that encourages and promotes openness, originality and independent thought. Internally we strive to be an energetic and enthusiastic team that thrives on providing a high quality professional and flexible service. We endeavour to find innovative ways to meet our clients' requirements and put originality before traditional thought. We aim to work openly and honestly with all stakeholders to ensure the organisation and team work in a seamless and efficient manner - "together making it happen".

Our Vision
Our long-term vision is to:

* Raise our company profile to become a quality focused market leading provider in the training & consultancy sector.
* Create an environment, which is focused on continual improvement, engaged in evaluating and implementing best practice methods, business excellence and quality of service provision.
* Continually strive towards a culture of openness, creativity, honesty and integrity amongst all stakeholders.
* Create a professional working environment with training consultants confident to help our clients make positive lasting and substantial improvements to their company's performance.
* Build a great company that is able to attract, develop, excite and retain exceptional people.

Our Values
We will achieve our purpose by working in accordance with the following core values:

* Being Professional - we will listen to our clients and make every endeavour to understand, achieve and exceed their expectations. We will respond immediately and will always look for ways to improve what we do.
* Being Innovative and Creative - by encouraging fresh ideas, following them through and not being afraid to try something new.
* Adopting an Open and Sharing Culture - by being open and honest with all stakeholders and adopting an open-book approach to business. And by sharing information to create efficiency and developing effective business relationships
* Employing the Right People - by ensuring our team has the right skills and experience to say with confidence 'we know what we're doing'. By a commitment to training and developing our people.

All courses

by Laidlaw & Constable on emagister.

See list of courses

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

Training related to Excel

 
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