Up to 75% fundedCopilot and AI focusends 31 Mar 2027

Microsoft Excel with AI training in-house across Wales, up to 75% funded.

From first formulas to expert analysis, with Copilot and AI applied to your own spreadsheets and reports, at your workplace.

Excel training delivered in Swansea, Cardiff and across Wales, at your workplace or live online.

Levels
6 one-day courses
Price
£275 per person
With 75% funding
£68.75 per person
Delivery
Your workplace or live online
In-house for your teamRecommended

Plan in-house training for your team

Course fees at £275 per person
£2,200
Welsh Government (75%)
−£1,650
Your net cost
£550

£68.75 per person after funding

Get a funded in-house quote Apply for funding on Business Wales

Indicative, for eligible Wales-based businesses. You pay the course fees and the Welsh Government reimburses its share after the training. Funding is discretionary and capped at £50,000 per application.

Choose your level.

Each level is a one-day course. Pick a level to see what it covers and book a public date.

Microsoft Excel Beginner course

Start your journey into spreadsheet mastery with our Microsoft Excel Beginner AI Course. Designed for those new to Excel, this course not only covers the core skills of spreadsheet use but also introduces how AI-powered tools can support data entry, analysis, and reporting. Participants will learn to confidently navigate Excel, input data, perform essential calculations, and explore how AI can enhance efficiency in everyday tasks.

Microsoft Excel Beginner course

What the course covers

  1. Module 1

    Excel Basics and Navigation

    Develop a strong understanding of Excel fundamentals, including cell formatting, data entry, and basic formula usage. Learn how AI assistance can speed up navigation, suggest shortcuts, and automate repetitive actions.

  2. Module 2

    Basic Formulas and Functions

    Master foundational formulas and functions such as SUM, AVERAGE, and VLOOKUP. Discover how AI can help identify the right formula for your needs, check for errors, and guide you through applying calculations to real-world scenarios.

  3. Module 3

    Data Visualisation with Charts

    Learn the basics of creating bar charts, pie charts, and line graphs to transform raw data into clear visuals. Explore how AI tools can recommend the most effective chart type, auto-format visuals, and highlight key trends in your data for smarter decision-making.

Join us on this AI-powered learning journey to kickstart your Excel proficiency and harness the combined power of spreadsheets and intelligent automation to improve data management and analysis.

The Microsoft Excel course was a transformative experience, providing a comprehensive and practical education that significantly enhanced my proficiency in data analysis, visualisation, and spreadsheet management.

Sarah L., Finance Officer

Microsoft Excel Intermediate course

Elevate your spreadsheet expertise with our Microsoft Excel Intermediate AI Course. Designed for learners who already understand Excel basics, this course explores advanced features, formulas, and AI-enhanced data analysis techniques. Participants will discover how to streamline workflows, optimise calculations, and apply intelligent tools to solve complex data tasks.

Microsoft Excel Intermediate course

What the course covers

  1. Module 1

    Advanced Data Analysis

    Unlock Excel’s powerful data analysis tools, including PivotTables, data filtering, and sorting. Learn how AI can accelerate insight generation by identifying trends, suggesting pivot structures, and highlighting anomalies in large datasets.

  2. Module 2

    Advanced Formulas and Functions

    Master advanced Excel functions such as IF statements, nested functions, and array formulas. Discover how AI assistance can recommend the best formula for your scenario, automate complex logic, and reduce errors in large-scale data processing.

  3. Module 3

    Data Validation and Protection

    Implement robust data validation rules and spreadsheet protection methods to ensure accuracy and security. Explore how AI can help monitor data integrity, detect inconsistencies, and provide real-time recommendations for safeguarding sensitive information.

By the end of this AI-powered course, participants will be equipped to handle more sophisticated Excel tasks with confidence, efficiency, and accuracy.

The Microsoft Excel course exceeded my expectations, offering a well-structured curriculum that demystified complex Excel functionalities, equipping me with valuable skills to boost productivity and efficiency in both personal and professional tasks.

Jason M., Operations Manager

Microsoft Excel Advanced course

Unlock the full potential of Excel with our Microsoft Excel Advanced AI Course. Designed for experienced users, this course dives deep into Excel’s most powerful features, advanced formulas, and intelligent data visualisation techniques. Participants will discover how AI can streamline modelling, enhance reporting, and provide smarter insights for complex data analysis.

Microsoft Excel Advanced course

What the course covers

  1. Module 1

    Advanced Formulas and Functions Mastery

    Master complex Excel functions, including advanced array formulas, financial calculations, and lookup functions. Learn how AI can recommend formulas, auto-correct errors, and accelerate complex data manipulation with precision.

  2. Module 2

    Data Modelling and Analysis

    Explore advanced modelling tools such as What-If Analysis, Scenario Manager, and Goal Seek. Discover how AI-powered insights can highlight key scenarios, optimise outcomes, and assist in making data-driven strategic decisions.

  3. Module 3

    Advanced Charting and Dashboards

    Build interactive dashboards, advanced charts, and dynamic visualisations to transform complex datasets into compelling reports. Learn how AI can suggest the best visuals, automate formatting, and uncover patterns that might otherwise remain hidden.

