Excel for Marketers

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.

Topics include:

  • 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

Course Timeline:

Excel for Marketers Welcome

...

Excel for Marketers Exercise-files

...

Excel for Marketers

...

Fixing data formatting issues

...

Navigating large data sheets

...

How to use formulas for analysis

...

Common marketing metrics

...

Mapping Out Your Marketing Funnel

...

Building a top-down marketing plan

...

Building a bottom-up marketing plan

...

Plotting the volume vs. cost tradeoff

...

Forecasting user retention over time

...

Calculating how long to run an A/B test

...

Analysis with tables, totals, and filters

...

Joining multiple data sets together

...

Segmenting your data with PivotTables

...

Building a weekly report template

...

Plotting your data visually with charts

...

Finding daily, weekly, and monthly trends

...

Building a performance dashboard

...

Cell extraction for further segmentation

...

The "long tail" and the 80/20 rule

...

Calculating statistical significance

...

Bulksheets for AdWords and Facebook

...

Concatenating multiple URL parameters

...

Text manipulation for ad copy generation

...

Building complex formulas the easy way

...

Intro to task automation with macros

...

Excel for Marketers Next Step

...

Course Reviews:

Average Rating 0
0 Ratings
Details
5 Stars 0
4 Stars 0
3 Stars 0
2 Stars 0
1 Stars 0

No reviews yet.