Annielytics.com

I make data sexy

Annielytics Blog

Annielytics Blog

How To Chart Year-Over-Year Google Analytics Reports In Excel [VIDEO]
Analytics

How To Chart Year-Over-Year Google Analytics Reports In Excel [VIDEO]

October 3, 2014
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
How To Clean Up Google Analytics’ Content Reports From A Professional SEO Company
Analytics

How To Clean Up Google Analytics’ Content Reports From A Professional SEO Company

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

VLOOKUP Tips And Tricks For Marketers [VIDEO]

June 20, 2014
When Good Data Goes Bad: An Expose On View Filters In Google Analytics
Analytics

When Good Data Goes Bad: An Expose On View Filters In Google Analytics

June 16, 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
1 … 5 6 7 8 9 … 11