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.
Tuesday, April 30th, 2019
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…
Saturday, September 1st, 2018
Written by Jane Hames
We are pleased to announce the latest in our ongoing series of affordable online training courses.
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…
Saturday, June 30th, 2018
Written by Jane Hames
We are pleased to announce the release of a new FREE online training course.
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.
Monday, November 13th, 2017
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…
Tuesday, April 4th, 2017
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:
Tuesday, February 28th, 2017
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…
Thursday, January 5th, 2017
Written by Jane Hames
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!…
Tuesday, December 13th, 2016
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…
Wednesday, November 9th, 2016
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:
Monday, October 17th, 2016
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:
Read more on Show PivotTables over separate sheets using Report Filter Pages…
