Web Analytics India

- 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 Gunjan Aggarwal
In earlier blogs, we learn how to create interactive charts with the help of checkboxes. Those who have missed that blog post can read the article on using check boxes for a neat treat .
It’s very much necessary for a web analyst [...]

 - Contributed by Gunjan Aggarwal

A layman who would look at the above graph, at his first glance would tell that the Paid Search had not performed well in the initial months, or HE/SHE would think that there must be some changes happened in the Paid Search Section in the month of June which in turn [...]

- 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
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 [...]