by laramellortraining | Sep 9, 2021 | Excel Hints and 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...
by laramellortraining | Jul 1, 2021 | Excel Hints and Tips
Are you needing to compare different sets of data? Do you end up copying the data several times to do this? This is OK but what if that data then changes? You now have multiple versions of the same data that you need to update. But why not use scenarios instead? ...
by laramellortraining | Jun 10, 2021 | Excel Hints and Tips
A question I often get asked in courses is how to compare data that’s on different Excel sheets easily without having to constantly flick backwards and forwards or copy one of the sheets into a new file first. Neither of these solutions are ideal and copying the sheet...
by laramellortraining | May 13, 2021 | Excel Hints and Tips
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...
by laramellortraining | Apr 29, 2021 | Excel Hints and Tips
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...
by laramellortraining | Apr 1, 2021 | Excel Hints and Tips
There are many times and many reasons your data will not all be stored on the same sheet. But what if you need to get information from one sheet to another or perform a calculation. Microsoft Excel is designed to handle this with ease! Calculations in general ...
