Category: Excel

Learn the Technical Side of Analytics from These Free Resources

Technical skills in analytics are the magic behind the curtain. They are what produces the results. Even if you are mediocre at most of them, you’re better off than most marketers. In order of importance, here are the skills you need to learn and the best (free) resources I have found to teach them to …

One Must-Know Excel Function to Save Hours of Time

The Vlookup Have you ever had to compare two lists of email addresses? How about flag a certain set of products out of a large transaction list? Or maybe mash up a few lists of ugly-looking customer IDs? This function will allow you to do all of it! Lets take the example of two lists …

How to Quickly Uncover Leads in Google Analytics Data

If you are running Google Analytics, then inside your data you already have a list of leads visiting your site. Who’s going to complain about getting a quick list of sales leads interested in what you have to offer? The following video describes how to get these leads; we’ve also provided an excel spreadsheet download …

Using The “Linest” Function in Excel For Faster Twitter Potential Reach Analysis

Last time we looked at a way to put together an analysis for the potential reach of a tweet; today we’ll look at a method of using the ‘linest’ function in excel to make the analysis faster. When you go to Twellow to look up the users that would be interested in your business, it …

A Complex Pricing Model Made Easy by Excel (part 2)

We are now ready, having performed a historical analysis in part 1 of this post, to create a useful system for pricing. Depending on how comfortable you are with statistics and mathematical operations with standard deviations, you may or may not understand why the excel formulas are set up the way that they are. A …