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 ...
by laramellortraining | Mar 11, 2021 | Excel Hints and Tips
Which is better XLOOKUP or VLOOKUP? You may well have heard of the VLOOKUP function, you may even have heard of the HLOOKUP function but the new kid on the block is the XLOOKUP! What is an XLOOKUP? The XLOOKUP function is used to look up data in a table. It is...
by laramellortraining | Feb 18, 2021 | Excel Hints and Tips
The IFS function enables you to perform multiple outcomes based on multiple conditions. This significantly simplifies how to perform this sort of task. Until recently you would have needed to combine IF functions inside of IF functions which was referred to as nested...
