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
How to create a Panel Chart
Debra shares a simple yet wonderful recipe for cooking panel charts. Go check it out and impress someone today.
Checklist in Excel that works
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.
0 comments:
Post a Comment