Calculate sum of top 10 values [formulas + homework]
Analyzing top n (or bottom m) items is an important part of any data analysis exercise. In this article, we are going to learn Excel formulas to help you with that.
Let’s say you are the lead analyst at a large retail chain in Ohio, USA. You are looking at the latest sales data for all the 300 stores. You want to calculate the total sales of top 10 stores. Read on to learn the techniques.
How to highlight overdue items [video]
We, adults can’t escape three things:
- Deadlines
- Demanding bosses (replace with customers or nagging spouses or naughty kids)
- Taxes
While I can’t help you with demanding bosses or taxes, when it comes to deadlines, I have the right tool for you.
A tracker that highlights all overdue items so that you know where to focus your attention.
Let’s learn how to use awesome powers of Excel to find-out which items are due. You can apply these concepts to nail down over due invoices, pending project tasks or scheduling workforce.
How to create dynamic sparklines for latest 30 days [video]
Sparklines are fun and very insightful. They are easy to create, easy to maintain and fit into any dashboard.
But there is one tiny problem with them. Usually we have a lot of data, but we don’t to visualize all of it. We just want to visualize latest 30 days trend or last 12 months trend or QTD or something similar. What then?
In this video, learn a powerful and very simple way to create dynamic sparklines using Excel.
Clean data quickly with Flash Fill
Excel has many powerful & time-saving features. Even by Excel’s standard, Flash Fill is magical. Introduced in 2013, Flash Fill is a rule engine to Excel’s fill logic. Every time you type something in a cell, Excel will try to guess the pattern and offers to fill up the rest of cells for you. That is some serious time saving magic.
Let’s understand what Flash Fill is and few sample use cases.
Announcing Awesome August
Hi folks,
I am excited to announce Awesome August. It is a month-long effort to make you awesome in various aspects of Excel.
Awesome August… What is it?
For each and every day of August 2015, I am going to publish a new piece of content – an Excel tip, a formula technique, a charting solution or a productivity booster. 31 days – 31 pieces of awesome content.
Sounds Yummy? Participate in Awesome August:
There are 4 ways to participate in Awesome August
- Sign-up to Chandoo.org newsletter. Get weekly emails with links to all the Awesome August content.
- Comment & Win: Comment on any of the Awesome August posts. 31 random commenters will each get $31 Amazon gift-card.
- Follow Awesome August in social media – on twitter, facebook, youtube and iTunes
- Ask your friends & colleagues to participate. Send them to Chandoo.org/AwesomeAugust