By the end of this course, participants will confidently apply advanced Excel techniques alongside AI-driven tools to model, analyse, and communicate data with maximum impact.

The Microsoft Excel AI Course stands out for its practical approach and insightful instruction, empowering me with the knowledge and confidence to harness the full potential of Excel for data manipulation, reporting, and decision-making.

Priya D., Marketing Analyst

Microsoft Excel Expert course

Take your skills to the highest level with our Microsoft Excel Expert AI Course. Designed for professionals who already use Excel regularly, this course empowers you to master advanced formulas, business intelligence tools, and automation techniques. Delivered by expert trainers, it blends practical real-world applications with AI-driven enhancements to maximise efficiency, accuracy, and decision-making in the workplace.

Microsoft Excel Expert course

What the course covers

  1. Module 1

    Advanced Formulas and Functions

    Gain mastery of powerful functions such as INDEX-MATCH, XLOOKUP, IFERROR, and complex nested formulas. Discover how AI can recommend functions, detect logic errors, and optimise formulas for real-time data manipulation at scale.

  2. Module 2

    Data Analysis and Business Intelligence Tools

    Explore advanced Excel tools including PivotTables, Power Query, and advanced charting. Learn how AI can uncover hidden trends, automate queries, and suggest the most effective dashboards to transform raw data into actionable insights.

  3. Module 3

    Automation with Macros and VBA Basics

    Streamline repetitive tasks with macros and get introduced to Visual Basic for Applications (VBA). See how AI can assist by auto-generating code snippets, suggesting automation steps, and helping you customise Excel to fit your team’s workflow.

By the end of this course, participants will not only master Excel’s most powerful tools but also learn how to integrate AI assistance to work faster, smarter, and with greater precision.

I've used Excel for years, but this Expert course showed me just how much more there is to learn. From advanced formulas to powerful data tools, every part of the course was packed with practical skills I could apply straight away. It's made my day-to-day work faster and more accurate.

Tom H., Business Analyst

Microsoft Excel AI Technologies course

This in-house course explores the exciting integration of artificial intelligence within Microsoft Excel. Designed for professionals who want to harness AI-powered features, this course will help you boost productivity, make smarter decisions, and unlock hidden insights in your data. With hands-on guidance, you will learn to enhance your workflows using Excel's cutting-edge AI capabilities.

Microsoft Excel AI Technologies course

What the course covers

  1. Module 1

    AI-Powered Data Analysis

    Learn how to use Excel's built-in AI tools such as Ideas, Data Types, and Smart Lookup to analyse and interpret your data. These features help you quickly identify trends, outliers, and key takeaways without complex formulas.

  2. Module 2

    Predictive Insights with Excel and Azure Integration

    Discover how Excel can work with Microsoft Azure Machine Learning models to run forecasts and predictive analytics. This module empowers you to go beyond descriptive data and make informed decisions based on future outcomes.

  3. Module 3

    Automation and Natural Language Tools

    Use Power Automate and natural language features like "Analyse Data" to streamline tasks and ask Excel questions in plain English. Gain practical skills in automating reporting and simplifying complex operations using AI.

The course was incredibly well-structured, with plenty of real-world examples that made the advanced features easy to understand. I now feel confident using PivotTables, advanced functions, and even basic macros; things I always avoided before. The in-house format also made it really relevant to our team.

Ellie G., Data Strategist

Microsoft Excel Data Analyst course

This in-house course is tailored for professionals who want to develop strong data analysis skills using Microsoft Excel. Whether you are working in finance, operations, marketing, or admin, this course will equip you with the tools and techniques to transform raw data into meaningful insights. With a focus on real-world application, you will learn how to analyse, interpret, and present data effectively.

Microsoft Excel Data Analyst course

What the course covers

  1. Module 1

    Data Cleaning and Preparation

    Master techniques to clean, format, and structure raw datasets using tools like Flash Fill, Text to Columns, and advanced filtering. This module ensures your data is analysis-ready and free from errors.

  2. Module 2

    Analytical Tools and Techniques

    Explore core analysis tools such as PivotTables, conditional formatting, and summary functions like COUNTIFS and AVERAGEIFS. Learn how to uncover trends, patterns, and relationships within your data.

  3. Module 3

    Data Visualisation and Dashboards

    Create compelling data visualisations using charts, slicers, and interactive dashboards. You will gain the skills to present your findings clearly and confidently to stakeholders.

This course helped me go from competent to confident in Excel. It didn't just show me how to use the tools, but also how to think differently about data. I now build reports and dashboards that really impress my managers and save time every month.

David R., Project Coordinator

Flexible Skills Programme · Welsh Government

