Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Balfour Beatty

"Great course, trainer was very interactive and enthusiastic."

GKN Aerospace

"Very informative and fun energy. I really enjoyed it and will be able to use what I leaned."

Prominate

"Excellent, informative, fun and engaging. Learnt a lot!"

"It was excellent. Easy to follow, engaging, structured and delivered with humour and patience."

Industrial Inkjet LTD

"Very good Excel for beginners training learnt a lot thankyou. very friendly and easy to understand tutor. would definitely recommend and do another course"

Locations outside Cambridge

Microsoft Excel 2013 Training Course Intermediate Cambridge

Cambridge Intermediate Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Intermediate Kings College chapel Cambridge

The science park to St. John's Innovation centre. The university city of Cambridge is a regular training venue. We've trained various companies in and around Cambridge as far out as Cambourne, Newmarket, Huntingdon and St. Ives. A Intermediate Microsoft Excel 2013 Training Course at the offices we use at the Regus in Cambourne is easy to set up and conduct even at short notice. Or maybe you just want us to come to you bringing a projector, laptops with Excel preloaded along with fully comprehensive course notes.

Cambridge is renowned for its prestigious university and stunning architecture.

Cambridge was actually the first area we started training. From Cambridge Consultants on the science park to ARU, CRC (Cambridge Regional College) and many more have taken advantage of the computer training courses conducted by us.

Course Duration: 1 Day

Complete Course Outline

Using Microsoft Excel Formulas

IF Function
Named Ranges
VLookup Function

Conditional Formatting

Creating the condition
Data Bars
Using Icons

Tables a new feature improved

Creating a Table
Formatting a Table
Sorting & Filtering
Using Table Functions in Excel 2013

Using Charts

Creating a Chart
Modifying Charts
Formatting Charts
Customising charts

Pivot Tables

Creating Pivot Tables
Re-Organising your Pivot Table
Filtering Pivot Tables
Using Slicers with Pivot Tables
Pivot Charts

Incorporating Graphics

Inserting Images from the Web
Creating a Flowchart
Using Smart Art graphics
Grouping and Layering Graphics Objects

Templates what are they and how to use them?

Using a Template
Creating a Template
Editing a Template

Have a look at our range of Excel Training Courses

Skills learned: Pivot Tables

If you have a mountain of data to deal with. So long as it's it the correct format you can very quickly summarise and re-structure the data into appetising bite size chunks. Too many times do people spend many hours re-formatting their information so that it looks pretty when Pivot Tables are the solution.