Microsoft Excel Intermediate

This Microsoft Excel Intermediate online course is delivered via Teams and is aimed at people who want to expand their knowledge of Microsoft Excel to work with larger spreadsheets, create formulas across multiple worksheets and workbooks, manage tables of data, and use advanced formatting techniques.
Get in touch
Price:
£175.00 + VAT
Duration:
1 Day
Learning style:
Live Online Training
Assured by:
Resources Included:
About this course

This Excel training covers practical skills for efficient data management and analysis.

Learners will learn to create formulas across multiple worksheets, enhancing their ability to perform calculations seamlessly.

It includes techniques for copying formats and values across multiple worksheets, ensuring consistent formatting throughout the workbook.

It explores the application of conditional formatting and custom formats, text manipulation and text functions, and learners will gain an understanding of Excel databases, including creating and modifying data tables.

COURSE PRE-REQUISITES:

Learners who wish to attend this course must have knowledge of Excel and feel comfortable with creating, formatting, and editing spreadsheets. They should be able to write formulas using multiplication, addition, subtraction, division and use the basic functions, sum, average, max, min and count.

Download Course Overview
Course dates
We are currently accepting admissions for the following upcoming cohorts:
  • 19th Mar 2026
  • 16th April 2026
  • 20th April 2026
  • 5th May 2026
  • 12th May 2026
  • 16th June 2026
Make an enquiry
Self-led online courses include
Support for over 100 languages
Mobile-friendly design for playback on any device
Progress tracking and pass/fail tests
Automatic, remote updates to keep content fresh
Playback speed controls to speed up/slow down the video
Closed captions which can be turned on/off
Includes over 30 AI audio translations
This course covers
  • Create formulas across multiple worksheets
  • Copy formats and values across multiple worksheets
  • Copy and link information across multiple workbooks
  • Apply conditional formatting and creating custom format
  • Manipulate text and use Text functions
  • Understand the concepts an Excel database and create and modify data tables
  • Use criteria ranges to analyse data using the Advanced Filter
  • Create sub totals and group & ungroup data
Pricing calculator
Get a quick cost estimate using our simple pricing calculator. Select the number of users and the number of courses you require to see your cost per user.

To learn more about our courses, or to request a tailored quote for your organisation, please contact us today and a member of our team will be happy to help.

Get in touch
Number of Users 50
Number of Courses 10
Cost Per User
£65.85
per user
Cost Per Course
£6.59
per course, per user
Total Cost
£3,292.50
excl. VAT
You may also like
View all courses
Get in touch
Teaching 4 Business provides online courses and learning management systems to businesses across a range of industries.
Thank you for your message, it has been received and we will respond shortly.
Oops! Something went wrong while submitting the form.
Teaching 4 Business is part of the We Teach You Group
© 2026 Teaching 4 Business
Designed & developed by Finn Elliott.