The Glide Training Blog

Not only news and announcements, but a handy collection of hints and tips to help you get the most out of the software you use.

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

Thursday, September 28th, 2023

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!

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

Friday, September 15th, 2023

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.

Move around an Excel workbook using the Navigation Pane

Tuesday, September 5th, 2023

In today’s quick tip we show you how to use Excel’s Navigation Pane to quickly and easily move around within your workbooks. Quickly switch between named ranges, tables, search for content and more.

Google Docs – using “make a copy” to avoid changes to the original

Thursday, August 10th, 2023

In this quick tip you will learn how to send a link to a document that will take the user directly to the “make a copy” option. Great for a document that needs to be treated as a template.

PowerPoint & Slides – format objects using colours from your screen

Thursday, June 29th, 2023

In this week’s quick tip we show you how to format objects in PowerPoint or Slides using colours from anywhere on your screen. Maybe you want to use the exact colour from your logo – you can very easily with this trick!

A quick and easy way to split data in Excel

Thursday, June 15th, 2023

In this quick tip we show you an alternative to the text to columns feature. Using CTRL E to apply Flash Fill you can easily split data into separate columns.

Search for a feature in Microsoft Office & Google Workspace

Tuesday, June 6th, 2023

In this quick tip we show you how to find and use a feature without having to search through the menus, ribbon or toolbar if you can’t remember where it’s located.

Create a Recurring Milestone in Microsoft Project

Tuesday, May 23rd, 2023

In this week’s quick tip we show you how to create a regularly occurring Milestone in a Microsoft Project plan.
#MSProject #training #MSOffice #ITtraining

How to use the Outline and Navigation panes in Word and Docs

Thursday, May 4th, 2023

Today’s top tip shows you a way to easily navigate a document in Microsoft Word or Google Docs that contains heading styles, by using the outline and navigation panes to go straight to the paragraphs that use those styles.

Save time by entering data within selected cells in Google Sheets and Excel

Tuesday, April 18th, 2023

In this quick tip, we show you how you to save time and effort when entering data across multiple rows and columns in Microsoft Excel and Google Sheets.