Excel Issues Day 4 – How to enter formula correctly

Have you ever seen a document that is meant to be the final version but still has a draft watermark, or you can still see the track changes?  Maybe you have received a Powerpoint file from an organisation that still has the Speaker’s notes attached or comments included.  This can look unprofessional and have disastrous…

This little box has got a lot to answer for! Once again I got caught out! I opened a file in Word, started working on it and the Autosave saved the new version. Goodbye original file!!! I should know better. I need to change my working practices. When I open a file, I need to…

Here are a few tips that may help: Upgrade to Windows 10 especially if you are still using XP. Ensure you have an up to date anti-malware programme installed.  Programmes such s F-Secure will work in the background to prevent attacks such as this. Back-up your files to an external hard drive. Ensure that this…

Now I have been a bit late getting to the party on this one! But having used it a couple of times, I have begun to see its potential. Imagine you have two text strings in Columns A and B, and want to join them together in Column C. In older versions of Excel, you…