Tag: Excel

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, … Continue reading Dynamic Pareto Chart in Excel – The 80/20 Phenomenon

Advertisements

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 … Continue reading Extract Usernames from Email Ids in Excel [2 Methods]

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 … Continue reading How to Create a Thermometer Chart in Excel

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..) … Continue reading Increase Excel Tab Numbering as You Create a Copy

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 … Continue reading How to do Multiple Level Data Sorting in Excel (2 Methods)

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: … Continue reading Send Email From Excel Using 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) … Continue reading Excel IS Function (Example)

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 … Continue reading Figure out slot from given time [quick tip]

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 … Continue reading Earth Venus cosmic dance – Animated chart in Excel

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 … Continue reading Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition