Excel Links of the Week [Nov 3]
This is totally cool. ACDC released an ASCII version of their “rock n roll train” video through excel spreadsheet. Why? So that you can download it at your office and watch it while your boss thinks you are working. 😀 I think this is cool because it pushes the limits of what is possible with Excel. Go watch it (direct download link), and feel curious to check the VBA code behind the buttons. Learn something cool and rock on!
Many times we fall in to the trap of tools that we forget what makes us unique – passion. See these amazing whiteboard presentations made by Steve Jobs in 1991. No slides or fancy charts and yet see how through passion, he tells a great story (well, sales pitch).
Spell check is one of the most useful features in any office productivity software. It ranks high up there with other FYCLW (features you cant live without) like undo, copy-paste, ctrl+t (for new tab), show desktop (windows key+d). Newton Excel Bach has developed a simple UDF to find if cell has valid spelling (by using application.checkSpelling () function) and strangely the UDF wont work, while a macro version of it works like a charm. See the user discussion that followed the post. If you ever need to automate spell check through formulas (don’t ask me why) this might be a good resource to check.
Duplicates are such a problem problem with the data. Imagine having excel (or other tools where you can create, enter tabular data) being able to highlight the cell you are entering the moment you enter / paste a duplicate value in a totally non-intrusive way. But until then we need to handle the dupes using formulas (ahem!).
Got a link?
Share it in the comments 🙂
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Best of Pointy Haired Dilbert – Oct 2008||Minor Changes to PHD’s Look and Feel »|