Glide Training Logo

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


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…


Move around an Excel workbook using the Navigation Pane


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.

Read more on Move around an Excel workbook using the Navigation Pane…


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


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.

Read more on Google Docs – using “make a copy” to avoid changes to the original…


PowerPoint & Slides – format objects using colours from your screen


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!

Read more on PowerPoint & Slides – format objects using colours from your screen…


A quick and easy way to split data in Excel


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.

Read more on A quick and easy way to split data in Excel…


Search for a feature in Microsoft Office & Google Workspace


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.

Read more on Search for a feature in Microsoft Office & Google Workspace…


Create a Recurring Milestone in Microsoft Project


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


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.

Read more on How to use the Outline and Navigation panes in Word and Docs…


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


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.

#GoogleSheets #Excel #training #MSOffice #GoogleWorkspace #ITtraining

Read more on Save time by entering data within selected cells in Google Sheets and Excel…


Next Page »