Google Sheets Training Course Level 2 UK Wide - On-site and Online

Intermediate Google Sheets Training Course

This intermediate Google Sheets training course is a closed event and offers a flexible range of subjects enabling you to focus upon the particular skill-sets you need the most for using Google Sheets in the workplace. On this Google Sheets course you can learn some of the more powerful features of Sheets such as the IF function and the VLOOKUP function, and working with references, ranges and Google Sheets worksheet security.

Email us or call 0844 493 3699 to find out more about booking Google Sheets training for your team.

You will be able to decide upon the exact topics taught in liaison with your trainer and even opt to incorporate a few subjects from the beginners or advanced level for a more blended learning solution.

Google Sheets Intermediate Training Course Prerequisites

In order to attend this course you should already have basic Google Sheets skills and knowledge equivalent to our Google Sheets Beginners training course.

On-site Google Sheets Intermediate Courses in the United Kingdom

Our closed courses for Google Sheets are delivered as private courses for your learners offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your particular learning needs.

Sheets is one of the most powerful and useful of the Google Doc Editor suite of applications, but also often the one with which people can struggle the most, and that they find the most frustrating to work with. In fact, having team members and colleagues that are confident and proficient with Google Sheets can not only increase productivity and efficiency in the workplace, it can even be good for morale.

Our mobile trainers understand that helping their students to work more effectively is not just a business-oriented goal, it is also empowering for the individual students themselves. As such, our trainers are not just educators, they also champions of the software who endeavour to promote enthusiastic adoption of Google Sheets among those they teach. Before the start date they will discuss with you the goals and objectives of the training and those skill-sets that your team need the most whether they are starting as novice, intermediate or advanced users.

With our on-site Google Sheets courses our regional trainers come to your workplace throughout England, bringing the training to you regardless of whether you are in a major city such as London, Manchester, Birmingham or Leeds, or anywhere else. This offers a really cost-effective way to train small groups and entire departments in the comfort of familiar surroundings from the Capital City of London to The Cotswolds, from Hampshire to Northamptonshire, West Midlands to West Yorkshire, Sussex to South Yorkshire, Norfolk to Northumberland, Lancashire to Lincolnshire, Cambridgeshire to Gloucestershire, Bristol to Berkshire, Essex to the East Riding and everywhere inbetween.

Live Virtual Classroom Google Sheets Intermediate Courses, UK and Beyond

If you have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Google Sheets courses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These Online instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.

If you are looking for local training near you, then you can't get any closer to your doorstep than you can with virtual learning.

Our virtual learning Google Sheets courses cater for groups of up to ten people and your learners benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.

Our realtime virtual classroom Google Sheets courses are charged out at £550.00 plus VAT per day inclusive up to 5 delegates. Further learners can be added up to a maximum of 10 charged out at £50.00 plus VAT per person per day. Courseware will be provided electronically.

You can find out how to set up Microsoft Teams for a live Online virtual course here (Virtual Learning with MS Teams).

We really ❤ love helping UK organisations to master Google Sheets. Our only question is: Will it be yours?

Our Google Sheets trainers are:

Specialist educators with a wealth of experience and expertise, proven track records and excellent feedback.

Our Closed Google Sheets Courses are:

Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.

Education is Our Passion:

Over 18,000 students trained across almost every industry, sector and background.

Intermediate Google Sheets Training Delivery Method for Closed Courses

• Instructor-led Google Sheets training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
  
  
• Dynamic and interactive Google Sheets courses with plenty of time for questions and answers.
  
  
• The personal touch: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering the Google Sheets functions, features and techniques that your trainee staff, co-workers or employees need the most.
  
  
• Private, corporate Google Sheets training for small group sizes with a maximum of 10 learners on any course.
  
  
• Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level of Google Sheets knowledge that you require.

Intermediate Google Sheets Training Course Outline

You can combine Beginners, Intermediate and Advanced Sheets topics for a blended training programme of up to three days in duration.

We specialise in delivering flexible training programmes and the actual course content, topics and syllabus taught will often vary depending upon your learning requirements and upon the version of the software taught.

• Module 1: Functions and Formulas in Google Sheets
  1. Working with Name Ranges
  2. The IF Function
  3. The COUNTIF Function
  4. The VLOOKUP Function and Index/ Match
  5. Nesting and Concatenating Functions
  6. The Filter Function
  7. The Query Function
     
     
• Module 2: Google Sheets Pivot Tables
  1. What are Pivot Tables?
  2. Creating a Sheets Pivot Table
  3. Date Fields and Calculated Fields
  4. Slicers and Filters
  5. Drill Down
     
     
• Module 3: Google Sheets Data Filtering
  1. What are Filters and Why to Use Them?
  2. Sorting and Filtering
  3. Performing Simple Searches
  4. Filtering by Condition
  5. Working with User-Defined Formulas
  6. Working with Filter Views
  7. Removing Filters
     
     
• Module 4: Charts in Google Sheets
  1. Applying Styles and Formatting to your Charts
  2. Working with Pie Charts
  3. Working with Bar Charts
  4. Working with Line Charts
  5. Working with Scatter Charts
     
     
• Module 5: Google Sheets References
  1. Annotating Sheets with Comments
  2. Inserting, Editing and Deleting Hyperlinks
  3. Google Sheets Templates
     
     
• Module 6: Google Sheets Add-ons
  1. What are Add-ons and Where to Find Them?
  2. Installing Add-ons
  3. Removing Add-ons
     
     
• Module 7: Google Sheets Macros
  1. What are Macros?
  2. Record a Macro
  3. Run a Macro
  4. Edit a Macro
     
     
• Module 8: Google Sheets Smart Features
  1. Power Tools
  2. SmartFill
  3. Smart Cleanup
  4. The TRIM function
     
     

Back to top