Glide Training Logo

March 2024

Drill down into your pivot table data with a double click

Our Quick Tip today shows you an easy way to drill down into your pivot table data without having to apply filters to get to the information you want to see. This works both on Excel and Google Sheets.

Read more on Drill down into your pivot table data with a double click…


Formulas for upper, lower & proper case text in Excel & Sheets

This week’s Quick Tip shows you how to make use of simple formulas to quickly change text into UPPER, lower or Proper case, both in Microsoft Excel and Google Sheets.

If you’d like to see more hints and tips on how to get the best out of the software and apps you use every day, take a look at our YouTube channel. Follow us for regular updates!

Read more on Formulas for upper, lower & proper case text in Excel & Sheets…


Select multiple tabs in Sheets and Excel

In this week’s quick tip we show you how to select multiple spreadsheet tabs in in either Word or Sheets, and apply an action to all of those tabs at once.

Read more on Select multiple tabs in Sheets and Excel…


Use SORT to keep dropdown lists in A-Z order in Excel and Google Sheets

Today’s quick tip shows you how to use the SORT function to keep your dropdown list items in A-Z sort order in Excel and Sheets. This video assumes prior knowledge of Data Validation for dropdown lists!

Read more on Use SORT to keep dropdown lists in A-Z order in Excel and Google Sheets…


Use TOROW and TOCOL to combine data into a single row or column in Sheets and Excel

In this quick tip we show you how to make use of the powerful TOROW and TOCOL functions that allow you to combine data from a range of cells into a single row or column. The process is exactly the same in Google Sheets and Microsoft Excel.

Read more on Use TOROW and TOCOL to combine data into a single row or column in Sheets and Excel…


Online Google Sheets Training

Or were you looking for On-site Google Sheets Training?

Why choose Glide for your online Google Sheets training?

We work on a bespoke, requirements-led basis rather than offer a set range of courses. We will work with you to identify your specific requirements and objectives before any training is delivered. That way you can be sure that training will always deliver exactly what you’re looking to achieve.

find out more

All our on-site training courses are delivered at our customers’ premises. Not only does that avoid any travel inconvenience for our customers, but also it means we don’t have the overheads required to maintain a dedicated training centre – and in turn we are able to pass these savings on to you.

find out more

Our trainers have designed and delivered IT training for a wide range of organisations and people including accountants, lawyers, data analysts, sales consultants and buyers. Clients benefit from our our ability to find creative solutions to their problems based on many years of experience.

find out more

Feedback from some of our Online Google training course attendees

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“IT Training and enthusiasm do not often go hand in hand, but Jane has achieved it! The trainees leaving the sessions with Jane have all said how useful the sessions have been and with big smiles and thumbs up all round. Many are already asking for more and can’t wait to see Jane back again. Thanks Jane!”

Get a Quote

-->


Online Google Sheets Training

We provide online Google Sheets training to users of all levels, from beginners who require basic spreadsheet skills to experts who wish to get the best out of the more advanced features. We also provide transition training for those who are moving from Excel.

Read more on Online Google Sheets Training…


On Site Google Sheets Training

Monday, November 30th, 2020

Or were you looking for Online Google Sheets Training?

Why choose Glide for your on-site Google Sheets training?

We work on a bespoke, requirements-led basis rather than offer a set range of courses. We will work with you to identify your specific requirements and objectives before any training is delivered. That way you can be sure that training will always deliver exactly what you’re looking to achieve.

find out more

All our on-site IT training courses are delivered at our customers’ premises. Not only does that avoid any travel inconvenience for your team, but also it means we don’t have the overheads required to maintain a dedicated training centre – and in turn we are able to pass these savings on to you.

find out more

Our trainers have designed and delivered on-site IT training for a wide range of organisations and people including accountants, lawyers, data analysts, sales consultants and buyers. Clients benefit from our our ability to find creative solutions to their problems based on many years of experience.

find out more

