This blog is NOFOLLOW Free!

Using Excel to analyze Analytics data

Many of us rely on visualizations to understand and analyze data.  While there are many tools that assist in analyzing data, Google analytics is one of the better tools used to measure website perfomance and matrices.

Google analytics can be a bit overwhelming and some portions are downright alien to many users.

A client recently ask how they could use excel to anaylze some Google analytics data.

The Problem:

Download monthly Google analytics data, import the data into Excel and display a user friendly interface for a customer in less then 8 hours (due to budget and time restraints).

This is a preview of Using Excel to analyze Analytics data. Read the full post (683 words, 2 images, estimated 2:44 mins reading time)

How to use Autofit (columns and rows) in Excel

Periodically we get questions from customers and visitors regarding the use of various applications.

Excel tips and tricks

How to use Autofit to adjust Column widths…

There are several ways to use ‘Autofit’:

I am going to assume VB Script or programming will not be used, so the following methods do not utilize programming techniques.

To Autofit 1 column first method:

Once you have written the text in the cell of a column that you want to Autofit:

  1. Move your mouse to the top of the spreadsheet where the column headings are (A through ZZ etc.).
This is a preview of How to use Autofit (columns and rows) in Excel. Read the full post (397 words, 1 image, estimated 1:35 mins reading time)