Dynamic Pareto Chart in Excel – The 80/20 Phenomenon

Pareto principle (also known as the 80/20 rule) is a well-known concept in project management. According to it, ~80% of the problems can be attributed to about ~20% of the issues (or ~80% of your results could be a direct outcome of ~20% of your efforts, and so on..). The 80/20 percentage value may vary, …

Extract Usernames from Email Ids in Excel [2 Methods]

A colleague asked me if she could quickly extract usernames from Email Ids. She had more than 1000 records and less than 2 minutes to do it. In this tutorial, I will show you 2 methods to do this. And none of it would take more than a minute. Method 1 – Using Text to …

How to Create a Thermometer Chart in Excel

Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value. A good example could be while analyzing sales performance of regions or sales rep. Here is a quick way to create Thermometer Chart in Excel Have the data in adjacent cells (Actual Value and Target …

Increase Excel Tab Numbering as You Create a Copy

This is one awesome Excel Tab Numbering tip and the credit goes to Scott of Excel Zoom. He has some amazing articles on his website, and I am going to copy this tip shamelessly here [with his permission of course] If you have a workbook where tab’s names are numbers (for example 1,2,3.. or 2012,2013,2014..) …

How to do Multiple Level Data Sorting in Excel (2 Methods)

Sorting is a basic need when we are working with data. And if you have large data sets, you may need to do a multiple level data sorting in Excel, which means that you first want you data to be sorted by one column and then by another. Something as shown below: There are 2 …

Send Email From Excel Using Hyperlink Function

Yes, its True! You can send email from Excel by using the HYPERLINK function. In this blog post, I will show you various ways to use HYPERLINK function to send email from Excel. There is also a bonus Email Generator Excel Template available for download at the end of this post. Let me first explain the Hyperlink function: …

Excel IS Function (Example)

When to use Excel IS Function IS function can be used when you want check a specific value and get either TRUE or FALSE based on the outcome. What it Returns It returns TRUE if the condition is met and FALSE if it is not met. Syntax =ISBLANK(value) =ISERR(value) =ISERROR(value) =ISLOGICAL(value) =ISNA(value) =ISNONTEXT(value) =ISNUMBER(value) =ISREF(value) =ISTEXT(value) …

Figure out slot from given time [quick tip]

Here is an interesting scenario. Let’s say you are looking at a time, like 9:42 AM and want to know which 15 minute slot it fits into. The answer is 9:30 – 9:45. But how would you get this answer thru Excel formulas? Excel formula to find slot from time: Assuming A1 contains the input …

Earth Venus cosmic dance – Animated chart in Excel

Recently I saw an interesting Earth Venus cosmic dance video on Facebook. See the original video below or here . Although this is not entirely accurate from physics astronomy perspectives, the dance is a stunning example of patterns that are generated by simple things. I wanted to recreate this cosmic dance in Excel. How else …

Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition

Last week we saw a number of Excel Tips, Tricks, Cheats Hacks supplied by Microsoft Excel MVP’s. This week I have invited the Chandoo.org, Excel ninjas to contribute their Excel Tips, Tricks, Cheats Hacks. Chandoo has Excel ninjas? Absolutely! Do they have swords? No (sigh) But you can read all about them here: Chandoo.org Excel …