In the 44th session of Chandoo.org podcast, let’s talk about failures.
In this podcast,
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 reading
Meetings can be, at best, a necessary evil. At worst they can be a soul-sucking drain of your creativity and time.
One of the best ways to protect your productivity from this insidious sapper is to schedule a No Meeting Day.
The post No Meeting Days: P… Continue reading
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 reading
In 2014 I decided I wanted to release monthly productivity forms with a seasonal theme. Fun tools make it more likely I will use them, and honestly, I get bored with the plain old print and line forms. In 2015 I decided to continue this tradition.
So t… Continue reading
Time for a quick weekend poll. What is your favorite tool for data analysis?
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 reading
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,
As you can see, this is an advanced Excel book with lots of examples, case studies and practical tips. Continue reading
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.
I was setting out for my daily 3 mile walk, and thumbing through the various podcasts I had waiting for me. I scrolled past the ones about blogging, and noticed the list was getting very large. But at the same time, part of me resisted because I didn’t… Continue reading
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 reading
