Microsoft Excel and Google Sheets Training for Beginners
Quantity: 1
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
-
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.
This course was last audited on: 10th Feb 2023
- Developed by experts in Excel and Google Sheets
- Accredited by CPD
- Fully online course and assessment with no time limits
- Full audio voiceover
- Approximate duration: 1-2 hours
- Same day digital certificate. Printed certificate posted the next working day
Aims of the course
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.
Certification
All of our courses are accredited by the CPD Certification Service as conforming to universally accepted Continuing Professional Development (CPD) guidelines.
On successful completion of the course you will be sent a quality assured certificate through the post the next working day. This can be used to provide evidence for compliance and audit.
Screenshots (click to view)
If you wish to try this course then register for a demo by clicking the 'interactive demo' button. You will be given the option to purchase and continue with your course at the end of your demo!
Interactive Demo
Course content
| Module | Description | |
|---|---|---|
| 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. |
| 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. |
| 3 | Popular Functions | AVERAGE, SUM, SUMIF, SUMIFS, COUNTIF, COUNTIFS, IF, IFS, VLOOKUP and Pivot Tables. |
Download Course Overview (PDF)
Assessment
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.
Who should take this course?
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
Other courses you may be interested in
How do our courses work?
1
Purchase and payment
Add your chosen course to your basket. Once you’ve added all the courses you need, follow our step-by-step checkout process where you can purchase using Debit or Credit card.
For companies ordering 5 or more courses, you’ll also be given the option to pay by invoice.
2
Course access
Once you’ve completed your purchase, look out for an email containing the details you’ll need to start your training.
If you’ve purchased a single course, we’ll send you a unique course code. You can use this to add your training to an existing account, or create a brand new one.
Purchased multiple courses for training your team? We’ll email you all the login details you need to distribute to your staff.
3
Certificate
If your delivery address is in the UK, we will send a hard copy of your certificate to your UK postal address once you’ve completed your course. Although we try to deliver your certificates as soon as possible, please allow 3-4 working days for delivery.
Don’t want to wait? You can instantly download your digital certificate as a PDF after course completion.
Additionally, please note that if your company is paying by invoice we can only issue certificates after your order has been fully paid.
4
Continued support
Our friendly customer support team is happy to help at any stage of your training. Call us on 0333 006 7000 or contact support@highspeedtraining.co.uk, and we’ll do our best to answer any questions you may have.
Additionally, have you seen our help page? It’s full of useful information to help guide you through your training experience.