Home Courses Enquiries Online Training Blogs Locations Prices

Cost Calculator

Price Per Head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Private

"Very efficient Very clear and easy to understand Simon was very accommodating in showing us functions outside the day course Easy to follow instructions Lovely lunch and snacks. Simon and Cindy are really pleasant and lovely people, I left with the feeling that I had learnt a lot Mission accomplished!"

Blaby District Council

"The trainer.. had the ability to explain in a clear and concise manner and had a deep knowledge of excel but kept his training very relevant to the group. The course did not feel rushed or pressured and there was no feeling of embarrassment if more help or explanation was needed. The trainer offered assistance at every stage and was able to explain in a way that was relevant. His diction and pace were perfect."

Smurfit Kappa

Very informative and easy to understand, and Denise was relaxed, friendly and so helpful. After the course, I had a more clearer understanding and picked up tips and techniques I never knew.

Network Rail

"Very good, pitched at the right level. Simon was very engaged, enthusiastic and knowledgeable and was left plenty of time at the end for specific queries.

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 Excel Training Courses

Scheduled Live Online Microsoft Excel Classes

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