The Glide Training Blog

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 […]

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) […]

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. Fomatting keys First select the cell or cells to be formatted and then do the […]

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. If you want to edit those notes or save them as a Word document, this […]

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 […]

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! Using the Excel Pivot Table Slicer with Groups On a recent Advanced Excel training course, I was asked by a buying […]

Written by Jane Hames Lists of data are often received in a format that is not ideal for the work that needs to be carried out with it. One example of this is when you have first name and surname in one cell, where you really need the information to be in two separate cells. […]

Written by Jane Hames I have been delivering Word training to secretaries this week and they like to have two spaces after a full stop. For a lot of us one space is enough, but for those who are “proper” typists or trained secretaries two spaces is the correct way to do things. This explain […]

Written by Jane Hames In Excel you can centre values within a cell, merge cells and centre values within those cells, but my preferred option is the one that I often get asked about – Center Across Selection. Center Across Selection, centres values across a range of cells. The advantage of this option is that […]

Written by Jane Hames I often hear a ripple of words like “wow”, “ooo, I never knew that”, “ahhh, write that down” when I show my workshop participants how to use the Transpose feature, so I thought I would share it with you too! Transpose enables you rotate the orientation of data with row and […]