Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Testimonials

Blaby District Council

"The trainer.. had the ability to explain in a clear and concise manner and had a deep knowledge of excel but kept his training very relevant to the group. The course did not feel rushed or pressured and there was no feeling of embarrassment if more help or explanation was needed. The trainer offered assistance at every stage and was able to explain in a way that was relevant. His diction and pace were perfect."

Smurfit Kappa

Very informative and easy to understand, and Denise was relaxed, friendly and so helpful. After the course, I had a more clearer understanding and picked up tips and techniques I never knew.

Network Rail

"Very good, pitched at the right level. Simon was very engaged, enthusiastic and knowledgeable and was left plenty of time at the end for specific queries.

Master Chemical Europe Ltd

"Extremely informative especially on Pivot tbls & VLookup I have come away with an expanded knowledge of Excel, which in turn brings a huge degree of confidence back into my reporting"

Microsoft Excel 2013 Training Course Intermediate

Microsoft Excel 2013 Overview

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.

Other Excel Training Courses

Course Duration: 1 Day

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

Intermediate Excel Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

I would like to receive training special offer emails
I would like to be notified about free software hints and tips



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



Microsoft Excel 2013 Training Course Intermediate