Search Results for: excel

Results 1-10 of 56

Video Walkthrough Of An Excel Dashboard

February 8, 2014

can use the Google Analytics API to pull together a reporting dashboard. A Tale Of Two Dashboards I demo two different dashboards, one built with Excellent Analytics, a free Excel add-in that pulls Google Analytics API data right into Excel, and the other with my favorite API tool, Analytics Canvas. ...

How To Save An Excel Formula Midstream

February 7, 2014

I'm going to start a series called Function Friday where I will share common Excel functions and formulas marketers should learn. I'll kick this series off with a tip that every marketer needs to know before entering the icy waters of function madness. Think of it as an appetizer to tide you over until y...

How To See If You’re Trashing Your Analytics With Campaign Tracking

February 3, 2014

took a few months off from all blogging (guest blogging as well as my site) to focus on training for myself. In that time I finally learned VBA for Excel and SQL to rock Google Spreadsheets' awesome query functions. During my time away several people asked me, after reading my post on how to trash y...

How To Pull Domains Out Of A List Of URLs In Excel [VIDEO]

August 3, 2013

parameter is optional. In the case of the LEFT function, I think it's kind of silly to make the number of characters optional. If you leave it out, Excel will just grab one character. Can't really think of many examples that would be useful, but knock yourself out if you find one. If you have a column ...

A Comprehensive Guide To Excel Charts For Marketers [VIDEO]

August 1, 2013

As marketers, the most important skill you need in Microsoft Excel is the ability to create and manipulate charts (followed by how to work with pivot tables). I reference charts frequently and wrote a post on how to make your charts sexy in Excel on the Search Engine Land site. And I did a presentatio...

How To Create A Cool Heat Map Like Avinash Showed At MozCon

July 19, 2013

my attention, as you might imagine. So I promised that I would write a follow-up post on how to create one of these works of art. Download Excel File If you want to peek under the hood and check out the heat map I created in the tutorial feel free to download the one I worked from. Breakdown...

month-over-month Google Analytics reports

How To Create Month-Over-Month Custom Reports In Google Analytics [VIDEO]

July 15, 2013

to be aware of though is the formatting for Month of Year is jacked up. So you'll need to take a few additional steps to format them as dates in Excel. Learn More If you want to learn more about working with custom reports in Google Analytics, check out the other video I did demonstrating one and ...

How To Create A Dynamic Chart From A Pivot Table [VIDEO]

July 3, 2013

width="1024"] Sorry, Macs, not for you[/caption] In a post I wrote last week, I demonstrated in a video how to use advanced filters (one of Excel's best-kept secrets) to divide a list of keywords into categories. I promised a commenter I would create a follow-up video demonstrating how I took t...

[VIDEO] Excel Bug In Pivot Charts On The Mac

July 3, 2013

As I mention in my post on creating pivot charts, you can't create pivot charts in Excel for the Mac. It's, hands down, my greatest aggravation with Excel. Bar none. However, Excel for the Mac has an additional bug that renders any pivot chart created on a PC that includes a report filter utterly useless...