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

Advanced Google Sheets Training Course

On this Advanced Sheets training course you will learn to master some of the more sophisticated features of Google Sheets such as working with IFS, SUMIF, data validation techniques, conditional formatting, Sparklines and handling external data.

Our one-day advanced Google Sheets training courses offer a flexible range of topics based around your requirements and are available either 'face-to-face' on-premises or as live and fully interactive virtual training events. Once we have a date arranged and a trainer allocated to you, your dedicated trainer will call you to discuss your requirements and ensure that we meet your Sheets training needs across a wide range of subjects.

How Long Does it Take to Learn Google Sheets?

To get from beginners to advanced level usually takes three to four days of formal training. However, in order to become proficient you will need to put into practice what you learn, and there is still an awful lot more to learn in Google Sheets if you want to become an expert or a specialist.

What is the Best Google Sheets Course?

The best Google Sheets course is often the one that takes into account your particular learning needs rather than 'one size fits all' off-the-peg courses. That's why your trainer will speak to you before your course to confirm which subjects are best-fitted to your group's L&D objectives.

Google Sheets Advanced Training Course Prerequisites

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

On-site Google Sheets Advanced 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 Docs Editor apps, 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.

Live Virtual Classroom Advanced Google Sheets 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.

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.

Advanced Google Sheets Training Course Topics

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: Advanced Functions and Logical Functions in Google Sheets
  1. Recap VLOOKUP and introducing HLOOKUP
  2. Nested IF Functions
  3. The IFS Function
  4. Working with IFERROR and ISERROR
  5. Creating Data Validation Rules
  6. Linked worksheets with the SUMIF and INDIRECT Functions
  7. Array Formulas
     
     
• Module 2: Data Entry Validation Techniques in Google Sheets
  1. Creating Data Entry Rules for Text and Numerical Values
  2. Creating Dropdown List Criteria with Data Validation
     
     
• Module 3: Google Sheets Conditional Formatting
  1. What is Conditional Formatting?
  2. Apply conditional formatting to IF Functions
  3. Change the Colour of One Cell Based on the Value of Another Cell
  4. Conditional Formatting with Multiple Conditions using Colour Scales
     
     
• Module 4: Sparklines
  1. What are Sparklines?
  2. Create and Edit Sparklines
     
     
• Module 5: Google Sheets Document Protection
  1. Protect your Sheet
  2. Protect a Cell Range
  3. Un-Protect a Specific Cell Range
     
     
• Module 6: Working with External Data in Google Sheets
  1. The IMPORTDATA Function
  2. The IMPORTRANGE Function
  3. IMPORTRANGE Function permissions and document protection
  4. The IMPORTHTML and IMPORTXML Functions
  5. External Data Addons
     
     

Back to top