Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

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

Microsoft Excel 2013 Training Course Intermediate Ipswich

Ipswich Intermediate Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Intermediate training course Ipswich Willis building

With its historic docks, Ipswich combines a rich maritime heritage with modern attractions.

Belstead Road
Ipswich
Suffolk
IP2 9HB

The Belstead Brook Hotel sits in nine acres of tranquil gardens, alongside a willow-lined stream. The original 16th Century hunting lodge is still very much at the heart of the hotel, housing a restaurant, bar and private dining rooms. An ideal place for training the Microsoft Excel 2013 Training Course Intermediate.

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

Apart from Microsoft Excel 2013 Training Course training we conduct many other training courses in Ipswich.


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.

You may also be interested in:

Microsoft Excel 2016 Training Course Beginners

Microsoft Excel 2016 Training Course Intermediate

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel Pivot Tables Training Course Beginners

Microsoft Excel PowerPivot Training Course Intermediate

Microsoft Excel 2013 Training Course - Beginners

Microsoft Excel 2013 Training Course - Advanced

Microsoft Excel 2010 Training Course - Beginners