Spread the cost of your course...
pay in instalments - interest FREE

AFFORDABLE COURSES –
LOW DEPOSIT £19.99 – 0% APR

About This Course

Google Sheets is Google’s answer to Microsoft’s Excel, and it is rapidly overtaking its predecessor in the workplace. The software has adopted many of Excel’s features and functions and enhanced them to provide a bigger and better experience for spreadsheet users. So, if you’re spreadsheet skills are rooted in Excel, or you’re new to spreadsheets completely, Google Sheets will get you up to scratch. Don’t be left behind; learn the ins and outs of Google Sheets with our online Google Sheets course.
 

Who is this course for?
Google Sheets is an online training course designed for users of Google Sheets who wish to unlock everything the software has to offer. It is an ideal introduction to the software for Google Sheet-newbies, yet it is also a fantastic refresher course for more experienced Google Sheets users.


What will you get from this course?
Upon course completion, you will be a Google Sheets expert. You will understand how to make the most of Google Sheets and be able to add the software to your skillset as a result. Google Sheets will enable you to create perfect formulas, impressive charts and graphs and much more, every single time; spreadsheets have never been simpler.  
 

When you have completed this course, you will be able to:
  • Confidently navigate the functions and layout of Google Sheets 
  • Adjust the way that data and information is displayed 
  • Create charts, graphs and Scatterpots
  • Access and import XML and HTML files 
  • Use advanced tools like Macros, Importing HTML and Scripts to replicate Excel’s functions
  • Write powerful formulas quickly and easily with the point-and-click method
  • Utilise data tools such as sorting, subtotalling and filtering 
  • Automate tasks with time-saving scripts and add-ons 

Course features 
  • Easy-to-follow lessons which you can dip in and out of at your leisure 
  • Adaptive technology for a personalised learning experience
  • Inventive content for an engaging study programme
  • Course material created by Microsoft training experts  
  • Downloadable audio transcripts and practice exercises

Syllabus

  • The Basics: introduction to Google Sheets with an overview of the basic functions and layout of Google Sheets 
  • Manipulating Data, Functions and Formulas:
    • Manipulating data: sort, find and replace data, manipulate views and access a spreadsheet’s revision history 
    • Functions and formulas: the difference between math functions, logical functions and text functions and Google Sheet formulas 
  • Charts and Graphs: create charts and Scatterplots 
  • Lookups: VLOOKUP and HLOOKUP and spreadsheet manipulation 
  • Pulling Data from a Spreadsheet: import data and files with ImportXML and ImportHTML
  • Using Macros and Other Tools: macros, tools to use with Google Docs and spreadsheet boosters 
  • Course Summary: access official Google templates and conclude your newfound knowledge 

Accreditation

This course has been accredited by Online Academies. On successful completion of this course you will be able to download or print off a PDF of your Online Academies Certificate (please note: you will also be given the opportunity to have a hard copy of the certificate printed off and posted out to you for a small additional charge). If you would like to view a sample of the certificate, please click here.

On completion of your course you will also be able to have your certificate endorsed and accredited by the CPD Certification Service for recognised CPD Hours.

The CPD Certification Service was established in 1996 as the leading independent CPD accreditation institution operating across industry sectors to complement the Continuing Professional Development policies of professional institutes and academic bodies. The CPD Certification Service provides recognised independent CPD accreditation of our courses.

 

Assessment

At the conclusion of each module there is a multiple choice question assessment. This will help you remember the main points of the lesson and act as a check that you have retained the essential knowledge and understanding of that particular section. The results can be seen instantaneously and you can correct wrong answers. When the result is satisfactory you can progress to the next module.

Course Outcomes

Once you have successfully completed all the modules for your course you will be awarded:

A Diploma issued by Online Academies

Choose your payment option
and ENROL now

Payment Options Pay in Full Pay using 0% APR Instalments Plan
Deposit £319.99
£159.99
£19.99
Instalments X 3
Monthly Payment X £100.00
£46.67
Total Price £319.99
£159.99
Enrol
£319.99
£159.99
Enrol

Once you have enrolled on your chosen course above, you will be given an additional 75% OFF voucher which you can use to get another course. You can share it with your friends and family or use it yourself to build your portfolio of qualifications to make your CV stand out. Your code will be given to you once you have enrolled on your first course.

Powerpoint 2010 Intermediate

Do you want to take your presentations to the next level? PowerPoint 2010 Intermediate will show you how to build creative prese...

£199.99 £49.99
More Details

Excel 2010 Advanced

Do you want to master Excel? Learn how with Excel 2010 Advanced. The course teaches you the ins and outs of all things...

£199.99 £49.99
More Details

Excel 2013 Basic

Excel 2013 Basic teaches the basic functions and uses of the 2013 version of Microsoft Excel. IT skills are essential ...

£199.99 £49.99
More Details

Dreamweaver CS5 Intermediate

Do you know the basics of Adobe Dreamweaver CS5 but want to take your knowledge further? If so, Dreamweaver CS5 Intermediate is ...

£199.99 £49.99
More Details

Newsletter Sign-Up

Be the first to get news and exclusive deals

Upskill for free with one of our free courses

Find out more

Choose your payment option
and ENROL now

Payment Options Pay in Full Pay using 0% APR Instalments Plan
Deposit £319.99
£159.99
£19.99
Instalments X 3
Monthly Payment X £100.00
£46.67
Total Price £319.99
£159.99
Enrol
£319.99
£159.99
Enrol
Payment Options
Price
Full Payment:
£319.99
£159.99
Deposit £319.99 £159.99
Instalments X
Monthly Payment X
Total Price £319.99 £159.99
Pay Now: £19.99
0% APR
Deposit £19.99
Instalments 3
Monthly Payment £100.00 £46.67
Total Price £319.99 £159.99

Testimonials

Read More

Click on a star below to rate this course

Be the first to rate this course