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
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX