After a long time, I am writing one more Excel links post. First let me share a quick personal update.
I am invited to Lome, Togo to spend a day at Ecobank – CFO conference in 3rd week of September. I will be conducting a one day masterclass on Advanced Excel & Dashboard Reporting. I am excited about this trip as I have never been to any African country. I will post some pics and tell you how it went once I am done with the conference.
Moving on to Excel Links for today,
Calendar Chart using PowerPivot, DAX and pixie dust
Rob at PowerPivotPro created this awesome calendar chart using powerpivot, DAX formulas, conditional formatting and probably lots of coffee. It is a clever idea. I will be shamelessly adopting it for some of my reports 😛
Multiple Criteria Lookups – INDEX or SUMPRODUCT?
Often we need to lookup a value that meets multiple criteria. Back when we did that lookup week, we had a round up of various techniques for doing mulch-criteria lookups (index+match, sumproduct, sumifs etc.). Doug at YourSumBuddy discusses more about 2 important approaches – INDEX+MATCH vs. INDEX+SUMPRODUCT
Debra shares a simple yet wonderful recipe for cooking panel charts. Go check it out and impress someone today.
Robert shares an excel check list template that use a bit of VBA magic to automatically check / uncheck items upon clicking the cell. Very nifty.
Using Arrows in percentage format
Mike at Bacon bits shows us how to get up and down arrow symbols in cells that have percentage change, using custom cell formatting codes. The best thing is the same formatting is applied to status bar as well, pretty cool.
That is all for now.
Got any Excel links that you want to share with us?
I am always looking for new websites and resources to learn Excel & Visualization. So if you came across something that is awesome and want to share it with us, send it to me at chandoo.d @ gmail.com or drop a comment here. Thanks in advance.
12 Responses
First of all congrats chandoo.. i m sure, u will make them awesome in excel in your trip..
Good collection of links.
Regards,
Saran
http://www.lostinexcel.blogspot.com
That last link of using the custom cell format is really brilliant. You have to love simple solutions like that – really makes the values pop!
Best of luck!
Chandoo, excuse me for my bar englisch, i am italian.
You are great for all your work. Thanks for all your suggestions
Best regards
Lorenzo
I like the last link so much, it is simple but more useful in practice. Thank you.
Thanks for the mention, Chandoo! Have a good trip.
You are welcome Doug. I am enjoying your articles at YourSumBuddy. Keep up the good work.
This Scoop It! page started by Kris, moderator of the Excel Hero LinkedIn group, may be of interest to you and your readers: http://www.scoop.it/t/excel-hero-linkedin-group/
Thanks for the scoop.it link. I loved the collection Daniel has been maintaining.
Also, thanks for the chess game links. They are lovely too 🙂
All the information in the links are awesome, specially the panel chart and percentage format.
I used the arrows in %age but not in custom format…good tips.
Chandoo, I share with you and your blog visitors three links to play and view chess games without the risk of enabled macros.
http://pedrowave.blogspot.com.es/2012/02/data-conversion-1-chess-viewer-in-excel.html
http://pedrowave.blogspot.com.es/2012/03/data-conversion-2-chess-viewer.html
http://pedrowave.blogspot.com.es/2012/08/data-converter-3-chess-game-with.html
I’m improving this chess game only with iterative formulas.
Have a good trip.
Chandoo,
many thanks for the link. Much appreciated. I am happy you liked the check list template.