Web Analytics India

- Contributed by Kamesh M
We all know that using a Bubble Graph one can show three different dimensions of data i.e, X-axis, Y-axis and the Size of the Bubble to represent an additional dimension of information for the given time period. With a small set of data this may not prove beneficial but is [...]

- Contributed by Gunjan Aggarwal
We all like conditional formatting for the fact that data can be better projected that way. It makes data easy to read and conclude. It can be used in creating the Interactive dashboard, Routine reports, Adhoc reports and many more places where the Graphs play’s a vital role.
Imagine how conditional formatting [...]

- Contributed by Deep Moni Hazarika
Counting the length of a string or characters is easily done in excel. Just the LEN() function and simple. But the one day I was asked if there was any way to count a particular word in a cell which had a long sentence. That sounded tricky but needed some [...]

-contributed by Deep Moni Hazarika
Around the middle of February 2006, Microsoft’s new office suite was getting the focus after years of rumor and speculation. MS Excel RTM (Released to Manufacturing) was finally announced mid-November, but it was only in early 2007 that the product was finally available for purchase for the public. Here is a [...]

- contributed by Deep Moni Hazarika
What’s wrong with the calculations below? Hint: Related to Excel 2007

This is one of the problem numbers (there are many!) for Excel 2007. If the problem is still not decipherable, here’s the answer. These are the multiplication of two numbers A and B which gives the wrong result in Excel. [...]

- contributed by Deep Moni Hazarika
Most of us had well adapted ourselves to the excel 2003 interface and were able to find the required menu options and controls when needed. And when most of us got pretty comfortable with Excel 2003, Microsoft introduced us to the newer baby of spreadsheets - Excel 2007. Fantastic. Learning [...]

- contributed by Deep Moni Hazarika
A colleague once pinged me “How do I copy a value written in a cell in all the cell below it?” Well, almost anyone familiar with basic excel usage might have figured that out. Anyhow, I wrote back in the chat window explaining how to do it. Didn’t work! I [...]