Blog - Charlie

Round to the Nearest Working Day

Fri 14 Jul 2023

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

Find out more

Print Scaling & Print Titles in Excel

Mon 6 Apr 2020

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

Find out more

Excel and Negative Times

Tue 21 Feb 2017

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

Find out more

Access Training? – Not Quite!

Wed 17 Aug 2016

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

Find out more

SharePoint – Version History

Fri 11 Dec 2015

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

Find out more

Humans vs Animals

Wed 16 Sep 2015

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

Find out more

Creative Cloud Alternatives

Wed 22 Jul 2015

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

Find out more

SharePoint – Do You Need It

Sun 12 Jul 2015

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

Find out more

Should I Use Excel or Access

Wed 12 Feb 2014

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

Find out more

Get in touch

Telephone
+441603 677107

Email
enquiries@jarroldtraining.co.uk