Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

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. "

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."

Locations outside Peterborough

Microsoft Excel 2013 Training Course Intermediate Peterborough

Peterborough Intermediate Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Intermediate training Peterborough - Cathedral Square

Stuart House - East Wing
St John's Street
Peterborough PE1 5DD
United Kingdom

This business centre is a strategically located headquarters office building in central Peterborough, in the heart of the business district. It is within walking distance of the bus and railway stations and close to all shopping facilities, including Marks & Spencer and the Queensgate Shopping Centre where tenants include John Lewis, Waitrose and Boots. It is within a quarter mile of junction 5 of the Peterborough Ring Road. Convenient for your Intermediate Microsoft Excel 2013 Training Course.

Alternatively if you live in and around Peterborough and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up.

Looking for another training courses? Have a look at the other training courses in Peterborough.

Peterborough features a stunning cathedral and a mix of urban and rural landscapes.

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.