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.

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

How Long Does it Take to Learn Google Sheets?

To get from a beginners through to an 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 dedicated trainer will speak to you before your course date to confirm which subjects are best-fitted to your group's learning and development 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 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 Docs 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.

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

Advanced Google Sheets Training Delivery Method for Closed Courses for Businesses

• 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.

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.

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: 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