Files Autosaving in Office 365

Many people complain that they can’t use Pivot Tables and struggle to make them work. One of the big issues is the raw data they are using. Have a look at some of the common problems, and see if you can spot them in your data! Blank Rows or columns – a blank row or column…

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…

This morning I was doing some work, and needed to open one of my Microsoft Excel files. I haven’t used it for a while, and opened it through a Folder on the Desktop. However, it wouldn’t let me open the file, saying I need to download an App. So I did some investigations, and it…

This was a question posed on Linked in the other day.  However, maybe the question should be how long do you spend working effectively in Excel each day?  Could your time be used more efficiently by using the correct functions and shortcuts.  Are you spending ages copying and pasting or re-entering data wondering if there is a…