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

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

Industrial Inkjet LTD

"Very good Excel for beginners training learnt a lot thankyou. very friendly and easy to understand tutor. would definitely recommend and do another course"

Microsoft Excel 2010 Training Course Intermediate Cambridge

Cambridge Intermediate Microsoft Excel 2010 Course Overview

Microsoft Excel 2010 Training Course Intermediate Kings College chapel Cambridge

The science park to St. John's Innovation centre. The university city of Cambridge is a regular training venue. We've trained various companies in and around Cambridge as far out as Cambourne, Newmarket, Huntingdon and St. Ives. A Intermediate Microsoft Excel 2010 Training Course at the offices we use at the Regus in Cambourne is easy to set up and conduct even at short notice. Or maybe you just want us to come to you bringing a projector, laptops with Excel preloaded along with fully comprehensive course notes.

Cambridge is renowned for its prestigious university and stunning architecture.

Cambridge was actually the first area we started training. From Cambridge Consultants on the science park to ARU, CRC (Cambridge Regional College) and many more have taken advantage of the computer training courses conducted by us.


Course Duration: 1 Day

Complete Course Outline

Use Microsoft Excel 2010 to Calculate Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data with Excel 2010

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data

Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Analysing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyse Data Using PivotCharts

Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Customising and Enhancing the Excel Environment

  • Customise the Excel Environment
  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates