Microsoft Excel and Google Sheets Training for Beginners
Quantity: 1
Microsoft Excel and Google Sheets Training for Beginners
Duration 1-2 hours
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
-
Pay by invoice with 30 day payment terms available (5+ courses)
£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.
Please note this course only includes a digital version of your certificate.
100% online training
Access anywhere
Same day digital certificate
Full audio voiceover
Assessment retakes at no extra cost
Learn at your own pace with no completion deadlines
Developed by experts in Excel and Google Sheets
Accredited by CPD
Bulk discount for orders of 10+ courses
Bigger orders = bigger discounts
Save on our courses when you buy more training upfront. Lock in a better price now and access the training whenever you need to. You can mix and match any of our courses too and get the discount off your whole order.
10+ courses = 10% off
50+ courses = 20% off
100+ courses = 30% off
500+ courses = 40% off
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
Accredited by CPD
All of our courses are accredited by the CPD Certification Service as conforming to universally accepted Continuing Professional Development (CPD) guidelines.
Engage and empower
Our in-house Learning Designers develop all of our courses to give you and your learners the most engaging training possible.
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
AVERAGE, SUM, SUMIF, SUMIFS, COUNTIF, COUNTIFS, IF, IFS, VLOOKUP and Pivot Tables.
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.
Frequently asked questions
How do I access the training?
All of our training is done within your web browser - there are no apps to download or software to install.
After picking the courses you need and completing your purchase, you will receive a confirmation email. To access our courses yourself or to distribute them to others you just need to click the ‘Get Started’ button within the email and select which option you want. You will then be able to add the course(s) into an existing account, or create a new account.
Can I buy training for my team?
Of course just add the amount of courses you need and follow the purchase process. Please do be aware that it is one course per learner so they will all need their own course.
When buying courses for a team you'll also get access to our Management Suite free of charge. This is a tool that will allow you to allocate, track and review the training of your team.
Did you know? - We offer free training sessions on how to get the most from your Management Suite. To benefit from this, please contact: managersupport@highspeedtraining.co.uk to get your session booked in.
If I order multiple courses will I receive any discount?
Yes, our bulk discounts are automatically applied to orders containing any combination of courses. We offer the following discounts on bulk purchases:
If you purchase 10+ courses you receive a 10% discount
If you purchase 50+ courses you receive a 20% discount
If you purchase 100+ courses you receive a 30% discount
If you purchase 500+ courses you receive a 40% discount
What payment options are available?
You can pay for our training using either a Debit or Credit card.
For companies ordering 5 or more courses, you’ll also be given the option to pay by invoice. If you would like to pay by invoice for fewer than 5 courses then please contact our Sales Team by calling 0333 006 7000 or emailing us at sales@highspeedtraining.co.uk.
Can I access the training material after I have completed my course?
Yes. You can use your username and password to log in and revisit the training material as many times as you like, even after completing the course.
Is there a time limit on completing the course?
No, we want our courses to work around you so there’s no time limit in which you must complete the training after making a purchase. You can also split your training over as many different sessions as you wish, as course progress is saved as you make your way through the training. You’re free to learn entirely at your own pace.
