Join Michael Taylor for an in-depth discussion in this video Next steps, part of Excel for Marketers.
- [Instructor] Thank you for joining me on this course.…I hope you find it helpful.…But this is just the start.…If you'd like to learn more, I have three suggestions.…First, check out Microsoft Excel Help Center.…You can learn how each function works…as well as search for help if you run into problems.…Next, check out the blog post that inspired this course,…where you can find the Excel tutorial we created…to train our new hires at Ladder.…Finally, you can keep exploring Excel…on LinkedIn Learning.…
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.
- 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
Skill Level Beginner
1. Excel Basics for Marketers
2. Build a Data-Driven Marketing Plan
3. Analyze Your Campaign Performance
4. Build Marketing Campaigns in Bulk
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.