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.
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.
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.
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.
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:
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:
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 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:
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: