Excel for Marketers
Offered By: LinkedIn Learning
Course Description
Overview
Learn the most important and powerful features of Excel for any marketer.
Syllabus
Introduction
- Leveraging the power of Excel for marketing
- Using the exercise files
- Sources of marketing data
- 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
- Building a marketing mix model
- Analysis with tables, totals, and filters
- Joining multiple data sets together
- Segmenting your data with PivotTables
- Plotting your data visually with charts
- Finding daily, weekly, and monthly trends
- Building a weekly report template
- Building a performance dashboard
- Cell extraction for further segmentation
- The long tail and the 80/20 rule
- Calculating statistical significance
- Bulksheets for Google and Meta Ads
- Concatenating multiple URL parameters
- Text manipulation for ad copy generation
- Building complex formulas the easy way
- Introduction to task automation with macros
- Continuing with Excel as a marketer
Taught by
Michael Taylor
Related Courses
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent