Excel Links for you – Busy busy edition
As the launch date for our 2nd batch of Power Pivot class nears, my plate looks fuller than ever. Fine tuning the course details, preparing our online classroom for new batch of students and coordinating with Rob for video recording etc.
But I wanted to take a few mins today and share with you some really useful Excel tricks, ideas and examples from web. I found these really useful and inspiring. I am sure you will learn from these links as much as I learned.
Excel Links for you:
Mike at Bacon Bits shows us how you can enhance dashboards with drawing shapes, shadows and layering. Very clever and cool stuff. I am going to blatantly copy Mike’s ideas for my future work 🙂
My good friend and Excel wizard Robert shows us how to create an interactive, fun and totally awesome dashboard in Excel to visualize Bruce Springsteen discography. What can I say. It is always a joy to watch Robert’s magic with Excel. Check it out.
Often when using drop down selection in Excel, you may want to show multiple columns so that your users know what they are picking. Have you ever wondered how to do it? Debra shows us how.
Official Excel blog teaches us how to use Excel 2013’s new web functions to bring, analyze and plot multiple pieces of web data in your Excel workbooks. Very cool workbook.
NY Times is one my inspirations when it comes to picking up new ideas for charts, dashboards & interactive displays. In this interactive chart, they tell the story of kids growing up in various parts of USA and how they end up (financially). For example, you can ask how kids in Cleveland with average parent income of $40k (in 1990s) are doing now? And you can find the answer easily. Very creative and cool visualization.
So that is all for now. See you again on Thursday.
Leave a Reply
|Details about upcoming Power Pivot course (and a bonus tip on dashboards)||Power Pivot online classes – now open for you|