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.

Microsoft Outlook Shortcut Keys

Written by Jane Hames

Microsoft Outlook Shortcut Keys

When delivering training courses, the particpants are often very keen for me to share keyboard shortcuts with them. The invention of the touch screen does not seem to have reduced requests for help with saving time using keyboard shortcuts. I find that Outlook shortcut keys are not commonly known, so here’s a few that should save a bit of time. Have a practise of these as soon as you can so they they become embedded in your mind…they’ll soon become second nature!

Read more on Microsoft Outlook Shortcut Keys…


Reset a PowerPoint Slide to its Slide Master Settings

Written by Jane Hames

Reset a PowerPoint Slide to its Slide Master Settings

If you have edited the formatting of a PowerPoint slide individually you may have detached it from its slide master. This means that it will be inconsistent with other slides. Also, if you change the formatting on the slide master, the changes may not be carried through to this slide. You can reset a PowerPoint slide to its slide master settings. Here’s how:

Read more on Reset a PowerPoint Slide to its Slide Master Settings…


How to copy formatting in Excel, Word and PowerPoint using the Format Painter

Written by Jane Hames

How to copy formatting in Excel, Word and PowerPoint

I regularly want to copy formatting in Excel, Word or PowerPoint but rather than having to carry out the same formatting steps again, I use the Format Painter. This is a quick and easy tool to use, you just to need to know about it and then remember to use it.

Read more on How to copy formatting in Excel, Word and PowerPoint using the Format Painter…


Customise the Toolbar in Word, Excel, PowerPoint, Outlook (Quick Access Toolbar)

Written by Jane Hames

Customise the Toolbar in Word, Excel, PowerPoint, Outlook

The toolbar in Word, Excel, PowerPoint, Outlook or other Microsoft Office programs is called the Quick Access Toolbar. It contains a few buttons ready for you to use, but it can be customised to include other things that you use frequently.

Read more on Customise the Toolbar in Word, Excel, PowerPoint, Outlook (Quick Access Toolbar)…


Excel Number Formatting For International Users

Written by Jane Hames

Excel number formatting for when working with users with a different international format

As often happens during Excel training, recently a question came up that I had not been asked before. The way people use Excel is so personal to their own style, the type of work they do and what their organisation does, so I love it when a question is asked that enables me to do some troubleshooting and experiment with new ways of working.

Read more on Excel Number Formatting For International Users…


Using The Windows Snipping Tool For Taking A Screen Shot / Screen Grab

Written by Jane Hames

The Windows Snipping Tool for taking screen shots / screen grabs

I frequently need to take a screen shot / screen grab of just part of what is on my screen which I will then paste into a Word document or PowerPoint slide. My favourite tool for doing this is the Snipping Tool which comes free with Windows 7. Here’s how to use it.

Read more on Using The Windows Snipping Tool For Taking A Screen Shot / Screen Grab…


How To Prohibit Weekends Using Data Validation

Written by Jane Hames

How to prohibit weekends using Data Validation

The standard Data Validation offers some really useful options such as controlling the dates, text and numbers that can be entered in to cells. A few times recently, I have been asked how to set up data validation so that it only allows weekdays to be entered and sees weekends as invalid.

Read more on How To Prohibit Weekends Using Data Validation…


How to create a variable drop down list in Excel

Written by Jane Hames

Creating a variable drop down down list using Indirect

During some advanced Excel training, I was asked how to create a variable drop down list in excel using a data validation list that changes depending on the value in a related cell. The reason for the question was so that estimators entering building supplies into a data list could enter the name of the material and then select from a list of quantities that that specific material can be ordered in. Always up for a challenge, I decided to use my creativity and I found a solution through the combined use of data validation and the indirect function.

Read more on How to create a variable drop down list in Excel…


Remove date formatting from cells in Excel

Written by Jane Hames

How to fix numbers when they appear as a date in cells:

When a cell has been formatted as a date, that formatting will be remembered (unless you clear it). What this means is that even if you press delete on the keybaord to clear the contents of a cell, that does not remove formatting. This often presents itself as a problem when a date has been typed into a cell and then later on a number is entered into the cell. This is how to remove date formatting in Excel:

Read more on Remove date formatting from cells in Excel…


Excel Data Labels: How to add totals as labels to a stacked bar chart (pre-2013)

Written by Jane Hames

On some recent Excel 2010 training a question came up about how can the totals be shown as data labels rather than as a bar in the chart. In pre-2013 versions this is not obvious and to begin with I was stumped, but (as is often the case with software use) a bit of creative thinking and trial and error, we came up with a solution. Here’s what we did:

Read more on Excel Data Labels: How to add totals as labels to a stacked bar chart (pre-2013)…


« Previous PageNext Page »