Close
Browse courses

Book your training course

  • Online

    Spaces left
    • 24th Feb 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?

Many of us are familiar with the basic functions of Microsoft Excel, but few realise how flexible the software is, and the range of situations it can be used for. Even if you have a solid grasp on how to use Excel, it’s likely that you’re missing out on tricks and tips that could elevate your productivity.

Our action-packed Intermediate Training course builds on our Microsoft Excel Beginners course, extending your skills and further improving your confidence with the software. Learners will delve into the facilities of data tables and databases, learn even more powerful formulae, and manage and finish their spreadsheets in a way that stands out from the crowd.

Who is the course for?

Our Microsoft Excel - Intermediate Training course assumes a good level of prior knowledge of the basics of Excel, equivalent to our Microsoft Excel Beginners Introduction course.

This will include anyone who has taken that course with us, or who uses Excel on a day-to-day basis for basic calculations and organisation.

What content will the course cover?

Recap on some basic formulae 

  • Absolute and Relative Cell Referencing

  • Average/Max/ Min Functions 

  • Custom Lists and Creating Own

  • BODMAS – order of calculation

  • Shortcuts

  • Quick Fill

Working with Sheets and Workbooks

  • Worksheet administration

  • Work on multiple workbooks – 3d Formulae

  • Freeze panes/Split Screen

  • Use Styles, Creating and Merging 

  • Use borders and shading effectively

Conditional Formatting 

  • Icon Sets and Managing Rules

Data Lists

  • Creating data lists

  • Simple and custom sorts

  • Maintain lists with data forms

  • Use Subtotals

  • AutoFilter lists

  • Advanced Filtering

Range Names

  • Why you would use them?

  • Using Range Names in Formulae 

Charts

  • Creating and editing charts

  • Changing chart location and adding data

  • Change/customise the chart type

  • Auto format and customised auto Sparklines

Creating Hyperlinks

What will I get out of the training?

Learners on our Microsoft Excel - Intermediate Training course will gain an understanding of how to use Microsoft Excel for database purposes, including how to store and analyse data within spreadsheets. You’ll also learn to use and understand a greater variety of formulas and functions, and how to manage and finish your spreadsheets quickly, easily and professionally.

At Kent Trainers, we’re proud to offer courses that take the needs of businesses into account. All of the learners on our Microsoft Excel courses will benefit from in-depth practical exercises, as well as being able to ask questions and gain feedback from our trainers - tailoring your learning experience to the skills you need.

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.