Training
Let me guess?
You and your team are working with data and numbers but it’s hard, time consuming and frustrating.
Does any of this resonate?
- You’re using spreadsheets but you’re muddling through.
- You’d all love to feel more in control.
- You know people who think that spreadsheets are the bees knees but you just don’t understand why.
- You’re sure there’s something you must be missing but what?
And where on earth do you start?
Whether it’s one-to-one or small groups, I focus on the most useful areas of Excel or Google Sheets so you can quickly get to grips with what you need, without confusing you with stuff you don’t.
I can start from the very beginning, so no-one needs to have any experience of using spreadsheets. I also use simple business-related examples so you can see how what you learn relates to real-life scenarios.
See below ⬇️ for details on in-person training and check out my Online Training page for any sessions I’ve got planned.
Not sure what you or your team need? No problem, let’s have a chat and I can guide you.
Excel Fundamentals Course
My Microsoft Excel Fundamentals course is a perfect place to start if you (or your team) want a gentle introduction to what a spreadsheet is for and how it can help you in your business.
I’ve run this course for many local businesses and business owners.
I work with a maximum of 6 people for each session, to make sure everyone gets a chance to ask questions and to learn.
Absolutely no prior experience is necessary.
PRICE: £400*
TIME TAKEN: Approximately 2.5 hours
IDEAL FOR: anyone who works with data and numbers and wants to learn some techniques that will help make it easier.
LEARNING OBJECTIVES: Feel more confident using Excel • Learn how to find what you need in your data • Gain some techniques to help you do get stuff done faster • Learn a couple of simple formulas
TYPICALLY I RUN THIS TRAINING FOR: groups of small business owners and businesses wanting to develop their employees.
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
After attending two of Alison’s Excel workshops, I have to say she certainly has the gift of teaching. Her passion shines very clearly and she explains things in an easy to understand format. If you are looking to improve your skills and do something valuable for your business, I would highly recommend getting in touch with Alison. Five stars all the way. ⭐⭐⭐⭐⭐
Outstanding tutor, very clear and informative and extremely helpful afterwards too
- We’ll start off with a short tour of Excel (to get you familiar, even if you’ve never used a spreadsheet before)
- You’ll learn some simple ways to get more sense out of your data, just using options on the toolbar
- We’ll cover some keyboard shortcuts that will save you time
- I’ll show you some formulas that turn your data into information
An excellent hands-on introduction to Excel. Some really useful information which will definitely change the way I use spreadsheets and access data.
I came into the course clueless – learnt loads and loads. Thank you, it was worth the 5 hour drive.
- I’ll explain how dates work in Excel – so many business processes involve understanding data across time and being able to work confidently with dates makes this so much easier
- We’ll look at some formulas that help to turn lots of data into easy-to-understand summary information
- I’ll show you one of Excel’s secret weapons, the Table, which will make working with data so much easier that you ever thought possible!
Alison was really friendly and made the information easy to follow and understand, using visual aids and demonstrating.
A great course to get more out of Excel and save time
Excel Next Steps Course
My Excel Next Steps course is designed to lead neatly on from the Excel Fundamentals course or as a standalone for more confident Excel users.
I have a maximum limit of six people in each session, to make sure everyone has plenty of support and can ask questions.
This course is ideal for people who use Excel on a regular basis and feel comfortable with it but who would like to understand how to use formulas to reduce manual work.
PRICE: £450*
TIME TAKEN: Approximately 3 hours
IDEAL FOR: anyone who is working with data, to analyse and understand what it’s telling them, but knows there must be a less manual and easier way.
LEARNING OBJECTIVES: Understand how dates work in Excel • Learn some formulas to work with dates and to help create a summary of your data • Understand Excel Tables and how they can help you.
TYPICALLY I RUN THIS TRAINING FOR: groups of small business owners and businesses wanting to develop their employees.
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
This is the second course I’ve attended with Alison. Each step of the Excel process is always clearly explained so that I feel confident at the next stage
Excel Pivot Tables Course
Pivot Tables are one of the fastest ways to summarise your numbers and see what they are telling you, without needing formulas. But they can seem like a dark art when you first see them.
It doesn’t have to be like that. The secret of effective Pivot Tables is good data and in this course I’ll cover both how to create pivot tables and what your data should (and shouldn’t) look like.
I work with a maximum of 6 people for each session, to make sure everyone gets a chance to ask questions and to learn.
PRICE: £450*
TIME TAKEN: Approximately 4 hours
IDEAL FOR: anyone who needs to summarise data quickly and anyone who collects data manually and then finds analysing it tricky.
LEARNING OBJECTIVES: Understand what a Pivot Tables are • Learn how to create Pivot Tables to summarise data • Know how to structure data the RIGHT way, so Pivot Tables are easy.
TYPICALLY I RUN THIS TRAINING FOR: groups of small business owners and businesses wanting to develop their employees.
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
- I’ll show you what a Pivot Table looks like.
- We’ll build a variety of Pivot Tables together.
- I’ll show you how building Pivot Tables with data in the WRONG format is hard and what the RIGHT data format looks like, so next time you collect you’re own data it’s built to make formulas and Pivot Tables easy
- We’ll look at some of the common mistakes people make when structuring they capture their own data.
- I’ll show you the correct way to set up your data
- We’ll look at why it matters and how it can save you time and effort in the long run
It's All About The Data
*** A new course for 2026 ***
If you are creating your own spreadsheets and manually inputting the data the way you structure this can make your life easy or can make everything you do with the data frustratingly hard, with complex formulas and manual updates every time you change things.
Let me show you what Excel actually needs to make your formulas and pivot tables work, reducing manual effort and errors. You’ll feel like you have a new superpower!
** This course is ideal as a pre-cursor to my Power Query course **
PRICE: £450*
TIME TAKEN: Approximately 3 hours
IDEAL FOR: Anyone manually recording data (which is most of us, at some point).
LEARNING OBJECTIVES: What well structured data looks like • Why well structured data underpins everything else you need to do in Excel.
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
Modern Excel
*** A new course for 2026 ***
Although Excel may not look very different when you open it, in 2019 Microsoft realeased one of the biggest innovations for Excel in years – Dynamic Array formulas.
Traditional formulas work on the principle that a formula could only show an answer in one cell, which means copying and pasting where the same calculation was needed in multiple places.
Dynamic arrays change that completely. Now a formula can “spill” across as many rows and columns as it needs, to show the answer.
Filtering, sorting and shaping data happens right before your eyes.
You can’t forget to copy and paste your updated formula, so you’ll save time, reduce errors and significantly upgrade your Excel skills.
PRICE: £500*
TIME TAKEN: Approximately 4 hours
IDEAL FOR: Anyone using Microsoft 365, Excel 2021 or later and who wants to see the how Excel has transformed how we can build (not suitable for Excel 2019 or earlier).
- I’ll introduce you to Excel’s Dynamic Array formulas
- We’ll learn how to use them and combine them, with practical business examples
- I’ll show you how using Dynamic Array formulas in your spreadsheets will reduce errors
LEARNING OBJECTIVES: Learn what Dynamic Arrays are in Excel • Practise new approaches to working with data in Excel, using Dynamic Array formulas.
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
- I’ll show you how we can build a series of steps in Power Query to clean data that’s not in the format we need.
- We’ll see how we can re-use what we have built Power Query so that we save time every time we receive a new file.
- We’ll look at how we can tweak the M Code that Power Query writes for us.
LEARNING OBJECTIVES: Learn what Power Query in Excel is for • Practise transforming data in Power Query
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
Power Query in Excel
*** A new course for 2026 ***
Excel works best when the data you are using is free from errors and well structured. But we don’t always get data that’s free from errors and well structured to work with, so we have to clean it.
If you find yourself doing the same repetitive steps on a regular basis you’re going to wish you’d heard of Power Query sooner. It’s the tool that shapes data so that Excel Pivot Tables and formulas work as they should.
Build your steps once and re-use whenever you need to, whether you’re cleaning one file or a whole folder full of files.
Power Query is part of Excel, no additional licence is required.
PRICE: £850*
TIME TAKEN: 1 Day
IDEAL FOR: Confident Excel users who regularly carry out the same repetitive actions to clean data. This could mean actions such as
- hiding or removing columns
- filtering rows
- adding new columns with calculations
- correcting errors in the downloaded data
- combining with data from other places
121 Training
Alison has helped me develop a spreadsheet for my business accounting and analysis, which has saved me masses of time and given me a huge variety of data for my business. She is so enthusiastic and knowledgeable about a subject that many people find daunting at best. Even though I thought I was pretty good with spreadsheets having been using them for literally decades, she has given me a vast wealth of knowledge I would never have been able to figure out on my own. Whether you’re scared to death of touching Excel or think you know all about it, I can pretty much guarantee Alison will be able to teach you something useful. She’s also really approachable and fun to work with. Definitely recommend.
Alison is super knowledgeable, willing, proactive, helpful, supportive… you name it – in short she is fab and I would recommend her to anybody who struggles with Excel. She even converted me into an Excel fan which is quite a thing for someone with no mathematical brain and reluctance toward anything related to numbers and formulas!
If you need something specific or would rather work 121 then I’d love to chat to find out more about what you need.
I’ve helped business owners with a specific spreadsheet they wanted to change so that they could work more efficiently.
I’ve worked with people needing to get to grips with Excel so that they can complete professional exams.
If you need some help, or you’re just not sure and want to have a chat, book a free consultation call using the button below.
PRICE: From £300*
TIME TAKEN: Whatever you need!
IDEAL FOR: someone who wants to build a spreadsheets, where the process is as important as the end result. This is the perfect approach if you know what you want but need help getting there. You’ll learn skills that will help you for the next spreadsheet you need!
LEARNING OBJECTIVES: Whatever you want them to be! But I can help you work out what that means.
TYPICALLY I RUN THIS TRAINING FOR: Business owners who want to get to grips with Excel and have a specific project in mind.
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
Bespoke Training
I often get asked “Alison, do you have an intermediate or advanced Excel course?”
I don’t.
Why is that?
- Excel is a hugely versatile tool which is used by many people in very many different ways.
- Your business has its own specific needs
- Your people won’t all have the same knowledge or comfort level with technology and spreadsheets.
Once we’ve got beyond the building blocks creating a training solution that gives your employees the best overall experience is not a “one size fits all” situation!
What I can do is work with businesses to understand the specific problem(s) they need to solve and design a training solution that will do just that, taking into account the people who the training will be for.
Think about it this way, do you want your team to…
…spend a few hours away from their desks, in a training course, that they leave thinking “well, I have no idea how that will help me in my day-to-day job”
OR
…spend a few hours in a training course learning how to improve a spreadsheet or process they use regularly, so that they leave with a more efficient tool, skills they WILL use (and therefore remember) and an understanding of how all that relates to they job they do.
PRICE: From £600 but will depend on what you need*
TIME TAKEN: this really depends on what you need.
IDEAL FOR: Business who are looking for training beyond the basics for their team. Businesses who have a specific business problem to solve. Business who know that there must be a way to increase efficiency when working with data or numbers and want advice.
LEARNING OBJECTIVES: Whatever you want them to be!
TYPICALLY I RUN THIS TRAINING FOR: individuals or teams within a business where there are specific goals, such as creating a spreadsheet or learning how to analyse and understand the data being used within the business.
*for in-person training, depending on distance I need to travel, I reserve the right to charge for travel time and expenses.
Want something specific? I can create bespoke training that gives you exactly what you need to move your business forward.
