Home Courses Enquiries Online Training Blogs Locations Prices Testimonials

Cost Calculator

Price Per Head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Leicestershire Police

"Really informative ! The trainer was patient and knowledgeable and was able to answer all the questions we had. Going over things we have covered again if required .I really enjoyed the session"

Supply Chain Academy

"I would like to say a big thank you for Simon for all of his help. His training has helped to bring back some of my lost knowledge and also have expanded my knowledge too! Will definitely be recommending to others. Thank you so much once again."

Doppelmayr Cable Car

"This course shows me how to use Excel in a very good and understandable presentation"

Ground Control Ltd

"Very clear and easy to follow, brought the training to life with specific examples and tried to tailor the training to our needs and our needs of the business."

Print & Desktop Publishing

Locations

Microsoft Excel 2013 Training Course Advanced

Microsoft Excel 2013 Overview

What are Macros? How do I edit the code? Why should I use them? If these are questions you've asked then this is the training course for you. Although this course focuses primarily on Macros there are other aspects to hone your Excel skills.

You will become familiar with some of the more advanced features in Excel.

Other Microsoft Excel Training Courses

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 1 Day

Course Prerequisites:

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.

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

Classroom based Advanced Excel Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

If you are interested in this course fill out the following form for further details:

Have a look at our range of Excel Training Courses

Testimonials

Microsoft Excel 2013 Training Course Advanced

Microsoft Excel 2013 Overview

Course Prerequisites:

Course Outline

Using and Editing Macros in Excel 2013

Conditional Formatting changing cells based on a value

Working with Others

Data Validation including drop down lists

Auditing Worksheets

Integrating External Data

Classroom based Advanced Excel Prices from:

Other services

Training Locations

Contact

Q & A

Microsoft Excel 2013 Training Course Advanced