Go to XChangeTraining Home Page
Main XChange Training Logo White White
Link to Desktop Publishing Training courses offered by XChangeTraining Book a creative publishing course by clicking here Desktop Publishing Training Resources Learn more about us and our training centre in central London, UK Contact XChangeTraining
Spacer
Spacer between logo and content

Microsoft Excel - Intermediate Training Course— Bespoke

Microsoft Excel is the standard spreadsheet application, an essential component of the Microsoft Office Suite. Excel provides comprehensive tools to help you create, analyze, and share spreadsheets, and its powerful, enhanced formatting features allow users to analyze and visualize data through the creation of graphs and charts.

In this one day intermediate course on Microsoft Excel, it is assumed that you already have a basic understanding of the application. From this point we move on to more advanced use of the application, examining different ways to format and present information using Excel. You will be shown how to use both databases and charts to analyse data, and how to capitalise on time-saving features of Excel such as the use of templates, which will have an immediate and positive impact on your productivity.

By the end of this course you'll be an advanced user of Microsoft Excel and will feel confident using all the sophisticated features of this powerful application.

Arrow style bullet pointInformation on Pricing, Location and Booking for this course.
Arrow style bullet pointOther Microsoft Excel courses

Spacer image on Microsoft Excel training at XChangeTraining page
Microsoft Excel training at XChangeTraining
 
Enquire about or book
this course here
Horizontal Red Line

Microsoft Excel - Intermediate Training Course Outline

The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.

Automating Excel
-Number formatting and creating custom number formats
-Using AutoFormats and text formats
-Find and Replace, Zoom, AutoCorrect
-The Function Wizard
-Linking Excel and Word

Customising Excel
-Toolbars, menus and views
-Workspaces

Using workbooks
-Creating workbook templates
-Working with multiple worksheets

Working with formulae and functions
-Conditional formulae
-Prevention of rounding errors
-Enhanced statistical functions

Creating Charts
-Chart types
-Chart formatting features
-Use of trends
-Creating an embedded chart
-Using graphic objects to enhance worksheets and charts

Spacer image

Working with databases
-Setting up lists
-Finding and organizing information by filtering, sorting and subtotaling
-Enhanced list functionality

Special features
-The Research Task pane
-The use of PivotTable ®Dynamic Views to summarize and analyze data

Document distribution
-Excel for Internet and intranet
-Security and worksheet protection

Extended technologies
-Goal Seek
-Scenario Manager
-Solver§

Horizontal Red Line

Related Microsoft Excel training courses — Bespoke

Below you'll find an up-to-date list of related bespoke training courses in London or throughout the UK offered by XChange Training. Just click on a link to view course details:

Arrow style bullet pointMicrosoft Outlook - Introduction Training Course
Arrow style bullet pointMicrosoft PowerPoint - Introduction Training Course
Arrow style bullet pointMicrosoft Project - Introduction One Day Training Course
Arrow style bullet pointMicrosoft Visio - Introduction One Day Training Course
Arrow style bullet pointMicrosoft Word - Introduction Training Course

  [For Pricing, Location and Booking information click on a course link above.]

 

Horizontal Red Line

Advantages of learning Microsoft Excel with XChangeTraining

-Our Microsoft Excel trainers are experienced professionals with excellent knowledge of all aspects of the Microsoft Office suite.
-It's bespoke and solutions based: before you come to XChange Training we agree the course content with you based on your needs.
-We take the time to work specifically on any files you bring along to the course, ensuring that you see benefits to your workflow immediately.
-XChange training focuses on real tasks that reflect how the software is used in professional situations.
-On-site and off-site training is available for the whole UK.
-Free email support service for 3 months after course.
-We get consistently good feedback from our clients.
 Read client testimonials...

Horizontal Red Line Spacer

Training Pricing

On-site course pricing
Prices include a set of course notes per trainee, 3 months telephone and/or e-mail support service after the course and all refreshments including a light lunch if held at the training centre.

For training courses outside of London a standard return train fare and/or taxi fare may be applicable.

Training centre pricing
Pricing for training at the Britton Street facility:
1 person £429 for a 1 day course*
2 people £529 for a 1 day course*
3 people £629 for a 1 day course
4 people £729 for a 1 day course
5 people £829 for a 1 day course
6 people £929 for a 1 day course
All prices subject to VAT

 

Training Centre address
17-18 Britton Street,
Clerkenwell, London
EC1M 5NQ

Tel: 0845 363 1130
Email: info@xchangetraining.co.uk

* For courses held outside of London for less than 3 trainees, there is an additional charge of £75, plus a standard return train fare and/or taxi fare may be applicable.

Training Booking
To reserve a place on a training course, please click the link at right or contact us by telephone or email on the details above. You will then be contacted shortly to confirm the booking.

Enquire about or book
this course here
Spacer
Horizontal Red Line All prices offered for business users and exclude delivery and VAT. E&OE
©XChange Training 2007. All Rights Reserved. | Privacy Policy