This website or its third-party tools use cookies which are necessary to its functioning and required to improve your experience. By clicking the consent button, you agree to allow the site to use, collect and/or store cookies.
The platform this site runs on doesn't have the option to turn off cookies server side, but you can do that in your browser and then return to the site.
I accept
Deny cookies Go Back

Annielytics.com

I make data sexy

  • About
  • Resources
  • Services
  • Blog
  • Contact
  • Log In

Search Results for: excel

Aug 24 2016

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

Note: Bad news — All the cool API Excel extensions are PC swim only.  Backstory When the Annielytics' Dashboard Course was first released, Excellent … [Read more...]

Written by Tori Cushing · Categorized: Analytics · Tagged: Analytics Edge, Excel Dashboards, Excellent Analytics, Google Analytics API, Google Analytics Dashboards

May 06 2016

How To Create Histograms For Marketers In Excel [VIDEO]

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 … [Read more...]

Written by Annie Cushing · Categorized: Excel · Tagged: Excel Charts, Excel Formulas, Screaming Frog

Oct 04 2015

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

Why Include Dynamic Links in Dashboards When I create dashboards, I like to add as many resources as possible for stakeholders who want more … [Read more...]

Written by Annie Cushing · Categorized: Excel, Google Docs · Tagged: Excel, Excel Dashboards, Google Analytics, Google Doc Functions, Google Docs, Google Sheets, SEMRush

Oct 03 2014

How To Create A Scrolling Table In Excel [VIDEO]

In today's video I demonstrate how to create a scrolling table in Excel using the scrollbar option in your format controls. This is a great way to … [Read more...]

Written by Annie Cushing · Categorized: Excel · Tagged: Excel Dashboards, Excel Formulas, Google Analytics

Aug 29 2014

The INDEX Function: Excel’s More Stable Alternative To OFFSET [VIDEO]

Back in March I did a post on three marketing uses for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The … [Read more...]

Written by Annie Cushing · Categorized: Excel · Tagged: Excel, Excel Charts, Excel Formulas, Google Analytics

  • 1
  • 2
  • 3
  • …
  • 13
  • Next Page »

CAN I HELP YOU FIND SOMETHING?

‘MAKING DATA SEXY’ IS LIVE ?

Want to learn how to create compelling, aesthetically pleasing charts in Excel? Learn how with Making Data Sexy.

Note: Also offered for Mac

STUFF I BLOG ABOUT

LEARN HOW TO USE ALL THE TOOLS

marketing strategy guide

DIY marketing strategy guide. This guide provides step-by-step instructions on how to perform 66 unique marketing tasks using 15 reputable marketing tools (both free and paid). Steal it for $295! Learn more.

LEARN TO DO A SITE AUDIT

site audit template

DIY site audit template. 20 sections, 215 checkpoints, 100+ explainer graphics, 218 pages, step-by-step instructions. Steal it for $295! Learn more.

LEARN TO DO AN ANALYTICS AUDIT

analytics audit template

DIY analytics audit template. 8 sections, 61 checkpoints, 100+ explainer graphics, 205 pages, step-by-step instructions. Steal it for $295! Learn more.

TO THIS DATA I DO THEE WED

dashboard course

Learn to build dynamic dashboards in Excel with Google Analytics data. 16 hours of video, 3 sample dashboards, 142-page workbook, practice Excel file, and more! Learn more.

FOLLOW ME ON TWITTER

SUBSCRIBE TO MY YOUTUBE CHANNEL

Privacy Policy
  • Email
  • LinkedIn
  • Twitter
  • YouTube

© 2023 annielytics.com