Annielytics.com

I make data sexy

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

Nov 21 2012

Clean Up Data Labels From The GA API

One annoying idiosyncrasy of pivot tables is that all of the headings are prepended with a label indicating how the data is summarized. The most … [Read more...]

Written by Annie · Categorized: Excel · Tagged: Excel Formatting, Google Analytics API, Pivot Tables

Nov 20 2012

Do Math On The Fly In Paste Options

One annoyance with using the Google Analytics API is that it doesn't format percentages correctly. Instead of coming in as fractions that you just … [Read more...]

Written by Annie · Categorized: Excel · Tagged: Excel Formatting, Google Analytics, Google Analytics API

Nov 19 2012

How To Convert Google Analytics’ Funky Month of Year Format In Excel

UPDATE: Since I've had a couple questions about how to display the date as just the month and year, I created a Google Sheet demonstrating several … [Read more...]

Written by Annie · Categorized: Excel

Nov 18 2012

Formatting Dates in Excel

You're not limited to the date formats built into Excel. You can format them however your heart desires. The underlying value (the exact date) will … [Read more...]

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

Nov 16 2012

Show Change As A Delta Symbol in Excel

When I'm working with tables or charts, I like to make labels as short as possible. So when I'm showing a change in a metric over time, like percent … [Read more...]

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

  • « Previous Page
  • 1
  • …
  • 5
  • 6
  • 7

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