In the 44th session of Chandoo.org podcast, let’s talk about failures.
What is in this session?
In this podcast,
- Book announcement about Dashboards for Excel
- Story of my first ever dashboard
- Important lessons – Requirement Analysis for dashboards
- Resources for creating awesome dashboards
We know that column charts are excellent for presenting information. But what if some of the columns are too tall and hijacking the rest. In a previous article, we discussed few of the approaches. Today let’s learn how to build a cropped chart (broken y-axis chart) using Excel, something like above.
Looks interesting? Read on.Continue »
We all know that VLOOKUP (and its cousins MATCH, HLOOKUP and LOOKUP) are great for finding information you want. But they are helpless when you want to do a case-sensitive lookup.
So how do we write case sensitive VLOOKUP formulas?
Simple. We can use EXACT formula.Continue »
Time for a quick weekend poll. What is your favorite tool for data analysis?
- Pivot Tables
- Or both
Post your choice in the comments. Also mention the number of years Excel experience you have.
For ex, my answer is: Both (10 years)Continue »
I have an exciting announcement to share with you. My first ever print book – Dashboards for Excel, co-authored with Jordan Goldmeier is releasing on 15th September.
Dashboards for Excel – what is it?
As the name suggests this book is a handy guide for anyone preparing dashboards, management reports and business intelligence workbooks using Excel. The key benefits are,
- Learn the visualization tools, charts, tables, and graphs important to management.
- Understand what management doesn’t want to see in a report
- Turn around dashboards faster and cheaper than ever before
- Understand the key role dashboards play in an organization
- Analyze real-world dashboards to apply important features to your own organization
- Utilize understated, but powerful, Excel formulas and VBA code
- Avoid common pitfalls in Excel development and dashboard creation
- Get started with the Excel data model, PowerPivot, and Power Query
As you can see, this is an advanced Excel book with lots of examples, case studies and practical tips.Continue »
Wow, what a month it has been. In August 2015, I announced Awesome August, an Excel festival. I published 31 articles, one for each day of August to make you awesome in your work. We had 3 podcasts, 11 videos, 17 articles and 238 comments in August. This content is consumed by more than 50,000 people from all over the world (3% of site traffic visited Awesome August pages). There were lots of emails, tweets and facebook posts telling me how you are enjoying Awesome August.
Thank you so much for taking time to learn from Chandoo.org and making Awesome August a success.
I made a short (5 mins) video to share the journey and to say thanks to you personally. Please watch it below.Continue »
Cascading drop downs enhance usability of your dashboards & interactive workbooks. A cascading drop-down is a 2 or more level selection mechanism. When you have 100s of selection choices, instead of creating one massive drop down or combo-box, you can set up multiple levels of drop downs, so that users can narrow down their selection. For example, users can select Country, State and then City using cascading drop downs.
There are many ways to setup cascading drop downs. You can use formulas coupled with either data validation or form controls. You can also use Slicers. In this video we will review these techniques.Continue »