This blog is NOFOLLOW Free!

Using Excel to analyze Analytics data

Posted on May 11, 2009
Filed Under MS Excel tips and tricks | Leave a Comment

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 (685 words, 2 images, estimated 2:44 mins reading time)

How to use Autofit (columns and rows) in Excel

Posted on May 8, 2009
Filed Under MS Excel tips and tricks | Leave a Comment

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 (399 words, 1 image, estimated 1:36 mins reading time)

Help for Facebook users - Group messages

Posted on April 2, 2009
Filed Under Facebook tips | 2 Comments

As the popularity of Facebook grows and the increased number of applications are utilized by more and more members, I noticed recently a significant lack of information on how to do a few things.

One issue that I see posted is how to send messages to a group of people at once.  I’ve seen this mostly in some of the games that are being offered by Facebook third party vendors.

So, here is how you can organize your friends into lists and then send emails/messages to groups of friends:

This is a preview of Help for Facebook users - Group messages. Read the full post (224 words, estimated 54 secs reading time)

MS Publisher tips and shortcuts - by Cochran Consulting

Posted on January 5, 2009
Filed Under Tech Tips | Leave a Comment

Let’s continue with a few more keyboard short cuts.

This time we’ll add some MS Publisher keyboard short cuts.  Remember when executing short cuts, to press and hold CTRL, ALT and SHIFT keys before pressing a printable character key.

This is a preview of MS Publisher tips and shortcuts - by Cochran Consulting. Read the full post (194 words, estimated 47 secs reading time)

Website tips - Bookmarking

Posted on November 17, 2008
Filed Under Website Tips | 2 Comments

Bookmarking is a very important aspect of website availability to your visitors.

Giving your visitors a convenient method of adding your site and being able to quickly return to it, will provide several benefits:

This is a preview of Website tips - Bookmarking. Read the full post (233 words, estimated 56 secs reading time)
keep looking »