Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

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

Locations outside Reading

Microsoft Excel 2013 Training Course Advanced Reading

Reading Advanced Microsoft Excel 2013 Course Overview

Advanced Advanced training course Reading - Town Hall

A relatively new training location for us however we are eager to get to know and help local businesses in the area.

Reading is a bustling town with a strong literary heritage and vibrant arts scene.

Equipped with laptops with the software loaded on. Also a projector along with a mouse for each laptop as we know how difficult it is to use that little touch pad thingy.

However should you want to get out of your office for your Advanced Microsoft Excel 2013 Training Course training course then why not come to a local one that we use.

200 Brook Drive
Green Park
Reading
RG2 6UB

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

The Microsoft Excel 2013 Training Course Advanced in the The Green Park business centre Reading is a stunning building with a full-height atrium and large open-plan reception area. It is one of a group of individually designed landmark buildings attractively positioned around Longwater Lake just outside Reading. With handy access to the M4 this is the ideal location for those coming from the south west or if they simply want to get out of London for the day.

Apart from Microsoft Excel 2013 Training Coursetraining, we also conduct many other computer training courses in Reading. Have a look and see if we can accomodate.

Course Duration: 1 Day

Course Prerequisites for your training in Reading

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