The Glide Training Blog

Written by Jane Hames If you are a Microsoft Project user, you might be using recurring tasks to add monthly stakeholder events or other regular activities. It’s useful to remember that recurring tasks, don’t actually have to be tasks with durations, resources and costs. I have found recurring tasks useful when I’ve needed to create […]

Written by Jane Hames I am often asked how to find blank cells in Excel within a specific range of data. Just having a look through your data could be time consuming, but there is a quick and easy way to find blank cells in Excel. Here’s what you need to do: Select the data […]

Written by Jane Hames If you use Excel to summarise and analyse data with pivottables, there may be some very useful options that you haven’t yet discovered (because they are fairly well hidden!). One such feature is the PivotTable Report Pages option. If you are using a report filter (you will have a field name […]

Written by Jane Hames On an Excel course this week, I was asked how to apply an advanced filter to show records that contain some blank cells. This is something that isn’t very obvious, but if you know how to use the advanced filter in Excel, you will find it very easy! Here’s a snippet […]

Written by Jane Hames If you have set up a formula in one workbook that uses cells from a different workbook, the two workbooks become linked. It is useful to be able to go to linked cells in an Excel formula, and it would be great to be able to do that both quickly and […]

Written by Jane Hames How to find images that are free to use in Microsoft Word and Google Docs When searching for an image to insert into a Microsoft Word or a Google Docs Document, do you check the copyright? Depending on the software you are using to create your document, and the search engine […]

Written by Jane Hames More and more, PowerPoint users want to avoid “Death By PowerPoint”. Bullet points can be overused in PowerPoint and during recent PowerPoint training we have been thining about how we could replace bullet points with something else. Most good presenters who use bullet points, just give a teaser or a summary […]

Written by Fiona Doran-Smith You may be surprised to even see Emotional Intelligence (EI) and Excel used in the same sentence. You might be wondering what on earth one has to do with the other. Well, read on and discover how using your EI can help you to be more effective in Excel. As described by […]

Written by Jane Hames This guide is aimed at Excel users who can already use the VLookup function and want to learn more about it. This is how to use the Excel Vlookup using TRUE If you use a VLookup, the chances are you will use FALSE as the Range Lookup finding an exact match […]

Written by Jane Hames Need to remove underline from hyperlinks in PowerPoint? Here’s an easier alternative If you have added a hyperlink to text in PowerPoint, the default theme will make it blue and underlined. I often get asked how to change this, and one option is to create your own theme with a custom […]