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…