Microsoft Excel and Google Sheets Training for Beginners

Duration 1-2 hours

Last audited 10th February 2023

CPD Approved
Microsoft Excel and Google Sheets Training for Beginners
For me
For teams
  • 100% online training

  • Start when you like

  • Learn on any device (desktop, mobile or tablet)

  • Instant assessment and result

  • 1 learner per course

  • Train teams of all sizes

  • Bulk discounts starting at 10% off 10 courses

  • Learn on any device (desktop, mobile or tablet)

£30 +VAT

include vat

Includes a 10% discount for 10+ courses

For beginners, Microsoft Excel and Google Sheets can appear complex, difficult or overwhelming tools to use. However, with a little bit of knowledge and confidence, you can soon start to include this common spreadsheet software in your day-to-day job role, and will discover that it quickly enhances your record-keeping and calculation skills.

This short course provides you with written instructions for how the key functions of Microsoft Excel and Google Sheets work, alongside a short video for each function to show you how the skills work in action, plus a workbook for each module so you can practice the skills yourself.

100% online training

Access anywhere

Same day digital certificate

Printed certificate posted next working day

Full audio voiceover

Unlimited assessment attempts

Developed by experts in Excel and Google Sheets

Accredited by CPD

What you'll learn

By the end of this short course, you will know how to:

  • Understand Microsoft Excel and Google Sheets terminology.
  • Perform simple calculations.
  • Input, sort, filter and edit data.
  • Use conditional formatting functions.
  • Create charts, graphs and pivot tables.
  • Use basic formulas and functions, including AVERAGE, SUM, SUMIF and SUMIFS, COUNTIF and COUNTIFS, IF and IFS, and VLOOKUP.

Training you can trust

  • Course Content
  • Assessment
  • Suitable for

Module 1: The Basics of Microsoft Excel and Google Sheets

Accessing Microsoft Excel and Google Sheets, the Microsoft Excel and Google Sheets interfaces, cells, columns and rows, worksheet tabs, ribbon tabs in Microsoft Excel and Google Sheets, ribbon and formula bars, data formatting and basic number formats.

Module 2: Introducing Formulas, Functions and Features

Formulas and basic calculations, an introduction to functions, fill handle, relative, mixed and absolute references, sort and filter, conditional formatting, and charts and graphs.

Module 3: Popular Functions


The online assessment is taken on completion of the training material. You will be asked 10 multiple-choice questions with a pass mark of 80%. The answers are marked automatically so you will instantly know whether you have passed. If you don't pass, don't worry! You can take the test as many times as you need with no extra charge.

This Microsoft Excel for Beginners course is designed for anyone who wishes to update, refresh or learn new spreadsheet skills. The content is ideal for complete beginners to the subject who want to gain some basic knowledge of Excel or Google Sheets, either for their current job role or a future position, and is also perfect as a refresher course for people who already use Excel but want to remind themselves of its key functions.

Course reviews