by admin | Jan 11, 2017 | Excel Path - Step by Step
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...
by admin | Nov 4, 2016 | Excel Path - Step by Step
Debra Dalgleish (http://www.contextures.com) is one of my Excel heroines and the pivot table guru. She is someone whose work I regularly reference in class. I recently asked her to help me answer a question that regularly comes up in class when people ask about pivot...
by admin | May 9, 2016 | Excel Path - Step by Step
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...
by admin | Feb 9, 2016 | Excel Path - Step by Step
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!) ....
by admin | Apr 13, 2015 | Excel Path - Step by Step
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....
by admin | Sep 23, 2014 | Excel Path - Step by Step
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...
