Blog - IT
Round to the Nearest Working Day
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...
SharePoint – Do You Need It
To know whether you need SharePoint, first you need to know what it is and does. When the topic comes up on one of our courses there follows a conversation along these lines… What is SharePoint SharePoint is Microsoft’s intranet solution for businesses of all...