Skip to content
Microsoft Excel Intermediate cover image

Microsoft Excel Intermediate
Course Central

MS Excel tools and techniques for the workplace| PDF Certificate | Video Training

Summary

Price
£39 inc VAT
Study method
Online
Course format
Video
Duration
2 hours · Self-paced
Access to content
12 months
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Overview

An intermediate-level Microsoft Excel covering more text, date, lookup and math functions expands to formula auditing to efficiently complete complicated excel tasks with a career guideline for anyone with any skillset to analyse your data or finances in detail.

This course on improving formatting, organising data, highlighting essential information and creating formulas/links between sheets will improve your accuracy and productivity and help you better understand critical features to enhance efficiency.

This Microsoft Excel Intermediate 2- course bundle consists of the following courses:

  • Course 1: Microsoft Excel: Top 50 Excel Formulas
  • Course 2: Microsoft Excel: VLOOKUP Formula

These skills are essential for anyone going into investments, banking, or consulting and will also be helpful for administrators or those who track or analyse a lot of data.

Also, someone new to the workforce will find that employers are looking for candidates with at least intermediate Excel skills.

MS Excel Intermediate course is designed for anyone who works with Excel in the workplace. An industry-renowned entrepreneur with a tech background developed this roadmap to reduce cost and sharpen efficiency in any business sector.

What will you learn from this course?

  • A better, faster, more robust Excel use
  • Save hours and boost your productivity in Excel
  • Use math, statistical, logic and text functions
  • In 60 minutes, you'll be able to master the Excel formula VLOOKUP!
  • Recognize the most important portion of the VLOOKUP formula.
  • Excel may completely change the way you work.

Why Choose this MS Excel course?

  • Conducted by industry experts
  • Get Instant E-certificate
  • Entirely online, interactive course with Professional voice-over
  • Developed by qualified professionals
  • Self-paced learning and laptop, tablet, and smartphone-friendly
  • Tutor Support

And you will also get these gifts

  • Free PDF Certificate
  • 12 Months Course Access

Certificates

Certificate of completion

Digital certificate - Included

Course media

Description

Course Content

***Course 1: Microsoft Excel : Top 50 Excel Formulas ****

  • Have Microsoft Excel Problems?
  • How to Get the Most from this Course
  • Text Formulas In Excel
  • Text Formulas Exercise
  • Text Formulas Exercise - Answers
  • Mathematical Formulas In Excel
  • Mathematical Formulas Exercise
  • Mathematical Formulas Exercise - Answers
  • Date and Time Formulas In Excel
  • Date and Time Formulas Exercise
  • Date and Time Formulas Exercise - Answers
  • Logic Formulas In Excel
  • Logic Formulas Exercise
  • Logic Formulas Exercise - Answers
  • Financial Formulas In Excel
  • Financial Formulas Exercise
  • Financial Formulas Exercise - Answers Financial Formulas Exercise - Answers
  • Informational Formulas In Excel
  • Informational Formulas Exercise
  • Informational Formulas Exercise - Answers.

***Course 2: Microsoft Excel : Top 50 Excel Formulas ****

  • Menu Example with Excel Vlookup
  • Wildcard Search with Excel Vlookup
  • Looking to the Left with Excel Vlookup
  • 2-Way Lookup
  • Comparing Lists with Excel Vlookup
  • Microsoft Excel Vlookup Tips and Tricks
  • What’s Next?
  • Free Ebook

Certificates

Course Central is proud to offer a Certificate of Completion to all who complete courses successfully. Course Central tracks the learner’s course progress. However, the learner is responsible for validating the completion and understanding of the course. All Certificates of Completion can be validated from the Course Central website using the validation code.

Transcripts

A Transcript for the course with completed module details can be requested for as little as £4.99. Please note that all course Certificates and Transcripts will be titled as published on the Course Central platform.

Who is this course for?

This intermediate course is designed for those who work with Excel in the workplace and primarily for those who want to improve their skills with this program. Explore this intermediate Microsoft Excel course if you have used Excel before and want to expand your knowledge. You’ll be able to skill in improving formatting, organising data, highlighting essential information and creating formulas/links between sheets. Improve your accuracy and productivity by utilising list management, handling large worksheets more effectively and enhancing the formatting of your spreadsheet data by using conditional formulas. Enhance your understanding of key features.

Requirements

Existing qualification level: No specific previous qualification is required. However, a basic understanding of Maths, English and ICT would benefit in understanding the content.

Existing skill levels: Minimum ICT skills to operate any computer system is beneficial. No skill in working with Excel worksheets is essential.

Technical requirements: Access to any computer or laptop would benefit from practising and following the instructions.

Career path

Excel will open many opportunities for anyone due to its versatile use in business settings, from project management to human resources, financial analysts, accountants, business analysts, retail managers, project managers, data journalists, and not limited to this.

The salary expectation can grow from £20,000 per annum to £45,000 per annum.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.