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.

FREE online training from Glide Training!

Written by Jane Hames

We are pleased to announce the release of a new FREE online training course.

Speed through Excel with Autofill

This is the first of a number of online courses we will be launching during 2018 and beyond. The courses will cover a number of popular office applications including Microsoft Office, Google G Suite and more.

Read more on FREE online training from Glide Training!…


Managing Change in the IT World – My PC Pro Magazine Article

Written by Jane Hames

For any organisation, changing software can be seen as a major headache. As any IT professional involved in such projects will know, changing an IT system isn’t as simple as buying a new product and rolling it out to the users. There are many implications for the users of the new system which, if acknowledged, will make for a much smoother and more positive go-live.

Read more on Managing Change in the IT World – My PC Pro Magazine Article…


Using the Details View in Microsoft Project

Written by Jane Hames

With the Details View in Project, you can easily move between tasks and resources, viewing details about them. I find that this is a huge time saver as I don’t need to switch views as the details can be displayed at the bottom of the screen. Here are some examples of the type of information you can view:

Read more on Using the Details View in Microsoft Project…


How to change PivotTable grouping in one table without affecting another table

Written by Jane Hames

This post is aimed at those who already use PivotTables (as many of my trainees do!).

PivotTable grouping is easy enough to do, but it could cause a lot of frustation if you want to change the grouping in one table without changing the way that field is grouped in another table.

Read more on How to change PivotTable grouping in one table without affecting another table…


How to get even more than training from your training!

Written by Jane Hames

You might be surprised how easy it can be to get much more than what is traditionally expected from your training.

Imagine that you have a training course booked in for next week. Of course, you are hoping to learn some useful information and techniques. I would expect that you also hope to feel confident that you can put these new techniques into practise when you return to work, but how could you make absolute best use of this time in the training room?
I have been an IT trainer since 1998, and every time I see a group of people get together for the training, whether they are total strangers or colleagues, if they choose to, they can get way more from the day than perhaps expected. I am not talking about the content of the training or the objectives you want to achieve in order to help you back in the work place, you can read my tips about this here:

Read more on How to get even more than training from your training!…


Create a recurring milestone in Microsoft Project

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.

Read more on Create a recurring milestone in Microsoft Project…


Find Blank Cells In Excel

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:

Read more on Find Blank Cells In Excel…


Show PivotTables over separate sheets using Report Filter Pages

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 in the Report Filters/Filters part of the pivottable layout box, you have the ability to filter the pivottable without having to show that field in the pivottable itself. See example below:PivotTables over separate sheets using Report Filter Pages

Read more on Show PivotTables over separate sheets using Report Filter Pages…


Excel Advanced Filter – find records with blank cells

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 of my data which does have a couple of records which are missing some data.find records with blank cells with advanced filter

Read more on Excel Advanced Filter – find records with blank cells…


Go to linked cells in an Excel formula (Quickly!)

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 easily!

Read more on Go to linked cells in an Excel formula (Quickly!)…


« Previous PageNext Page »