Excel for Marketers (2017)
1h 42mBeginner2017-10-04
Authors
Michael Taylor
Cofounder and COO of Ladder.io
Course details
Excel is a tremendously powerful tool for analyzing marketing data and trends. Yet it's easy to be scared off by its hundreds of different formulas and functions. Most marketers are barely scratching the surface of what Excel can really do. In this course, veteran marketer and Excel power user Michael Taylor walks you through all the key features that can speed up your work and help you make smarter marketing decisions.
Michael begins with the basics, showing how to work with marketing data sources and explaining basic formulas for analysis. Next, he walks through how to build a data-driven marketing plan, including mapping out your marketing funnel, reviewing volume vs. cost tradeoff, and running A/B testing. Michael shows how to analyze a campaign's performance, working with PivotTables, charts, and dashboards. Finally, he demonstrates how to set up marketing campaigns in bulk, including manipulating text for ad copy generation and automating the most boring, repetitive tasks with macros.
Learning objectives
Cleaning up data formatting
Using formulas for analysis
Building a data-driven marketing plan
Top-down vs. bottom-up marketing plans
Running A/B tests
Analyzing campaign performance
Plotting data visually
Building report templates and dashboards
Building bulksheets for bulk campaigns on AdWords and Facebook
Michael begins with the basics, showing how to work with marketing data sources and explaining basic formulas for analysis. Next, he walks through how to build a data-driven marketing plan, including mapping out your marketing funnel, reviewing volume vs. cost tradeoff, and running A/B testing. Michael shows how to analyze a campaign's performance, working with PivotTables, charts, and dashboards. Finally, he demonstrates how to set up marketing campaigns in bulk, including manipulating text for ad copy generation and automating the most boring, repetitive tasks with macros.
Learning objectives
Cleaning up data formatting
Using formulas for analysis
Building a data-driven marketing plan
Top-down vs. bottom-up marketing plans
Running A/B tests
Analyzing campaign performance
Plotting data visually
Building report templates and dashboards
Building bulksheets for bulk campaigns on AdWords and Facebook
Skills covered
Enterprise MarketingMicrosoft OfficeMicrosoft ExcelMarketingMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Welcome
- 02 - Exercise files
1. Excel Basics for Marketers
- 03 - Sources of marketing data
- 04 - Fixing data formatting issues
- 05 - Navigating large data sheets
- 06 - How to use formulas for analysis
- 07 - Common marketing metrics
2. Build a Data-Driven Marketing Plan
- 08 - Mapping out your marketing funnel
- 09 - Building a top-down marketing plan
- 10 - Building a bottom-up marketing plan
- 11 - Plotting the volume vs. cost tradeoff
- 12 - Forecasting user retention over time
- 13 - Calculating how long to run an A B test
3. Analyze Your Campaign Performance
- 14 - Analysis with tables, totals, and filters
- 15 - Joining multiple data sets together
- 16 - Segmenting your data with PivotTables
- 17 - Plotting your data visually with charts
- 18 - Finding daily, weekly, and monthly trends
- 19 - Building a weekly report template
- 20 - Building a performance dashboard
- 21 - Cell extraction for further segmentation
- 22 - The long tail and the 80 20 rule
- 23 - Calculating statistical significance
4. Build Marketing Campaigns in Bulk
- 24 - Bulksheets for AdWords and Facebook
- 25 - Concatenating multiple URL parameters
- 26 - Text manipulation for ad copy generation
- 27 - Building complex formulas the easy way
- 28 - Intro to task automation with macros
Conclusion
- 29 - Next steps