Microsoft Excel Training Courses

This intensive one-day course is designed for beginners – no previous experience in Excel is required. This course provides a solid introduction to Excel and is ideal for those who are familiar with using a personal computer.

In this Microsoft Excel course you will:

• Navigate Excel: efficiently using key commands and features.
• Use formulas and functions: to perform calculations swiftly and minimise work with reusable formulas.
• Modify worksheets: by adjusting cells, formatting data, and utilising proofing tools, as well as formatting worksheets professionally.

This intensive one-day course is ideal for learners who have foundation knowledge of Excel and want to explore its more advanced features. Before taking this course a basic understanding of Excel is recommended.

In this Microsoft Excel course you will:

• Master working with named ranges: use logical, date, and time functions for efficient data handling.
• Analyse data comprehensively: by creating and modifying tables and applying conditional formatting.
• Visualise data dynamically: with charts, and utilise PivotTables and PivotCharts for in-depth data analysis and presentation.

This intensive one-day course is designed for learners who want to build on the Microsoft Excel Introduction and Intermediate courses. It is suitable for those with existing Excel experience seeking to advance their skills further.

In this Microsoft Excel course you will:

• Utilise: links, external references, and data consolidation across multiple worksheets and workbooks.
• Automate workbook functionality: with data validation, error detection, and macro implementation.
• Enhance analysis capabilities: with lookup functions and dynamic arrays and create dynamic visualisations with sparklines and map data.

This one-day Excel VBA Programming Introduction course introduces experienced Excel users to writing and editing Macros. No prior programming experience is required.

In this course you will:

• Acquire foundational skills in Visual Basic for Applications (VBA): including displaying the Developer tab, recording and running macros, understanding the development environment, and managing macro security.
• Master procedures, functions, and objects: by understanding modules, creating procedures, navigating the Excel object hierarchy, working with collections, properties, methods, and event procedures.
• Develop proficiency in VBA programming: through naming procedures, calling procedures, using the Immediate window, and working with the code editor effectively.

This 2 day Excel VBA Programming Advanced course introduces advanced Excel users to the process of working with control structures, developing user forms to accept or display data, validating data entry in user forms, debugging and handling errors in code, and automating advanced tasks.

The course requires prior knowledge of Excel and basics of VBA programming. While familiarity with PivotTables may be helpful, it is not essential.

In this course you will:

• Advance your coding skills with VBA logic and data handling: declare and manage variables, apply data types, work with intrinsic functions and constants, and control program execution using decision-making and looping structures.
• Design and manage interactive UserForms: build custom forms, configure controls and properties, write event-driven code, and enhance interactivity with buttons, combo boxes, and option groups.
• Enhance automation with advanced VBA tools: programmatically control PivotTables, use debugging features to identify and fix issues, and implement robust error handling techniques for reliable, professional code.

This intensive, one-day, hands-on Data Analysis and Visualisation with Excel Introduction course provides you with the foundational knowledge of Data Analysis and will help you gain comprehensive, practical understanding of Data Analysis using Excel.

In this course you will:

• Gain a foundational understanding of data analysis: covering introduction to data science, creating and modifying tables, sorting and filtering data.
• Learn to visualise data effectively in Excel: including creating and modifying charts, formatting charts, and applying best practices in chart design.
• Master data analysis techniques using formulas and functions: analysing data with formulas and named ranges, using functions, implementing data validation, forms, and controls, and creating conditional visualisations with lookup functions.

This intensive, two-day hands-on Data Analysis and Visualisation with Excel Advanced course builds upon the foundational knowledge presented in the Excel Data Analysis Introduction course and helps you gain comprehensive, practical understanding of Data Analysis using Excel.

In this course you will:

• Enhance visual analysis with advanced tools: create geospatial map charts, customise them for clarity, and integrate additional visualisation features such as trendlines and sparklines.
• Transform and prepare complex datasets: connect to multiple data sources using queries, clean and combine data, and shape and transform information for deeper analysis.
• Leverage Power Pivot for advanced modelling: install and enable Power Pivot, build and manage sophisticated data models, perform advanced analysis, and present findings through professional reports.

The Excel Data Analysis Introduction course covers dashboards and working with databases, while the Excel Data Analysis Advanced course focuses on data modelling and Power Pivot, providing a clear progression from foundational to advanced skills.

This one-day course is ideal for learners who already have experience with Excel and want to explore how generative AI can support, streamline, and enhance their spreadsheet use.

It is especially valuable for professionals who work with data regularly and are looking to save time, reduce errors, and make more informed business decisions.

In this course you will:

• Generate spreadsheet content: use GenAI tools to create formulas, functions, and data quickly and accurately.
• Enhance productivity: apply AI support to everyday Excel tasks, saving time and minimising repetitive work.
• Solve problems strategically: leverage AI guidance to troubleshoot issues and gain insights that support confident decision-making.

During this one-to-one Excel course, you can choose the level you want to study, from Introduction to Advanced. This personalised approach allows learners of any level to gain an in-depth understanding of Excel through intensive training.

In this course you will:

• Customise your Excel learning experience: from Introduction to Advanced levels, covering all aspects and differences across versions.
• Gain comprehensive Excel skills: tailored to your chosen level, with certification options available upon completion.
• Select from a range of course objectives and content: ensuring a personalised and intensive training experience suited to individual learning needs.

• Start: 09:00am
• Morning break: 11:00am
• Lunch: 01:00pm
• Afternoon break: 03:00pm
• Finish: 05:00pm

This schedule applies to all 1-day, 2-day, and 3-day courses, whether delivered virtually, in the classroom, or on-site. For on-site training or larger group bookings, start and finish times can be adjusted to suit your organisation’s needs. To discuss a customised schedule, call us on 0115 958 6699 or complete our Request a Quote form and a member of our team will be in touch.

Yes — we can deliver training directly at your workplace. Whether you require one-to-one sessions, group training, or fully bespoke on-site courses, we tailor the content and delivery to meet your organisation’s specific needs.

To arrange workplace training, call us on 0115 958 6699 or complete our Request a Quote form, and a member of our team will be in touch to discuss your requirements.

For classroom training you typically don’t need to bring any equipment, unless we specifically advise otherwise. All necessary resources will be provided at our training centre.

For virtual training you will need a computer or laptop with the full version of the software relevant to your course. We also strongly recommend using a second screen, such as a tablet or smartphone, so you can complete exercises on your main device while viewing the virtual whiteboard or trainer’s screen on the second.

If you are unsure which course level best matches your current skills, we're here to help. Simply give us a call on 0115 958 6699, and one of our expert trainers or course advisors will guide you in choosing the most suitable training level for your needs.

We pride ourselves on delivering high-quality training—something made possible by our exceptional team of tutors. All our trainers have extensive practical experience, specialist knowledge, and a strong background in teaching and training. Their expertise ensures that every course is engaging, relevant, and effective.

We’re happy to provide tutor profiles and references upon request—just get in touch.

Absolutely! After completing your training, you’ll receive a range of post-course support materials, allowing you to revisit the content at your own pace. In addition, we offer 12 months of support, so you can ask questions, seek clarification, or get guidance as you apply your new skills in real-world situations.

We're committed to helping you continue your learning journey long after the course ends.