Feedback from some of our on-site training course attendees

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“IT Training and enthusiasm do not often go hand in hand, but Jane has achieved it! The trainees leaving the sessions with Jane have all said how useful the sessions have been and with big smiles and thumbs up all round. Many are already asking for more and can’t wait to see Jane back again. Thanks Jane!”

Get a Quote

-->


On-Site Google Sheets Training

We provide on-site Google Sheets training to users of all levels, from beginners who require basic spreadsheet skills to experts who wish to get the best out of the more advanced features. We also provide transition training for those who are moving from Excel.

Read more on On Site Google Sheets Training…


Online Google Workspace Training

Thursday, October 22nd, 2020

Or were you looking for
On-Site Google Workspace Training?

Why choose Glide for your online Google Workspace training?

We work on a bespoke, requirements-led basis rather than offer a set range of courses. We will work with you to identify your specific requirements and objectives before any training is delivered. That way you can be sure that training will always deliver exactly what you’re looking to achieve.

find out more

All our on-site IT training courses are delivered at our customers’ premises. Not only does that avoid any travel inconvenience for your team, but also it means we don’t have the overheads required to maintain a dedicated training centre – and in turn we are able to pass these savings on to you.

find out more

Our trainers have designed and delivered online IT training for a wide range of organisations and people including accountants, lawyers, data analysts, sales consultants and buyers. Clients benefit from our our ability to find creative solutions to their problems based on many years of experience.

find out more

Feedback from some of our online training course attendees

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“IT Training and enthusiasm do not often go hand in hand, but Jane has achieved it! The trainees leaving the sessions with Jane have all said how useful the sessions have been and with big smiles and thumbs up all round. Many are already asking for more and can’t wait to see Jane back again. Thanks Jane!”

Get a Quote

-->


online Google Workspace Training

Many organisations are making the change from Microsoft Office to Google Workspace (formerly known as G Suite). Google Workspace has some great tools for collaborative working and we help organisations to maximise the opportunities that it offers.

Read more on Online Google Workspace Training…


On Site Google Workspace Training

Thursday, October 22nd, 2020

Or were you looking for
Online Google Workspace Training?

Why choose Glide for your on-site Google Workspace training?

We work on a bespoke, requirements-led basis rather than offer a set range of courses. We will work with you to identify your specific requirements and objectives before any training is delivered. That way you can be sure that training will always deliver exactly what you’re looking to achieve.

find out more

All our on-site IT training courses are delivered at our customers’ premises. Not only does that avoid any travel inconvenience for your team, but also it means we don’t have the overheads required to maintain a dedicated training centre – and in turn we are able to pass these savings on to you.

find out more

Our trainers have designed and delivered on-site IT training for a wide range of organisations and people including accountants, lawyers, data analysts, sales consultants and buyers. Clients benefit from our our ability to find creative solutions to their problems based on many years of experience.

find out more

Feedback from some of our on-site training course attendees

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“I am so pleased I allowed myself the time to come to this course. I am now confident I can sort out my overly complicated spreadsheets and actually understand the data and use it effectively. Thank you so much!”

“IT Training and enthusiasm do not often go hand in hand, but Jane has achieved it! The trainees leaving the sessions with Jane have all said how useful the sessions have been and with big smiles and thumbs up all round. Many are already asking for more and can’t wait to see Jane back again. Thanks Jane!”

Get a Quote

-->


on-site Google Workspace Training

Many organisations are making the change from Microsoft Office to Google Workspace (formerly known as G Suite). Google Workspace has some great tools for collaborative working and we help organisations to maximise the opportunities that it offers.

Read more on On Site Google Workspace Training…


Google Sheets – how to split text into separate columns

Tuesday, April 30th, 2019

Written by Jane Hames

This article is aimed at people who use Google Sheets instead of Microsoft Excel as their main spreadsheet application. If you’d like to know more about Glide Training’s on-site training for users of Google Sheets and other Google G Suite products please click here.

Read more on Google Sheets – how to split text into separate columns…