Contact Us
MICROSOFT BUSINESS SKILLS

Microsoft Excel Intermediate

  • Entry-level training course for Microsoft Excel
  • Delivery by Member of the Microsoft Partner Network
  • Flexible delivery available
  • Courses available for all Microsoft applications
  • Welsh Government funding accepted
READ MORE

Course Information

ENQUIRE TODAY
  • 1 Day
  • Non-Accredited
  • Funding Accepted
  • Remote Delivery (Live Webinar)

Strengthen your ability to analyse and present data with this Microsoft Excel Intermediate course.


Through this course, you will build on your existing Microsoft Excel knowledge, developing the confidence to work more effectively with data and formulas. You’ll gain a high-level understanding of how to analyse, refine, and present information clearly, helping you produce reliable insights and structured workbooks.

We start by revisiting formulas with relative, absolute and named references, then use logical functions to perform calculations based on criteria. You will learn how to apply conditional formatting to highlight patterns and use built‑in tools to manipulate text without writing a formula. Dates and times are explained clearly so results are accurate.
 
In this course, you will learn how to combine functions to match criteria and retrieve information, consolidate data for summaries and use the Analyse Data tool to surface quick insights. Throughout this course, the focus is a tidy workbook that others can follow.
 
You will leave this Excel Intermediate training with patterns you can reuse to clean data, answer common questions and present results with confidence.
Module 1: Formula control and references
Module 2: Logical functions and conditional formatting
Module 3: Text manipulation, dates and times
Module 4: Combining functions, consolidation and quick insights

There is no formal exam for this course. Learning is supported through guided discussion, practical examples and scenario-based activities across the day. Following the course you will receive a certificate of completion to include in your professional development file.

Why Learn With Us?

Accredited certifications

Practical, workplace-relevant learning

Full or part funding available

Flexible delivery options

Frequently Asked Questions

No. This is a practical skills course focused on confident use of Microsoft Excel.

You can contact us directly via the contact page, or fill out the form here.

Anyone who wants to discover more about the basics of Microsoft Excel. Learners should have completed the Excel essentials course first.

An active Microsoft 365 for Business account and Excel (desktop).

This course is delivered through a 6‑hour interactive webinar.

Related Courses

VIEW ALL
client testimonials

Talent you can trust

Against tight deadlines, Aspire 2Be delivered an excellent quality of service and content, further developing the ongoing collaborative partnership between our two organisations
Dr Scott Morgan
Head of Digital Innovation
& IT Services
Bridgend College Logo - Coleg Pen-y-Bont
We are proud to have been able to develop this project with Aspire 2Be for local schools and communities. By partnering with Aneurin Leisure Trust and delivering this project across all 6 libraries in Blaenau Gwent means that anyone and everyone can access sessions on Coding and Micro:bit programming
Julie Timothy
Team Leader, Blaenau Gwent STEM Facilitation Project
Blaenau Gwent County Council Logo
The team have provided creative insight and web development skills to move the school’s work forward immeasurably. The team’s dedication to providing the highest quality resources is, in my experience, second to none.
Stephen Lowe
Headteacher
Medical Needs in Schools Logo - Oxfordshire hospital schools
Tagged ,