Annielytics.com

I make data sexy

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

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

Apr 03 2015

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

Google Sheets doesn't have a Remove Duplicates option, like Excel does. However, you can still use Google Sheets for your duplicate data removal … [Read more...]

Written by Annie Cushing · Categorized: Google Docs · Tagged: Google Doc Functions, Google Docs, Google Sheets

Feb 21 2015

How To Import One Spreadsheet Into Another In Google Drive [VIDEO]

I worked with an editorial team for this project. And editorial teams love working in Google Docs. But managing them can be a bear because … [Read more...]

Written by Annie Cushing · Categorized: Google Docs · Tagged: Google Docs, Google Sheets

Dec 20 2012

Email Attachments Up To 10GB Using Google Drive

I noticed an extra icon in my Gmail and decided to explore it. Turns out, Google has dialed up its Gmail/Drive integration by allowing users to send … [Read more...]

Written by Annie · Categorized: Google Docs

Nov 17 2012

How To Use Google Docs’ JOIN And SPLIT Functions

  Google Docs offers two functions in its spreadsheets that Excel doesn't: JOIN and SPLIT. They are the finessed alternatives to Excel's … [Read more...]

Written by Annie · Categorized: Google Docs · Tagged: Google Doc Functions

  • 1
  • 2
  • 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