Introduction
Welcome
(00:56)
Exercise files
(00:35)
1. Excel Basics for Marketers
Sources of marketing data
(01:58)
Fixing data formatting issues
(04:14)
Navigating large data sheets
(02:49)
How to use formulas for analysis
(03:39)
Common marketing metrics
(03:13)
2. Build a Data-Driven Marketing Plan
Mapping out your marketing funnel
(02:57)
Building a top-down marketing plan
(03:00)
Building a bottom-up marketing plan
(04:07)
Plotting the volume vs. cost tradeoff
(02:20)
Forecasting user retention over time
(03:36)
Calculating how long to run an A/B test
(01:49)
3. Analyze Your Campaign Performance
Analysis with tables, totals, and filters
(02:45)
Joining multiple data sets together
(03:17)
Segmenting your data with PivotTables
(04:26)
Plotting your data visually with charts
(05:50)
Finding daily, weekly, and monthly trends
(05:00)
Building a weekly report template
(06:41)
Building a performance dashboard
(06:29)
Cell extraction for further segmentation
(05:42)
The "long tail" and the 80/20 rule
(05:13)
Calculating statistical significance
(03:23)
4. Build Marketing Campaigns in Bulk
Bulksheets for AdWords and Facebook
(03:51)
Concatenating multiple URL parameters
(05:03)
Text manipulation for ad copy generation
(03:43)
Building complex formulas the easy way
(02:26)
Intro to task automation with macros
(02:47)
Conclusion
Next steps
(00:27)
Ex_Files_Excel_for_Marketers.zip
(6.9 MB)