Have you ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into? This is what I mean by the term duplicated Conditional Formatting Rules. I hope the following post helps you. Basically this situation arises as you go about day to day coping and pasting into a …
There is a dangerous little trap in using Find & Select dialog on the Home Tab and then using Replace All. I use this a lot and most of the time need to change lots of cells so in the habit of using Replace All. I am often changing the sheet name or a range …
Well it’s the Boxing Day holiday here in Aussieland 2017 and one of our traditions is watching the Test Cricket in Melbourne that always starts on Boxing Day. Fantastic stuff. But also, this is the time of the year to think of New Year’s Resolutions. If you are not using Tables in Excel, this would …
Do you find that some dialogs like the Name Manager and the Data Validation dialog mess you around when you edit or enter formulas? I call this the Excel Dialog Box Muddle! For years and years now these two dialogs change to Point mode by default the moment you start editing in the ‘Refers to’ …
Transposing Data with INDEX / MATCH combo what’s this all about? OK imagine this – you have done the right thing as a budding data analyst and created your sales data down the page so that you can take advantage of Pivot Tables which likes dimensions of data going across in columns namely Date and …
This is a general post for anyone out there not using Pivot Tables. Do yourself a favor, you need to! I am also going to do a similar post shortly for anyone not using Tables as well. I think both tools are just so very powerful and if you want to be an advanced user …