Annielytics.com

I make data sexy

Excel

Box Plots: The Unsung Heroes of Data Analysis
Excel

Box Plots: The Unsung Heroes of Data Analysis

November 13, 2019
Introducing the “Making Data Sexy” Books
Excel

Introducing the “Making Data Sexy” Books

September 10, 2019
How To Add A Delta Symbol in Excel
Excel

How To Add A Delta Symbol in Excel

July 8, 2017
How To Create Histograms For Marketers In Excel [VIDEO]
Excel

How To Create Histograms For Marketers In Excel [VIDEO]

May 6, 2016
How to Dynamically Generate URLs on the Fly in Excel or Google Sheets
Excel

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

October 4, 2015
How To Create A Scrolling Table In Excel [VIDEO]
Excel

How To Create A Scrolling Table In Excel [VIDEO]

October 3, 2014
How To Use The SUMIF And SUMIFS Functions To Build Dynamic Dashboards [VIDEO]
Excel

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

September 12, 2014
The INDEX Function: Excel’s More Stable Alternative To OFFSET [VIDEO]
Excel

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

August 29, 2014
Excel’s INDEX MATCH Alternative To VLOOKUP For Marketers [VIDEO]
Excel

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

June 27, 2014
VLOOKUP Tips And Tricks For Marketers [VIDEO]
Excel

VLOOKUP Tips And Tricks For Marketers [VIDEO]

June 20, 2014
How To Find Text Within Text In Excel #FunctionFriday
Excel

How To Find Text Within Text In Excel #FunctionFriday

March 28, 2014
Three Marketing Examples Of The OFFSET Function [VIDEO]
Excel

Three Marketing Examples Of The OFFSET Function [VIDEO]

March 7, 2014
21 Real-World Examples Of Concatenating Marketing Data In Excel
Excel

21 Real-World Examples Of Concatenating Marketing Data In Excel

February 21, 2014
Easiest Way To Calculate Percent Delta in Excel
Excel

Easiest Way To Calculate Percent Delta in Excel

February 14, 2014
How To Save An Excel Formula Midstream
Excel

How To Save An Excel Formula Midstream

February 7, 2014
How To Pull Domains Out Of A List Of URLs In Excel [VIDEO]
Excel

How To Pull Domains Out Of A List Of URLs In Excel [VIDEO]

August 3, 2013
A Comprehensive Guide To Excel Charts For Marketers [VIDEO]
Excel

A Comprehensive Guide To Excel Charts For Marketers [VIDEO]

August 1, 2013
How To Create A Cool Heat Map Like Avinash Showed At MozCon
Excel

How To Create A Cool Heat Map Like Avinash Showed At MozCon

July 19, 2013
How To Create A Dynamic Chart From A Pivot Table [VIDEO]
Excel

How To Create A Dynamic Chart From A Pivot Table [VIDEO]

July 3, 2013
[VIDEO] Excel Bug In Pivot Charts On The Mac
Excel

[VIDEO] Excel Bug In Pivot Charts On The Mac

July 3, 2013
1 2