Tag: Good Excel habit

If you have ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into, I hope the following post helps you.  Basically this situation arises as you go about day to day coping …

Fix duplicated Conditional Formatting Rules Read More »

Tagged with: , , , ,

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 …

Take Care with Replace All Read More »

Tagged with: , ,

Well it’s the Boxing Day holiday here in Aussieland 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 …

Make Using Tables your New Year’s Resolution Read More »

Tagged with: , , , , , ,

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 …

Excel Dialog Box Muddle Read More »

Tagged with: ,

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 …

Transposing Data with INDEX Read More »

Tagged with: , , , , , ,

This is general post for anyone out there not using Pivot Tables.  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 …

Learning to use Pivot Tables Read More »

Tagged with: , , , ,