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
Using Covid-19 Data to Make Supply Chain Logistics Decisions in SpreadsheetsCoursera Project Network via Coursera Microsoft Excel - Excel from Beginner to Advanced
Udemy Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Microsoft Excel Mastery: From Beginner to Pro
Udemy