Tag: MicrosoftOffice

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

Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition

This week I have asked a number of owners of notable Non-MVP Excel websites for their input to their favorite Excel Tips, Tricks, Cheats Hacks. Notable means that the web site has attracted my attention and made it into my list of Excel Shortcuts in my Firefox browser. Lets dive in: 001. Percent of True … Continue reading Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition

Extract the 10 digit number [formula homework]

Okay, time for another challenge. Imagine you have some data like this. Each cell contains 3 numbers separated by line break  – CHAR(10) and you need to extract the number that is 10 digits long. Go ahead and solve this riddle. Click here to download sample data workbook . Post your answers in comments. Although … Continue reading Extract the 10 digit number [formula homework]