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

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

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

Microsoft Excel 2013 Training Course Advanced Heathrow

Heathrow Advanced Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Advanced training Heathrow

Situated near one of the world’s busiest airports, Heathrow connects travelers to a global network of destinations.

London - (Heathrow)
450 Bath Road
Longford
Heathrow
London, UB7 0EB

In your busy life the convenience of a Microsoft Excel 2013 Training Course Advanced training course near Heathrow airport could be the ideal solution.

The Microsoft Excel 2013 Training Course Advanced course in the 3 storey Heathrow Airport training centre is five minutes from Heathrow's Terminal 5. Set in secluded grounds, the building has an impressive high-ceilinged reception and there are views of the planes taking off and landing from some offices. Close by car from Terminal 5, there is also easy access to the London Underground, Heathrow Express and the M25 and M4 motorways. It is a short drive to cafes, restaurants, bars and shopping in West Drayton.

If a Advanced Excel training course isn't what you need. Then please take the time to look at other computer training courses in Heathrow.


Course Duration: 1 Day

Course Prerequisites for your training in Heathrow

The delegate would preferably have had previously experience using Excel formulas and functions. Either by having been on a Beginners and Intermediate training course or by having used Excel regularly.

Complete Course Outline

Using and Editing Macros in Excel 2013

  • Recording a Macro
  • Editing the Macro Code
  • Attaching a Macro to a Button on the Ribbon

Conditional Formatting changing cells based on a value

  • Using Formulas with Conditional Formatting
  • Customising the Icon Sets

Working with Others

  • Password Protecting Files
  • Sharing Workbooks
  • Tracking Changes
  • Merging Workbooks
  • Digital Signatures

Data Validation including drop down lists

  • Ensuring Users Enter the correct Text
  • Using Drop Down Lists
  • Giving guidance to users by displaying an Input Message
  • Giving custom error messages

Auditing Worksheets

  • Trace Formulas in Excel
  • Finding Errors in your Formulas
  • Evaluate your Formulas
  • Scenarios
  • Using the Analysis Toolpak Add on
  • Sparklines - Mini charts in your Cells

Integrating External Data

  • Importing data
  • Getting live Data from the Web
  • Getting Data from Access
  • Using XML what is it and how can it benefit me