Excel Courses in Newcastle

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

•  
  
  

  "The trainning was very good. The explanantion in every step was very clear. TThe trainer is very nice and calm. I really enjoyed the day and learn a lots. The number of people was perfect.Thank you."

  Corinthia Hotel - 20th July 26 - With Lisa

•  
  
  

  "Well prepared with spreadsheets to work on. Kevin kept me engaged and knew the answer to anything we asked"

  30th June 26 - With Kevin

•  
  
  

  "Communication, patience and explaining each section of the course"

  27th May 26 - With Kevin

•  
  
  

  "Knowledge, presentation, organisation, patience."

  MET POLICE - 27th May 26 - With Kevin

•  
  
  

  "Very clear, knowledgeable teaching at a good pace for a basic user. The training materials were easy to access and use."

  27th May 26 - With Kevin

• 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

•  
  
  

  "Great Explanations and easy to understand"

  24th July 26 - With Monica

•  
  
  

  "Talking things through, always asking if we had any questions."

  24th July 26 - With Monica

•  
  
  

  "Monica was very good. Very engaging, took her take to explain things , and answered all questions. Would recommend"

  Dragados - 21st July 26 - With Monica

•  
  
  

  "Really good explanations, helpful to those who needed assistance with effective support, great examples to work with that we can practice on at a later date."

  21st July 26 - With Monica

•  
  
  

  "Hands on help with accraute detailed explanation. Super effective"

  Miller Homes Ltd - 26th June 26 - With Monica

• 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

•  
  
  

  "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 July 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 July 26 - With Monica

•  
  
  

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

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

•  
  
  

  "Training was very thorough and enjoyable. Answered all my questions and used my real life example to help me understand further."

  9th July 26 - With Sue

•  
  
  

  "Very thorough, helpful to have data to work with and practice. Took on board real life examples we gave and showed how we could apply it."

  9th July 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 November 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 September 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 September 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

•  
  
  

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

  JLR - 22nd September 25

•  
  
  

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

  JLR - 22nd September 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 September 25

•  
  
  

  "Really very thorough, very approachable and an enjoyable course"

  Jaguar Landrover - 2nd September 25

•  
  
  

  "Very thorough referencing and alternative working options"

  JLR - 2nd September 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