1

First of all, if you don’t recognise the allusion in the title – here’s the Michael Bublé version….

MrExcel (the leading Excel publisher) and I  have collaborated to create some Excel tipsheets. These would be useful for trainers, or for reference guides for your office.

Now, MrExcel and I will not be running away to the Cayman Islands on these tip sheets.  Separately or together. :-)

They are great value – only $1 each (yikes!), full of great tips on cleaning up data – and what Excel person hasn’t had to clean up data at some stage…

Here’s the one on data cleaning

Here’s another one on conditional formatting. Bill Jelen (MrExcel) and I collaborated on this and there are some great tips on conditional formatting in it.  I often think Conditional Formatting is the secret sauce of the new Excel – it’s such a great way to get a quick visual of your data. And for $1 – well you can’t go wrong – it’s not even the cost of a cup of coffee!

And data validation – the data gatekeeper.  These tips can save you tearing your hair out about having the same data entered 5 or more different ways!

Please forward and feel free to share…

 

 

Trackbacks/Pingbacks

  1. Excel Roundup 20150615 « Contextures Blog - June 15, 2015

    […] Walsh and Bill Jelen (Mr. Excel) have published 3 tip sheets ($1 each), to help you with data cleaning, conditional formatting and data validation. Keep them […]

Leave a Reply