Go to XChangeTraining Home Page
Main XChange Training Logo White

0845 363 1130 • info@xchangetraining.co.uk

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 pointView all Microsoft Excel training 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 6 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, 6 months telephone and/or e-mail support service after the course, all refreshments and lunch if held at the training centre.

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

Training centre pricing
Pricing for training at the Clerkenwell facility:
1 person £449 for a 1 day course
2 people £549 for a 1 day course
3 people £599 for a 1 day course
4 people £649 for a 1 day course
5 people £699 for a 1 day course
6 people £749 for a 1 day course
7 people £799 for a 1 day course
8 people £849 for a 1 day course
All prices subject to VAT

 

Training Centre address
5 St John's Lane
Clerkenwell, London
EC1M 4BH

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

Arrow style bullet pointCourse Location Map Link

For courses held outside of London for less than 3 trainees, an additional charge may be applicable depending upon the location - please ask for details.

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 2010. All Rights Reserved. | Privacy Policy