02 – Excel formulas – adding up numbers and dates
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 go Type in = Click on the first cell you want to use Type in […]
01 – Starting Excel from the beginning
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 opening a […]
Faster Filtering with Filter()
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 dynamic array formulas […]
14 – Meet IFError() – the blankie function of Excel
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 called the IFERROR() function and you can […]
How to filter in Excel
This is my first blog post of 2017. I have to say I do love the energy of a new year. My favourite time of the year are those days between the “two Christmases” i.e. 25th December and 6th January. There is no pressure. Just movies to be watched, sweets to be eaten, walks to […]
13- Do you have to set up a spreadsheet from scratch? | Excel Novice Special
One of the topics I cover in my new book Your Excel Survival Kit: A guide to surviving and thriving in an Excel World (ooh, still get a thrill when I say that!) which will be out in June 2016 is how to set up your data to make it easy to work with. If you set […]
15 |Printing made easy, Excel Adept | Quickly transpose
As always, I hope you are well. As per my earlier blog post I am going to be offering two segments here: Excel Novice 5 min tip Learn how to print your spreadsheet so that you don’t spend time cutting, pasting, gluing and stapling (awww, the horror!) . This handout gives you the basics:Printing_summary_tipsheet_02 But […]
04 – Addition, autosum, finding a quick sum using status bar
I was looking through the blog posts I had and I noticed that I had nothing in my beginners’ section for an Excel fundamental…addition/autosum and checking your sum on the status bar (a personal favourite of mine I must admit). You can view the video here. https://s3-eu-west-1.amazonaws.com/the-excel-expert/autosum_plus_status_bar.mp4 Adding up 3 or less numbers Have your […]
Doing the “total spend this year”, “total spend this month” shuffle using SumIFS
Recently I went in to do some training with a new manager who had been tearing his hair out with his Excel sheet. The spreadsheet had already been set up for him and the previous incumbent had done some interesting array formula variations using If and Sum – and it worked fine actually. The only […]
01 – Powerpivot | Introduction to Powerpivot – what is it and why would you use it?
Powerpivot is a new free add-in that first appeared in Excel 2010. As a trainer I’m incredibly excited about the possibilities this offers Excel users to streamline their work and to do a lot more with their data. Imagine just updating your data connection and your pivot tables automatically updating to show current data. Imagine […]