75% of your Excel training costs, paid by the Welsh Government.

The re-launched AI Skills Pilot funds 75% of approved training that puts AI to work on business-specific tasks, until the end of March 2027. Run in-house, this course is built around Copilot and the AI features in Excel, applied to your own files, so it fits what the pilot is for. Eligible Wales-based businesses can claim up to £50,000 per application.

Relevant Business Wales training area: Data analytics and data science: business intelligence.

151days left to complete funded training under the AI Skills Pilot (ends 31 March 2027)

  1. Plan the training with usWe tailor Excel to your use cases and send a quote with the course details and costs your application needs.
  2. Submit an Expression of InterestA short form on Business Wales. A Relationship Manager can help if you want support.
  3. Receive your award letterThe Welsh Government checks eligibility and invites a full application. Decisions typically take about 10 working days.
  4. We train your team in-houseAt your workplace anywhere in Wales, or live online, completed before the end of March 2027.
  5. Claim back 75%Paid in arrears once you send evidence that staff completed the course and that you paid the training provider.
  • Business based in Wales
  • Financially solvent
  • Staff released to train by the end of March 2027
  • Training certified at Level 2 or above

Funding is discretionary and the final decision on eligibility and award rests with the Welsh Government. Apex Training Wales is a training provider and does not decide eligibility. Source: Business Wales, Flexible Skills Programme and AI Skills Pilot update (October 2026).

Who these courses are for.

These Microsoft Excel courses cater to individuals at varying proficiency levels, whether you are a beginner looking to initiate your spreadsheet journey, an intermediate learner seeking advanced data analysis skills, or an advanced professional ready to master intricate data modelling, automation, and visualisation techniques. Tailored for businesses, analysts, and professionals in diverse industries, these courses provide essential skills to efficiently manage, analyse, and present data using Microsoft Excel. Join us to unlock the full potential of Excel for streamlined data processes and informed decision-making.

Elevate your data analysis capabilities with our Microsoft Excel AI Courses, where you will delve into the intricacies of spreadsheet functions, data modelling, and advanced features, empowering you to excel in manipulating data and making informed decisions with confidence.

In-house training delivered at a client's workplace

Run any level for your team

Every level can run at your workplace or live online, built around your own files, and eligible Welsh businesses can have up to 75% of the cost funded.

Get a funded in-house quote

In-house, built around your business

Excel, applied to your own work.

Generic online courses teach the tool. We bring Excel training to your workplace and build every exercise around the jobs your team actually does, so the skills are in use the next morning. Business-specific use cases are exactly what the refreshed AI Skills Pilot is designed to fund.

In-house Excel training at a client workplace
01

Copilot on your reports

Ask questions of your own spreadsheets and get formulas, charts and summaries back.

02

Monthly reporting, automated

Rebuild a report your team produces by hand so it refreshes itself.

03

One version of the truth

Clean, structure and protect the workbooks your team shares.

  • Groups of 1 to 50+
  • Dates that suit you
  • Course pack for every delegate
  • Live online for multi-site teams
Plan an in-house course

Frequently asked questions.

Can Microsoft Excel with AI be funded through the Flexible Skills Programme?
Eligible Wales-based businesses can apply for a 75% Welsh Government contribution to training costs through the Flexible Skills Programme AI Skills Pilot, which runs until the end of March 2027. Funded training must be certified at Level 2 or above by a regulated awarding body, and funding is discretionary. Tell us you are applying and we will supply the course details and costs your application needs. For Microsoft 365 courses, the 75% rate applies where the training is built around Copilot and AI, which is how we run them in-house.
How do we apply for the funding?
Complete the Expression of Interest form on the Business Wales website. The Welsh Government checks eligibility, invites a full application and typically makes a decision within 10 working days. You can make more than one application in a year, with up to £50,000 of funding per application.
Do we pay for the training up front?
Yes. You pay the course fees, and the Welsh Government reimburses its share in arrears once you provide evidence that staff completed the course and that you paid the training provider.
Which level should I choose?
We run 6 one-day Microsoft Excel with AI courses: Beginner, Intermediate, Advanced, Expert, AI Technologies and Data Analyst. Beginner: new to the software. Intermediate: know the basics. Advanced: confident users. Expert: power users. AI Technologies: built-in ai features. Data Analyst: analyse and present data. If you're unsure, contact us and we'll recommend the right starting point.
How much do the courses cost?
Each course runs for one day and public places are £275 per person. Private courses for your team are quoted on request.
Can you run these courses for our team at our workplace?
Yes. We deliver in-house at your offices in Cardiff, across Wales and throughout the UK, for groups from one to over fifty people, with exercises based on your own work.
Are the courses available online?
Yes. Every level can run as a live, trainer-led online session.
Can we combine levels into a programme?
Yes. Many teams take two or more levels back to back, or mix levels across a department after a short skills review.

Tell us what your team needs to learn.

A short call is enough for us to recommend a course or put together a programme and a quote.