2013 - Glide Training

September 2013

Excel shortcut keys to save you time and frustration

Thursday, September 19th, 2013

Written by Jane Hames

If you like using keyboard shortcuts to improve your efficiency, these two Excel shortcut keys are not so well known, but can be very useful to format numbers as a percentage or with the pound symbol.

PowerPoint – Exporting Notes Pages to Word

Wednesday, June 12th, 2013

Written by Jane Hames

In PowerPoint it is useful to be able to print your notes pages along with miniatures of your slides. The notes could be for the benefit of the presenter or to hand out to the audience.

Confused by the symbols used in Excel formulas?

Tuesday, February 26th, 2013

Written by Jane Hames.

Last week, one of my Excel workshop participants said they were confused when looking at Excel formulas with quotes, exclamation marks, colons and commas. I thought that my response was worth sharing as I’m sure he’s not the only one to be confused by this.

The formula below, is calculating the average of the values in cells in a different WORKBOOK across two different WORKSHEETS.

A Clever Use of Slicers in an Excel Pivot Table

Tuesday, January 29th, 2013

Written by Jane Hames

I have posted a how-to guide about slicers before, but Excel Pivot Tables are such a popular tool for data analysis and people can become a bit attached to them!