by admin | Mar 8, 2021 | Excel Path - Step by Step
Ah, yes that joyful scenario. You have a list – a great big juicy list and you want to scroll down that list but oh no my headings have disappeared…WHAT DO I DOOOOO? Well I *have* heard of people who have sellotaped the headings onto their...
by admin | Feb 22, 2021 | Excel Path - Step by Step
The secret – usually forgotten sauce to creating charts in Excel is to make sure your data is properly organised – no blank rows, no blank columns and you need to go all – what I call – Judge Judy on it – “The data, all the data and...
by admin | Jan 25, 2021 | Excel Path - Step by Step
In this video I show you how you would use plus – + to add up numbers and dates in Excel. Here is a link to the file if you want to practise Choose where you want the answer to goType in =Click on the first cell you want to useType in +Click on the second cell....
by admin | Jan 18, 2021 | Excel Path - Step by Step
One of my key ideas for this year is to create a section in my newsletter specifically for Excel newbies – so that people who are new to Excel can use it as a way to get stuck in and start understanding the terminology. If that is you, I would suggest starting...
by admin | Dec 7, 2020 | Excel Path - Step by Step
Filter() is one of the new dynamic array functions in Excel. So what does that mean? If you have used Excel you will know that generally it has made like a single celled organism – create your formula in ONE cell and then copy it down or across. The new range of...
by admin | Jul 8, 2020 | Excel Path - Step by Step
Many years ago when my son was small and loved a certain purple dinosaur, there was also a smaller dinosaur called BabyBop who had a comfort blankie that he carried around at all times. You can remind yourself about it here. Excel has one of those – it’s...
