nvq 3 health and social care itq level 3 itq level 2 nvq level 3 courses excel courses london nvq 3 plumbing btec advanced diploma nvq level 4 courses ilm level 3 certificate in first line management nvq level 3 health and social care

Homepage › IT, Computing, Telecommunications Courses › PC Applications Courses › Excel Courses

Excel Level 3 Advanced

in Pitman Training (England)

Classes Course

Price:

£175 + VAT

Special offers/ funding

Discounts are available when 3+ places are booked for the same scheduled course on the same date. We also offer customised courses at a daily rate of £750 +VAT for up to 8 delegates

Price details

Cost includes all courseware and refreshments. Delegates will also receive an attendance certificate.

Special offers

Duration:

1 Day

Start:

consult dates and times
See course programme

Requirements:

Delegates should be experienced users of Microsoft Excel.

Course objectives:

This course is for those who are familiar with using Microsoft Excel and want to develop their knowledge of the application. You will learn advanced features including finding trends in data, deleting a custom toolbar and menu; use AutoFilter, create pivot tables, audting worksheets, working collaboratovely and creating macros

More courses Subject area

Place

Request information

Contact directly and with no obligation with

Pitman 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

*Name *Surname

*E-mail

*Country/ region *Area/ County

*I would like more information on

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

Suitability This course is for those who are familiar with using Microsoft Excel and want to develop their knowledge of the application.

Course objectives This course is for those who are familiar with using Microsoft Excel and want to develop their knowledge of the application. You will learn advanced features including finding trends in data, deleting a custom toolbar and menu; use AutoFilter, create pivot tables, audting worksheets, working collaboratovely and creating macros

Requirements	Delegates should be experienced users of Microsoft Excel. see more

Price	£175 + VAT Special offer + Price details Discounts are available when 3+ places are booked for the same scheduled course on the same date. We also offer customised courses at a daily rate of £750 +VAT for up to 8 delegates Price details Cost includes all courseware and refreshments. Delegates will also receive an attendance certificate. Request this special offer here

back
Course programme
ex-students and opinions

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

Excel courses (from other course providers)

Excel Level 1 (Beginner)
Pitman Training Guildford
Surrey - £195 + VAT

Microsoft Excel - Advanced
Mekon Creatives
Surrey - £295 + VAT

Excel 2007 Advanced
We Teach You
Distance - £30 + VAT

Microsoft Excel 2003, 2007, XP Advanced
Alpha Training
- Price: On request

Excel 2007 Training
UK Open Learning Ltd
Distance - £195 + VAT

Compare the selected courses

+ excel Courses + Excel Courses in Surrey + Courses in Surrey + Pitman Training Courses

Course programme

Excel Level 3 Advanced

Lesson 1:
Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Customize Access to Excel Commands
Topic 1D: Apply Conditional Formatting
Topic 1E: Add Data Validation Criteria
Topic 1F: Update a Workbook's Properties
Topic 1G: Modify Excel's Default Settings
Lesson 2:
Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures
Lesson 3:
Auditing Worksheets
Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Locate Errors in Formulas
Topic 3D: Locate Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Group and Outline Data
Lesson 4:
Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Develop a PivotTable© Report
Topic 4E: Develop a PivotChart© Report
Lesson 5:
Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6:
Importing and Exporting Data
Topic 6A: Export to Microsoft Word
Topic 6B: Import a Word Table

see the full course programme

back
more information
ex-students and opinions

on request

get more information on the programme directly from Pitman Training.

Request information for free

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

Ex-students

back
Course programme
more information

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

Provider description

Pitman Training offers courses in Microsoft Office 2003? 2007 and business skills. Our course timetable includes courses such as Minute Taking, Time Management and Telephone Skills. Our modern, well equipped training centre is located in Central Kingston upon Thames. This superb learning environment is supported by highly trained staff and outstanding course materials.

The cost of our one day courses is £175 for Microsoft Office and £230 for Business Skills. The cost includes all courseware and refreshments.

Pitman Training is operated in Kingston by Use It Ltd who have been delivering business training to the corporate and public sector for many years. This partnership allows clients to access an extensive range of courses that can be delivered at their site or at our premises.

We cover the complete training project life cycle from training needs analysis, through design, organisation, delivery and post course assessment of results. Our training programmes can be Pitman 'off the shelf' products or tailored precisely to, designed to meet key business objectives.

All courses

by Pitman Training on emagister.

See list of courses

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

Training related to Excel

More related courses

Microsoft Excel 2007 £60 + VAT Multimedia

Microsoft Excel Advanced £300 + VAT Distance

Excel 2000 Mos £75 + VAT Online

Microsoft Excel 2003 - Entry Level to Proficient User £24 + VAT Online

+ excel Courses + Excel Courses in Surrey + Pitman Training Courses

Most searched for in Excel

Excel Level 3 Advanced

in Pitman Training (England)

Request information

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

Course details

Excel courses (from other course providers)

Course programme

Excel Level 3 Advanced

on request

Ex-students

Opinions

opinions

On Pitman Training

Provider description

All courses

Training related to Excel

More related courses

Most searched for in Excel

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