Blog - IT
A conversation we keep having… (and why it matters)
There’s a conversation that keeps coming up in our training sessions, different delegates, different industries, same theme. We’re talking about performance, or priorities, or planning… and someone says: “I know what I should be doing… I just don’t really track it.” Someone...
Your Co-pilot: Utilising AI for your everyday
There’s a growing sense that AI is everywhere at the moment, yet most people are only scratching the surface of what it can actually do. The issue isn’t access to the technology, nor is it capability. The real problem is that we’re approaching AI as...
Excel: The Tool We Use Every Day (But Rarely Utilise!)
Coming from a banking background, I have used Excel my whole career. I wouldn’t describe myself as one of those who “loves a spreadsheet”, with the go to Secret Santa gift of choice by colleagues being a coffee mug with dubious Excel humour emblazoned on...
How to Round a Date to the Nearest Working Day in Excel
When calculating with dates in Excel, there is no guarantee that the result will be on a working day. However, using the WORKDAY function offers a solution to rounding up or down to the nearest working day, it even allows for public holidays if required....
Print Scaling & Print Titles in Excel
Excel is one of those products that back in the mid nineties was used a lot by accountants, however these days it’s used by just about everyone at every level of every business. Also, during the current time of enforced home working and travel restrictions...
Excel and Negative Times
Calculations that result in a negative time cause a problem in Excel, or at least they do with the default settings. This article explains the need for negative times and how to manage these in Excel. Short Answer If you already know how to work with time...
What’s the Excel 1900 or 1904 Date System?
An interesting question came into us the other following a course. It was regarding Excel and the 1904 Date System. One of the subjects we cover on our courses is the importance of entering dates in an acceptable form when adding them into a cell....
Access Training? – Not Quite!
August is relatively quiet in the Training world and with that comes lower numbers on courses and a different approach to training. This week I’ve had two courses both with only one person on (we really don’t cancel courses unless we have to) and in...
SharePoint – Version History
Sometimes it helps our understanding of how a product fits in with the way we work by learning how the product evolved. Rarely is evolution purely an accident, a product evolves in response to the way its used and if its not used it wont...
Creative Cloud Alternatives
Adobe’s Creative Cloud is probably the best productivity software for designers, the only downsides are cost and for many, complexity. Replicating the whole of Creative Cloud with other products would be difficult and the results harder to work with, however, it is the core desktop applications...
