Microsoft EXCEL

Advanced Course

Become the best of the best in Microsoft Excel with our advanced level course.

Course Description

Microsoft Excel is the preferred application for professionals across many different industries. Known for it’s calculation ability, not only does Excel perform perfectly for simple formulas and mathematical sums, it also provides the perfect partner for more detailed uses such as pivot tables, macro programming and graphing tools.

The MS Excel Advanced Course is the longest and the most intense of the three Excel courses presented here. However, if you have successfully passed the beginner and the intermediate courses, you should consider yourself fully prepared to begin the advanced
course.

Price

£350 per person (excludes VAT)

DURATION

1 day course

We provide a one-day intensive, supported learning programme. The course is broken down by our expert tutor and will provide you with a highly interactive learning experience in our Horsham Training Centre, supported with eBooks (bring a memory stick!). Our range of Microsoft Office courses are available for Beginner, Intermediate and Advanced levels ensuring that the learning you take away is in keeping with your day-to-day requirements. For larger groups, WDR can arrange training at your premises, or another local venue. Please speak to our team for further booking details.

What you'll be doing on the course

VLOOKUP advanced formula options and manipulations.

Other advanced functions.

Functions including CEILING, CORREL, DATEIF etc.

Colouring a column and row with a formula.

Highlighting a cell with a formula.

Functions including DGET, DCOUNT, DSUM etc.

Calculating loan IPMT and EMI.

Functions including DATEDIF, DATEVALUE, MATCH etc.

Full explanation of the INDEX and MATCH functions.

Looking up data.

Selecting only cells containing comments.

Hiding formulas.

What you'll be doing on the course

VLOOKUP advanced formula options and manipulations.

Other advanced functions.

Functions including CEILING, CORREL, DATEIF etc.

Colouring a column and row with a formula.

Highlighting a cell with a formula.

Functions including DGET, DCOUNT, DSUM etc.

Calculating loan IPMT and EMI.

Functions including DATEDIF, DATEVALUE, MATCH etc.

Full explanation of the INDEX and MATCH functions.

Looking up data.

Selecting only cells containing comments.

Hiding formulas.

Who is this course for?

As you can see, the information you will get from the MS Excel Advanced Course will fully prepare you for virtually any career path, including those that require advanced skills with this software.

We recommend that learners take both our basic and intermediate level course before considering advanced if they are not already very proficient in Microsoft Excel.

Request a callback.

If you’re not sure if this course is for you, or would prefer to speak to somebody, leave your name and telephone number and one of our coaches will get back to you as soon as possible.

An Inclusive Learning Environment

We understand that not everyone learns in the same way, and that’s exactly why we offer complete support to each and every one of our learners and coaches. We’re an inclusive company and the support options we offer aim to fulfill the potential of any individual, regardless of their background.