Excel for Marketers
Focused View
Michael Taylor
2:22:39
282 View
01 - Leveraging the power of Excel for marketing.mp4
00:45
02 - Using the exercise files.mp4
00:45
01 - Sources of marketing data.mp4
03:11
02 - Fixing data formatting issues.mp4
04:24
03 - Navigating large data sheets.mp4
05:55
04 - How to use formulas for analysis.mp4
06:18
05 - Common marketing metrics.mp4
10:39
01 - Mapping out your marketing funnel.mp4
04:41
02 - Building a top-down marketing plan.mp4
04:35
03 - Building a bottom-up marketing plan.mp4
05:02
04 - Plotting the volume vs. cost tradeoff.mp4
04:30
05 - Forecasting user retention over time.mp4
05:48
06 - Calculating how long to run an AB test.mp4
03:34
07 - Building a marketing mix model.mp4
10:00
01 - Analysis with tables, totals, and filters.mp4
05:12
02 - Joining multiple data sets together.mp4
03:41
03 - Segmenting your data with PivotTables.mp4
03:39
04 - Plotting your data visually with charts.mp4
04:26
05 - Finding daily, weekly, and monthly trends.mp4
03:44
06 - Building a weekly report template.mp4
05:10
07 - Building a performance dashboard.mp4
06:39
08 - Cell extraction for further segmentation.mp4
07:22
09 - The long tail and the 8020 rule.mp4
05:21
10 - Calculating statistical significance.mp4
04:22
01 - Bulksheets for Google and Meta Ads.mp4
06:08
02 - Concatenating multiple URL parameters.mp4
03:54
03 - Text manipulation for ad copy generation.mp4
05:03
04 - Building complex formulas the easy way.mp4
03:47
05 - Introduction to task automation with macros.mp4
03:28
01 - Continuing with Excel as a marketer.mp4
00:36
Description
Excel is a powerful tool for analyzing marketing data and trends. But it’s easy to be scared off by its hundreds of different formulas and functions—and most marketers barely scratch 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 shares helpful formulas for marketers to know, shows how to build data-driven marketing plans, how to analyze campaign performance, takes you through the process of building marketing campaigns in bulk, and more.
More details
User Reviews
Rating
average 0
Focused display
Michael Taylor
Instructor's CoursesData-driven, technical marketer with 10 years experience and $50m optimized across paid and organic channels. Co-Founded Ladder.io and grew it to 50 people, with clients like Monzo Bank, Booking.com and Time Out. Now building a simulator-based course on marketing mix modeling at vexpower.com.
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 30
- duration 2:22:39
- English subtitles has
- Release Date 2023/07/02
