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

Viridor Waste Ltd

"It was very good, I felt relaxed and was able to proceed at my own pace."

Verifone UK Ltd

" Course was very well presented and the trainer was very knowledgeable"

Uniserve Holdings Limited

"Brilliant, learnt a lot and also got some great shortcuts. Clarifications on some current live issues also, massive return on investment, very happy."

Travis Perkis

"Brilliant"

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