Here is a simple way to enhance your Excel charts – use shapes & pictures in your charts.
We will learn how to create something like above.
Looks interesting? Read on…Continue »
By now, we know how to remove duplicates from data. You can use the Remove Duplicates button to do that.
But do you know that we can use remove duplicates button to get rid off duplicate combinations too?
Remove duplicate combinations – Tutorial
To remove duplicate combinations in your data, just follow below 4 steps:
- Select your data
- Click on Data > Remove Duplicates button
- Make sure all columns are checked
- Click ok and done!
See this demo:Continue »
What is in this session?
In this podcast,
- Quick announcement about Awesome August
- 6 charts you should avoid
- 3D charts
- Pie / donut charts with too many slices
- Too much data
- Over formatting
- Complex charts
- Charts that don’t tell a story
A significant portion of our time in Excel is spent navigating between various ribbon tabs and clicking buttons. Wouldn’t it be better if you can combine all the frequently used features in to one ribbon? Something like above:
Read on to learn how to create, edit and share custom ribbons in Excel.Continue »
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.Continue »
We, adults can’t escape three things:
- Demanding bosses (replace with customers or nagging spouses or naughty kids)
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.Continue »
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.Continue »