Top 5 Excel Data Tips

Top 5 Excel Data Tips

One of the key things that Excel is used for is storing data but there are some pitfalls to avoid.  Here are my top 5 tips when working with data. 1. Arrange data in a table format  If you are using Excel to store information then it’s a really good idea to always set...
Top 5 ways to move data in Excel

Top 5 ways to move data in Excel

Who would have thought that there were so many ways to do the same thing!!  The last thing you want to do if you have put things in the wrong place is a full retype.  So take your pick from these options to move data from one place to another efficiently.  Cut and...
Consolidate data in Excel

Consolidate data in Excel

Are you trying to consolidate data or summarise data in Microsoft Excel? You try a calculation but the order of your data is all over the shot and autofilling it just isn’t going to work. This is going to be a long and arduous task – or is it!!  Although I always...

MEMBERSHIPS

FOLLOW LARA