Annielytics.com

I make data sexy

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

Sep 12 2014

How To Use The SUMIF And SUMIFS Functions To Build Dynamic Dashboards [VIDEO]

In today's #FunctionFriday post we're going to look at how the SUMIF and SUMIFS functions can be used to build out interactive dashboards like the … [Read more...]

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

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

Jun 27 2014

Excel’s INDEX MATCH Alternative To VLOOKUP For Marketers [VIDEO]

Last week's #FunctionFriday video tutorial covered VLOOKUP tips and techniques for marketers. This week's video explores the INDEX MATCH alternative … [Read more...]

Written by Annie · Categorized: Excel · Tagged: Excel Formulas

Jun 20 2014

VLOOKUP Tips And Tricks For Marketers [VIDEO]

The VLOOKUP function in Excel is one of the most essential functions marketers need to master. It's a staple in my tool set because it allows you to … [Read more...]

Written by Annie · Categorized: Excel · Tagged: Excel, Excel Formulas

Mar 28 2014

How To Find Text Within Text In Excel #FunctionFriday

Update: Based on questions I've received, I added the Misc Notes section to the end of this post. Continuing with our #FunctionFriday series, today … [Read more...]

Written by Annie · Categorized: Excel · Tagged: Excel Formulas, Google Analytics, Google Analytics Custom Reports, WordPress

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • …
  • 7
  • 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

© 2021 annielytics.com