Excel links – What is your next Excel book edition?
Outside of a dog, a book is a man’s best friend. Inside of a dog it’s too dark to read.
We don’t have a dog (yet), but we have a lot of books. Anytime I am in a bookshop, I feel like a mosquito in fat-camp. So you can imagine me smacking my lips when I saw your suggestions for favorite Excel books recently. There were more than 50 different books recommended by our readers. Of course I cannot buy all the 50 in one go. That would make Jo (my wife) angry. So I bought one that most of you recommended.
It is a book about array formulas, advanced formulas and data analysis techniques. I am eagerly waiting for the delivery to devour it. Once I am done with it, I will post a review here.
What about you? What Excel book are you reading now? Please share in comments.
Excel Links for you
Moving on, it has been a while since I shared some Excel links. So here we go.
Ever wondered why you cannot divide numbers with zero. Mike at Data Pig technologies explains the mysteries of number crunching. Interesting read.
Wizard interfaces are very useful when you want to capture data or depict a process. Jordan at Option Explicit VBA shows us how to build a simple wizard using Excel.
We all know that using data validation, you can restrict the list of items allowed in a cell. But what if you want to give user a choice to add items to the list? Debra shows us a smart piece of VBA code that does this. Check it out.
Debraj at our forum built this cool weight scale chart using Excel. Very smart, funny and interesting to learn from.
You know that when you select a range of numbers, you can look at status bar to get quick statistics of those numbers – like sum, average, max and min. But what if you want to know the difference of selected numbers (whether 2 numbers or 2 sets of numbers)? Dick at DDoE shows us how to use VBA to enhance the behavior of Excel status bar to do this. Very creative!
That is all for now
Go ahead and enjoy the Excel links. And remember to tell us what Excel book you are reading now in the comments.
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Chandoo.org Podcast: Launching on March 6th||CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift|