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 G-Sheets course you can learn some of the more powerful features such as the IF function and the VLOOKUP function, and working with references, ranges and Google Sheets worksheet security.

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 classes for your learners offering more flexibility than off-the-shelf courses and topics can often be tailored to meet 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 staff who are confident and proficient with Google Sheets doesn't only increase productivity and efficiency, it can even be good for morale.

Our trainers know that helping students to work more effectively isn't just a business goal, it's also empowering. They aren't just educators, they're also software champions who promote enthusiastic adoption of Google Sheets amongst their trainees. Before the start date they'll discuss your team's training goals with you, whether they're setting off 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 whether you're in a major city such as London, Manchester, Birmingham, Leeds, or anywhere else.

This offers a 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'd rather that your team learns remotely, these small-group Google Sheets courses are also available as live virtual, interactive sessions from the comfort of your own office or workplace. These instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we've all become used to Online learning (and live virtual meetings) it is clear that virtual classroom delivery has some advantages over traditional face-to-face learning.

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

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

Our virtual classroom Google Sheets courses cost £550.00 plus VAT p/day inclusive up to 5 delegates. More learners can be added up to a limit of 10 charged at £50.00 plus VAT per person p/day. Courseware will be provided electronically.

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

Our Google Sheets trainers are:

Inspirational subject experts with a wealth of experience, 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 24,000 students trained across almost every industry, sector and background.

Why Choose Our Google Sheets Courses?

• Step-by-Step Training: Instructor-led, in-person Google Sheets training with engaging step-by-step demos, lessons and hands-on exercises.
  
  
• Q&A Courses: Dynamic and interactive Sheets courses with ample time for questions and answers.
  
  
• The Personal Touch: Expert tuition, tailored to your team's knowledge level and learning needs, and covering the Google Sheets features and tools that your staff need most.
  
  
• Small Class Sizes: Private, corporate training with a limit of 10 participants per session to ensure personalised attention.
  
  
• Scalable Courses: Can be run as one or more courses, or as a training rollout bringing entire departments and organisations up to the benchmark of G-Sheets knowledge and confidence needed.
  
  
• Regular Teaching Hours: 9.30AM to 4.30PM with a lunch hour and short breaks morning and afternoon. Courses run week days, during normal business hours.

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.

Actual course content may vary, depending upon your learning requirements.

• 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