Courses
Learning Platforms
About us
Get in touch
Microsoft Excel Intermediate
This Microsoft Excel Intermediate course 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
Suitable for:
Duration:
1 Day
Learning style:
Virtual Classroom
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 thebasic functions, sum, average, max, min and count.

Download Course Overview
Course dates
We are currently accepting admissions for the following upcoming cohorts:
  • 12th November 2024
  • 9th December 2024
  • 16th January 2025
  • 16th February 2025
  • 11th March 2025
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
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
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
© 2024 Teaching 4 Business
Designed & developed by Finn Elliott.