Excel Courses

Learn Microsoft Excel from scratch on this practical one-day introduction course for complete beginners.

Covering the interface, spreadsheet creation, data entry and formatting, formulas and functions, sorting and filtering, conditional formatting, creating and formatting charts and setting up and printing worksheets.

•  Navigate the Excel interface and workbooks
•  Enter, format and organise data effectively
•  Write and edit formulas and functions
•  Sort, filter and apply conditional formatting
•  Create charts and print worksheets professionally

•  
  
  

  "I haven't done an online course like this before and I am surprised how it was to learn. I enjoye dit"

  26th Aug 26 - With Lisa

•  
  
  

  "Lisa was very personable and clearly has a lot of knowledge. I really appreciated the foresight into the intermediate courses and reference to clear progression."

  26th Aug 26 - With Lisa

•  
  
  

  "Lisa G is a great teacher, truly engaging and helpful. Thank you so much"

  Miller Homes - 26th Aug 26 - With Lisa

•  
  
  

  "Explaining each section and allowing us to take time and understand it all - Patience"

  26th Aug 26 - With Monica

•  
  
  

  "Explaining things in different ways so everyone can understand."

  Vinci - 26th Aug 26 - With Monica

• More Reviews

Build upon your basic Excel knowledge and master more advanced features and functions.

Learn new techniques to manipulate data, analyse information and automate tasks.

This intermediate level Excel course will also provide you with time-saving tips, tricks, and shortcuts that can streamline your workflow and increase productivity.

•  Write more advanced formulas with confidence
•  Apply conditional formatting to highlight data
•  Manage multiple worksheets efficiently
•  Use VLOOKUP, SUMIFS and IF to interrogate data
•  Organise large data sets without losing control

•  
  
  

  "Very clear instructions, a lot of excercises to practice the tasks, very detailed course"

  Liontrust - 30th Sep 26 - With Lisa

•  
  
  

  "Good explanation, relevance of subject to my job role, good to go over what we covered last time. Good location for the course."

  London Ambulance Service - 30th Sep 26 - With Lisa

•  
  
  

  "Clearly explaining and answering questions."

  Miller Homes - 9th Sep 26 - With Kevin

•  
  
  

  "Knowledge base. keeping at a good level for all students while making sure everyone was getting it."

  9th Sep 26 - With Kevin

•  
  
  

  "I felt like it was an informative session that felt like an Excel bootcamp. Kevin was very knowledgeable, and if we had any queries, he was very patient in answering them."

  9th Sep 26 - With Kevin

• More Reviews

Master Excel's advanced data analysis features on this expert-led one-day course for experienced users.

Covering nested formulas, VLOOKUP, INDEX and MATCH, data validation, formula auditing and evaluation tools, PivotTables and slicers, interactive charts linked to PivotTables, macros and Power Query.

•  Master VLOOKUP, INDEX, MATCH and nested formulas
•  Reduce audit risk with data validation techniques
•  Build and manage PivotTables with slicers
•  Create interactive charts linked to PivotTables
•  Automate tasks with macros and Power Query

•  
  
  

  "Kevin was incredibly knowledgeable, and able to answer all questions no matter how niche. Things which previously seemed impossible to comprehend now seem easy! The day was very well organised and facilities were great too."

  Hachette Partworks - 25th Sep 26 - With Kevin

•  
  
  

  "Explanation, knowledge and how to manage time."

  Lacoste - 28th Aug 26 - With Monica

•  
  
  

  "She was incrediblty insightful andf indepth - we went over lots of things and coverfed ground thats appropriate for our work. I found todays sensation great!"

  Lacoste - 15th Jul 26 - With Monica

•  
  
  

  "Very good at using examples and there was a great mixture between learning and practice which means I can effectively go back and use this within my workplace. Very engaging and also added in additional areas areas that we had asked questions about."

  Lacoste - 15th Jul 26 - With Monica

•  
  
  

  "Lots of relevant, efficiencies in building spreadsheets and analysis."

  Sheffield Children's Hospital - 9th Jul 26 - With Sue

• More Reviews

Learn to build interactive Excel dashboards on this expert-led one-day specialist course.

Covering Power Query, data preparation and cleaning, PivotTables, dynamic charts linked to PivotTables, slicers, dashboard layout and design, formulas, named ranges and conditional formatting — prior Excel experience required.

•  Import and prepare data dynamically using Power Query
•  Build PivotTables and create charts linked to them
•  Add slicers and filters for dashboard interactivity
•  Design clear, logical dashboard layouts
•  Use formulas and conditional formatting to tell a story

•  
  
  

  "Explaining the concepts so that it was easy to understand and providing the examples so that we had something to work through. Kevin was patient and helpful to ensure we understood what we needed to do and had the correct method we could apply to our roles going forward."

  3rd Nov 25 - With Kevin

•  
  
  

  "Kev was a brilliant teacher, super friendly, super helpful and I felt like he took the time to explain things really well. Highly recommend. Thank you Kev!"

  24th Sep 25 - With Kevin

•  
  
  

  "Kevin was a very kind, helpful, knowledgable teacher, who was very well prepared and clear (and very patient!) in his instruction and training. Thank you! I was beginner level with excel and he really took his time and made everything 'bite size' to ensure we were able to digest the new information as we went along. There were also a good amount of breaks and I really benefited from the small class so that we had a lot of hands-on and personalised help."

  Anna Bradbury - 24th Sep 25 - With Kevin

•  
  
  

  "Good courses on offer and delivered remotely and trainers are always first class"

  ALS Mechatronic - 7th May 25 - With Kevin

• More Reviews

Learn to automate Excel with VBA on this expert-led two-day course.

Covering macros, the Visual Basic Editor, procedures and functions, variables and data types, control-of-flow and loops, working programmatically with ranges and worksheets, structured error handling and building interactive user forms.

•  Record and run macros using the Developer tab
•  Work in the Visual Basic Editor confidently
•  Use variables, loops and control-of-flow structures
•  Work programmatically with ranges and worksheets
•  Build interactive user forms with form controls

•  
  
  

  "Great Teacher and teaching approach, loved the dynamic and learned so much."

  Met Police - 10th Aug 26 - With Tom

•  
  
  

  "Great trainer, very knowledgeable and approachable. Well-paced and catered to the ability of the participants. Regular breaks to keep engaged and not too repetitive."

  10th Aug 26 - With Tom

•  
  
  

  "Really thorough and could relate to struggles and correct some errors made"

  JLR - 22nd Sep 25

•  
  
  

  "Very interactive & trainer tailored the course to suit our needs"

  JLR - 22nd Sep 25

•  
  
  

  "Tom was fantastic, he tailored the course to suit what we were looking for meaning we will be able to use this in our day to day lives and make our jobs easier. Tom made the class interactive and kept us all really engaged. Highly recommend, thank you Tom"

  Jaguar Landrover - 22nd Sep 25

• More Reviews

This one-day Excel Power Query course teaches you how to import data from a range of sources, clean and reshape it, and create analysis-ready datasets.

Learn practical techniques for transforming data, combining multiple datasets, and loading results into Excel tables or the Data Model for reporting and analysis.

•  Import data from multiple sources
•  Clean up messy data quickly
•  Reshape data for easier analysis
•  Combine and organise different datasets
•  Load and refresh data with confidence