Microsoft 365 AI, 6 levels

Microsoft Excel with AI courses
in Cardiff, in-house or online.

Excel training from beginner to expert, with AI features that speed up formulas, analysis and reporting.

Levels
6 courses
Duration
1 day each
Price
£195 per person
Next public date
5 October 2026
// Course levels

Choose your level.

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

Beginner level

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
Intermediate level

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
Advanced level

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
Expert level

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
AI Technologies level

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
Data Analyst level

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
// Who these courses are for

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 this course for your team

We can deliver Microsoft Excel with AI at your workplace, or live online. Private courses use examples from your own work, run on dates that suit you, and every delegate gets a course pack. There are no hidden costs.

Ask about an in-house course →
// Common questions

Frequently asked questions.

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 £195 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.
// Get started

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.

Book a consultation → info@apextrainingwales.co.uk