Cost Calculator

Price per head:

£ .

Duration:

1 Days

* Price is exclusive of VAT.

Tell Me More

Testimonials

HOPPE UK

"Fantastic really informative and interesting" "Excellent very enjoyable really good presenter"

St Johns Packaging (UK) LTD

"The training was highly beneficial and significantly enhanced my Excel skills. Simon was an engaging and approachable instructor, it was an absolute pleasure to learn from him."

Hahnemuehle

"Really good and really informative. Would recommend to a company needing excel training."

Ottolenghi Ltd

"I found the basic excel training useful and excel cheatsheet is very handy. I learnt some new things from the exercise and looking forward to the next session. "

This course in other locations

Microsoft Excel 2013 Training Course Intermediate Training in Hammersmith

Hammersmith Intermediate Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Intermediate training in Hammersmith

Hammersmith is a convenient West London location for businesses looking for practical, instructor-led Microsoft Excel 2013 Training Course training. It suits teams who want a professional venue as well as organisations that prefer on-site delivery.

The venue works particularly well for spreadsheet-based training where delegates need time to practise formulas, reporting and data analysis without day-to-day interruptions.

Crown House
72 Hammersmith Road
Hammersmith
London W14 8TH

The venue is well placed for public transport and gives delegates a comfortable, focused setting for learning. This is especially useful for teams who want practical, hands-on training that improves confidence with everyday spreadsheet tasks.

If you are considering other options too, take a look at our computer training courses in Hammersmith & Fulham.

Pivot Tables and more is only the beginning to this Excel intermediate training course. You will use Excel as a database being able to sort filter add generally work miracles with Data.

The large part of this intermediate training is dealing with Excel database functionality. The functions you will learn will be related to this allowing you to cross reference data and re-organise your data.

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Scheduled Live Online Microsoft Excel Classes

Course Duration: 1 Days

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.

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.

Birmingham Brentwood Cambridge Coventry Guildford Ipswich Leicester Luton Milton Keynes Northampton Norwich Oxford Peterborough London (Chiswick) London (Hammersmith) London (Heathrow) London (Kensington) Reading