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"

Locations outside Guildford

Microsoft Excel 2013 Training Course Advanced Guildford

Guildford Advanced Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Advanced training course Guildford Surrey

Located in Surrey, Guildford is known for its cobbled high street and stunning countryside.

The town of Guildford in Surrey is known for a fantastic shopping experience. Of course with the Guildford business park and easy access to two popular airports in Heathrow and Gatwick. Your Advanced Microsoft Excel 2013 Training Course training course in Guildford Surrey can be conducted at your premises, where we can bring laptops with the Microsoft Excel 2013 Training Course already loaded. We can even bring a projector along with power extension leads, leaving you to concentrate on learning.

Conducting Microsoft Excel 2013 Training Course training courses in Surrey is a relatively new venture for us so please try us out and remember to tell us and others what you think.


Course Duration: 1 Day

Course Prerequisites for your training in Guildford

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

Have a look at our range of Excel Training Courses

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 - Intermediate

Microsoft Excel 2013 Training Course - Beginners

Microsoft Excel 2010 VBA Training Course - Beginners

Microsoft Excel 2010 Training Course - Advanced

Microsoft Excel VBA 2007 Training Course - Intermediate