Search Results for: excel

Results 1-10 of 55

Regex for Marketers in Plain English with Real World Examples [VIDEO]

February 5, 2021

/services/ /comprehensive-self-guided-site-audit-checklist/ /resources/ /blog/analytics/referral-exclusion-list-google-analytics-explained/ /blog/excel-tips/formatting-dates-in-excel/ /about/ /services/analytics-audits/ /about-me/ Caveat Just because a $ means the end of a line, it doesn't necessari...

Timeline of Events Around the Lori Vallow Daybell Case

February 9, 2020

z’s. Lori: We are trying to get to the bottom of what we need to do to eliminate them completely. I'm sure you will be told also. ❤️ Alex: Excellent. Alex: I am going to get lunch and probably go to the range to sight in my rifles. Notes: Notice how Alex replies almost identically as he re...

Introducing the “Making Data Sexy” Books

September 10, 2019

because I have 0 regard for my financial portfolio (or mental health). One is for Windows users. (No surprise there. You guys get all the Excel books.?) But this time we Mac users get our own version! [caption id="attachment_14511" align="alignnone" width="2121"] I gotchu, Mac users![/capt...

How To Add A Delta Symbol in Excel

July 8, 2017

This is a minor detail, but I don’t like to have column headings that are long in a table. A classic example is I don’t like a heading that says “Percent Difference” because you know there’s going to be a percentage in that column, but the column is going to be unnecessarily wide to accommodate […]

Analytics Edge: Free, Reliable, Everything Excellent Analytics Wasn’t [VIDEO]

August 24, 2016

Note: Bad news — All the cool API Excel extensions are PC swim only. Backstory When the Annielytics' Dashboard Course was first released, Excellent Analytics was the best option for a free Google Analytics API tool. But now Excellent Analytics is no longer available, so we're providing training on...

How To Create Histograms For Marketers In Excel [VIDEO]

May 6, 2016

Histogram charts are great tools for marketers, but unfortunately Excel doesn't make the process of creating them terribly intuitive. But I'll try to simplify it for you a bit. Why A Histogram? Histograms are good for summarizing data into groups. Think about a teacher who has given a test and wants...

How to Dynamically Generate URLs on the Fly in Excel or Google Sheets

October 4, 2015

report URLs. [caption id="attachment_6617" align="alignnone" width="650"] Click for larger image[/caption] You can get a date picker in Excel, but it's much more complicated (thanks, Obama). In Excel 2013 for PC users you can use a form control (learn more), or for 2011 Mac users you can us...

How to Remove Duplicates in Google Sheets Using the UNIQUE Function [VIDEO]

April 3, 2015

Google Sheets doesn't have a Remove Duplicates option, like Excel does. However, you can still use Google Sheets for your duplicate data removal needs! In this video, I'll show you how to remove duplicate values from a list in Google Sheets using the UNIQUE function. I really wish Excel had this functi...

How To Use Google Fusion Tables: A Simple Guide For Marketers [VIDEO]

March 30, 2015

a little longer (17 mins total), here's a breakdown of the tutorial: 00:10: Pull backlinks from Moz's Open Site Explorer 01:29: Clean up data in Excel (crazy Excel formula to grab category at 01:55 mark) 04:24: Get data into your fusion table 05:29: Set up network graph (where the magic happens)...