Corporate Google Sheets Training in London & Nationwide
We offer private Google Sheets training both virtually/online and in-person. All courses are Instructor-led and delivered by our TPMA accredited trainers. Scroll further down this page to see our course outlines, pricing and further information on our Google Sheets Training courses.
Google Sheets Introduction – 1 day course
Introduction Course Outline
- Shortcuts and important data fundamentals
- Fast & efficient ways of navigating, selecting and entering data
- Accessing files and folders
- Creating basic formulas for calculations – percentages, averages, SUM, etc…
- Relative & Absolute cell addressing (use of $ within formula’s)
- Arranging data & creating tables from scratch – best practices
- Sorting and Filtering Data
- Creating Charts and graphs
This course aims to provide less experienced users with an Introduction to what Google Sheets is all about. This training will provide you with an understanding of how basic Google sheets formulas work and how to arrange your data in the right way. It will also highlight the difference in approaches between Google Sheets and MS Excel.
On completion of the course you will be able to create spreadsheets from scratch in an efficient way and with appropriate formatting applied for clarity. You will be able to create basic formulas in your Excel spreadsheets and/or Google spreadsheets, sorting & filtering data and learn how to create charts.
- In-Person: 09:30 – 16:00
- Virtual: 09:00 – 14:00/14:30
| Virtual Classroom | In Person on Client’s Site | In Person at our Training Centre | |
|---|---|---|---|
| 1:1 Training | £499 + VAT | £499 + VAT | £499 + VAT |
| 2-3 Users | £750 + VAT | £799 + VAT | £850 + VAT |
| 4-6 Users | £899 + VAT | £999 + VAT | £1,099 + VAT |
| 7-8 Users | £1,050 + VAT | £1,099 + VAT | £1,249 + VAT |
| 9-10 Users | – | £1,299 + VAT | £1,399 + VAT |
All prices exclude VAT
Additional delegates can be added for £150 per additional person.
Companies outside of London will incur a £100 travel fee for in person onsite training.
Please call 020 7183 7740 or email enquiries@weareexcel.co.uk to BOOK NOW /discuss a class in more detail.
Google Sheets Intermediate – 1 day course
Before you attend this course you need to have attended our Google Sheets Introduction course or be confident with the content covered on it.
This means being able to create and edit simple spreadsheet tables; navigate around spreadsheets; and basic formulas.
Intermediate Course Outline
- Accessing files and folders
- Working with Dates and Time – e.g., ageing and forecast
- Using Data Validation to create drop-down entries and other data entry controls
- Making decisions with the IF Function
- Adding, Counting and Averaging subsets of data with SUMIFS, AVERAGEIFS and COUNTIFS
- Finding & copying data with XLOOKUP (VLOOKUP for Excel 2016 and earlier versions
- Analysing data with Pivot Tables
This Course aims to provide spreadsheet users with a smart approach to working with spreadsheet data. Giving users useful and practical techniques for working with large spreadsheets and spreadsheets that require data analysis. You will practise using a range of time saving and accuracy ensuring features.
You will be able to use a range of efficient spread sheet techniques that save time and ensure accuracy when working with large and/or detailed data sets.
- In-Person: 09:30 – 16:00
- Virtual: 09:00 – 15:00/15:30
| Virtual Classroom | In Person on Client’s Site | In Person at our Training Centre | |
|---|---|---|---|
| 1:1 Training | £499 + VAT | £499 + VAT | £499 + VAT |
| 2-3 Users | £750 + VAT | £799 + VAT | £850 + VAT |
| 4-6 Users | £899 + VAT | £999 + VAT | £1,099 + VAT |
| 7-8 Users | £1,050 + VAT | £1,099 + VAT | £1,249 + VAT |
| 9-10 Users | – | £1,299 + VAT | £1,399 + VAT |
All prices exclude VAT
Additional delegates can be added for £150 per additional person.
Companies outside of London will incur a £100 travel fee for in person onsite training.
Please call 020 7183 7740 or email enquiries@weareexcel.co.uk to BOOK NOW /discuss a class in more detail.
Google Sheets Advanced – 1 day course
Before you attend this course you need to have attended our Google Sheets Intermediate course or be confident with the content covered on it.
This means being able to create and write your own VLOOKUP/XLOOKUP functions; create and write your own Logical functions.
Advanced Course Outline
Making decisions through Nested Logical Functions – IF, AND, OR
Finding and copying data with Nested XLOOKUP functions – sophisticated Lookup techniques (VLOOKUP for Excel 2016 and earlier versions)
- XLOOKUP extended capabilities – e.g. wild card LOOKUP & returning multiple columns (or INDEX and MATCH for Excel 2016 and earlier versions)
- Finding and copying multiple records using FILTER function (** NEW **)
Course Aims and Objectives
This course aims to provide spreadsheet users with advance spreadsheet solutions to common data analysis challenges. Providing users with hands-on practice analysing spreadsheet tasks.
You will be able to be able to analyse spreadsheet data using advanced Excel features and add formulas to data in an efficient way.
- In-Person: 09:30 – 16:00
- Virtual: 09:00 – 15:00/15:30
| Virtual Classroom | In Person on Client’s Site | In Person at our Training Centre | |
|---|---|---|---|
| 1:1 Training | £499 + VAT | £499 + VAT | £499 + VAT |
| 2-3 Users | £750 + VAT | £799 + VAT | £850 + VAT |
| 4-6 Users | £899 + VAT | £999 + VAT | £1,099 + VAT |
| 7-8 Users | £1,050 + VAT | £1,099 + VAT | £1,249 + VAT |
| 9-10 Users | – | £1,299 + VAT | £1,399 + VAT |
All prices exclude VAT
Additional delegates can be added for £150 per additional person.
Companies outside of London will incur a £100 travel fee for in person onsite training.
Please call 020 7183 7740 or email enquiries@weareexcel.co.uk to BOOK NOW /discuss a class in more detail.
See what our customers have said about our Google Sheets Training
Looking for One to One Training ? Please click here to see our One to One training options.
