How to count words in a cell using excel functions
I was doing some weird analysis on corporate mission statements and I had to count the number of words in each cell. That is when I realized there is no formula to calculate the number of words in a cell, I was too lazy to write an UDF for that, so I figured out a […]
Skip weekends while autofilling dates in excel
Often you may want to fill a column only with weekday dates instead of all dates. Here is a simple trick you can use instead of writing nifty if formulas or manually entering the weekday dates. When you auto fill dates by dragging mouse (or using menu > edit > fill > series > selecting […]
Hot Thermometer Charts in Excel – here is a cool way to do them
Let us learn a simple charting hack to create a thermo-meter chart in excel. This type of charts can be effective in communicating one data point, they can make excellent presentation slide or dashboard widget. What more, they are as simple to do as adding whipped cream to your latte. So lets begin: 1. First […]
Get Stock Quotes in Excel
While trying to spell check one my sheets I have learned this cool trick to fetch real time stock quotes without any webqueries or vba or anything. First enter the stock code in a cell (this works for US stocks only), for eg. AAPL for Apple, MSFT for Microsoft etc. Then ALT+CLICK on that cell, […]
Quickly display unique items in an excel list using advanced filters
Imagine you have long list of data and you need to quickly identify which of the items are unique. You can use Advanced Filters to do this. Just select the list of items you want to filter, go to menu > Data > Filter > Advanced filter. You will see a dialog box like this: […]
Formatting numbers in excel – few tips
Reader Nikhil Shah asks in an email: Dear Chandoo, I have some Error In Excel sheet. Problem :- I have a locker number 01234 567890, in Excel it will be displayed as 01234 567890 with the space. However if it was entered as 01234567890, Excel will display it as 1234567890, without the leading zero. If […]
“I am feeling lucky” Firefox Search plug-in
While trying to understand how the Mozilla firefox search plug-ins work [ more ] I got curious and wrote a search plug-in that will take you to the first Google search result directly instead of displaying the results pages, ie mimicking the “I am feeling lucky” searches. Feel free to download and install it. 1. […]