Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

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 Chiswick

Microsoft Excel 2013 Training Course Advanced Chiswick

Chiswick Advanced Microsoft Excel 2013 Course Overview

Microsoft Excel 2013 Training Course Advanced 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 Advanced 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

Course Prerequisites for your training in Chiswick

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