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.

Google Sheets – how to split text into separate columns

Written by Jane Hames

This article is aimed at people who use Google Sheets instead of Microsoft Excel as their main spreadsheet application. If you’d like to know more about Glide Training’s on-site training for users of Google Sheets and other Google G Suite products please click here.

Read more on Google Sheets – how to split text into separate columns…


Raise your spreadsheet skills with our new online Excel training course

Written by Jane Hames

We are pleased to announce the latest in our ongoing series of affordable online training courses.

Excel Formulas Made Easy

This course is designed for Excel users who are comfortable with entering data onto spreadsheets, but are looking to take the next step and begin using formulas to undertake more powerful calculations.

Read more on Raise your spreadsheet skills with our new online Excel training course…


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…


Next Page »