Close
Browse courses

Book your training course

  • Online

    Spaces left
    • 30th Mar 2021
    • 9:30am - 4:00pm
    • £249.00 (+ VAT)
    Book

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.
  • £1195 (+VAT & travel)
Enquire

Can't make it? Get notified of next course

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.

 

Who will train me?

Ready to book onto your course?

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

Choose booking

Associate Trainer

Sarah Aspinall

What is my experience?

I have been involved in IT Training and Development for over 18 years.  I have experience of training staff in both the Private and Public sector.  I train Microsoft and Google Products, carrying out software specific training needs analysis and advising organisations on their future training plans.

 

What is my area of expertise?

My training expertise focuses on all Microsoft Products, including Project, Excel, Teams, Word, Outlook, PowerPoint, Visio, Publisher.  With technology being so versatile and open to all, matter what the location, I can conduct all of my training either face to face or virtually.  As well as working with the more well established software products, I also work with companies that seek to develop and train on their own in-house systems.

 

Why I love inspiring others?

I love my work and get great satisfaction from unlocking knowledge and helping delegates develop a deeper understanding of what each product can help them with.  It is great to see all course participants gain new skills that will help them in all aspects of their daily life, whether that be time saving, being more productive, developing confidence or making communication much easier.