Home Courses Enquiries Online Training Blogs Locations Prices Testimonials

Cost Calculator

Price Per Head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Leicestershire Police

"Really informative ! The trainer was patient and knowledgeable and was able to answer all the questions we had. Going over things we have covered again if required .I really enjoyed the session"

Supply Chain Academy

"I would like to say a big thank you for Simon for all of his help. His training has helped to bring back some of my lost knowledge and also have expanded my knowledge too! Will definitely be recommending to others. Thank you so much once again."

Doppelmayr Cable Car

"This course shows me how to use Excel in a very good and understandable presentation"

Ground Control Ltd

"Very clear and easy to follow, brought the training to life with specific examples and tried to tailor the training to our needs and our needs of the business."

Print & Desktop Publishing

Locations

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.

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Scheduled Live Online Microsoft Excel Classes

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

Classroom based Intermediate Excel Prices from:

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

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

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.

Testimonials

Microsoft Excel 2013 Training Course Intermediate

Microsoft Excel 2013 Overview

Course Outline

Using Microsoft Excel Formulas

Conditional Formatting

Tables a new feature improved

Using Charts

Pivot Tables

Incorporating Graphics

Templates what are they and how to use them?

Classroom based Intermediate Excel Prices from:

Skills learned: Pivot Tables

Other services

Training Locations

Contact

Q & A

Microsoft Excel 2013 Training Course Intermediate