Close
Browse courses

Book your training course

Feefo logo

In-house training

  • This training course can be tailor-made and delivered in-house for up to 8 people. Held online via our virtual classroom or where safe to do so, at your premises or a nearby venue.
  • £1245 (+VAT & Travel)
Enquire

Scheduled course

  • Sorry, there’re no scheduled courses at the moment. Get notified via email when a course at a one of our venues takes place.
Get notified

Why book this course?

Even the most experienced users of Microsoft Excel are often surprised at the things they don’t know, and the capabilities of the software. These seemingly simple spreadsheets can be extremely powerful tools if you know what you’re doing, and utilised for everything from automating tasks to forecasting and problem solving.

This course builds on our Microsoft Excel Intermediate course, showing further data analysis techniques and looking at the world of what-if analysis for forecasting and problem solving.  You will also learn how to automate repetitive tasks with the use of simple macros.

Who is the course for?

Our Microsoft Excel - Advanced course is aimed at anyone who has used Excel for a substantial period of time, and is competent in the skills covered by our Microsoft Excel Beginner and Intermediate courses. 

Attendees should have concrete skills in and knowledge of Excel, and be keen to develop these skills further. You will learn advanced techniques including scenario management, tools for auditing, macros and pivot tables.

What content will the course cover?

Advanced Formula 

  • Vlookup and HLookup

  • If, AND, OR

  • Text Functions

  • Date Functions

Protection

  • Sheet Protection

  • Unlocking a range of cells

  • Hiding Formula in cells

  • Workbook Protection

  • Saving a file with a Password

What If Analysis

  • Scenario Manager

  • Adding a Scenario

  • Displaying Scenarios

  • Merging Scenarios

  • Creating a Scenario Report

  • Goal Seek

Worksheet Auditing

  • Tracing Precedents & Dependents

  • Navigating and Removing Tracer Arrows

  • Tracing Errors

  • Adding/Deleting/Printing Comments

Macros

  • Recording a Macro

  • Running a Macro

  • Assigning a Macro to a button

  • Assigning a Macro to a Keystroke

Outlining

  • Creating an Outline

  • Working in Outline

  • Removing an Outline

Pivottables

  • Understanding Pivot Tables

  • Creating a Pivot Table

  • Editing, Moving and Deleting Fields

  • Filtering Data

  • Subtotals in Pivot tables

  • Creating Groups

  • Creating Calculated Fields

  • Inserting Report Filters

  • Updating Pivot Tables

  • Use Slicers to Filter a Pivot Table

What will I get out of the training?

Our Microsoft Excel - Advanced course is designed for learners who are already confident with Excel, and wish to approach mastery of the software and their roles. You will learn to use further data analysis tools to complete a what-if analysis, to customise the environment to your liking, and to record and playback simple macros for the automation of repetitive tasks.

At Kent Trainers, we’re proud to take a hands-on approach that fulfils the needs of businesses across the region. As well as including plenty of practical training, our Excel courses allow learners to ask questions and share feedback with our trainers and their peers - giving you a training experience that’s tailored to your business and role.

What is the duration of this course?

This is a 1 day course.

The timings and format for our courses are as follows:

  • Scheduled training courses held virtually

Unless specified, courses commence at 9:30am and finish at approximately 4:00pm.  The day is broken up into modules, both online and offline to ensure engagement and interaction.  We also ensure that there are plenty of comfort breaks throughout the day.

  • Scheduled training courses held at one of our venues

Courses commences at 9:30am and finish at approximately 4:30pm. On all our scheduled courses, a hot lunch is included, and refreshments are provided throughout the day.

  • In-house & bespoke courses, held virtually or at a venue of your choice

For all in-house training courses, we will adapt the timings and format for the day around the needs of your team and business. Please contact us to discuss your requirements.

 

Ready to book onto your course?

Let get you started by choosing what booking option is the best option for you.

Choose booking

Want 10% off your first scheduled course?

Sign up to our newsletter and receive 10% off any of our scheduled courses as a thank you! Our monthly newsletters are filled with features, advice and information about our forthcoming courses.