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

HOPPE UK

"Fantastic really informative and interesting" "Excellent very enjoyable really good presenter"

St Johns Packaging (UK) LTD

"The training was highly beneficial and significantly enhanced my Excel skills. Simon was an engaging and approachable instructor, it was an absolute pleasure to learn from him."

Hahnemuehle

"Really good and really informative. Would recommend to a company needing excel training."

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

Microsoft Excel 2013 Training Course Intermediate Chiswick

Chiswick Intermediate Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Intermediate training course - Chiswick Courses

Chiswick, a leafy suburb of London, is celebrated for its historic pubs and riverside walks.

London (Chiswick)
Building 3,
Chiswick Park,
566 Chiswick High Road,
Chiswick,
London, W4 5YA

The London Chiswick Park business centre is in a beautiful four-storey glass building in an award-winning business park is ideal for your Microsoft Excel 2013 Training Course Intermediate training course. Designed by architect Sir Richard Rogers, the building is one of 12, which form a 'necklace' around an inner landscaped area with a lake, waterfall, trees, gardens and walkways. With on-site parking, the centre is also close to the Gunnersbury London Underground Station.

Is this course right for you? We have many other computer training courses in Chiswick. Why not see what else we can help you with.


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