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....
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...
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...
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...
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...
Humans share many traits with animals, but there is one behavioural aspect where we undoubtedly have the edge and that is our ability to adapt. Our friends at a well-known zoological society in the East of England are a particularly good source of examples that...
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...
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...
When customers come to us for Excel training we ask about what they would like to achieve from the training and if they have any specific problems they need to solve. Also we encourage asking questions during the training to help keep the course as relevant as...