Excel for Marketing Coordinators: Budgets, Campaign Metrics & Reports
20 hands-on labs for marketing coordinators and assistants: campaign budget tracking, ad metrics (CTR, CPC, CPM, CPA, ROAS), email stats, a social content calendar, funnels, A/B tests, lead list cleanup, UTM links, event ROI, a monthly report and a dashboard – plus summaries from raw exports with SUMIFS, mapping tables with XLOOKUP, campaign timelines, invoice matching, social post performance, email segments, event kit orders, feedback surveys with NPS and a quarterly marketing pack.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course covers the spreadsheet work a marketing coordinator does every week, in 20 hands-on labs at a fictional outdoor brand. You track campaign budgets, turn ad exports into CTR, CPC, CPM, CPA and ROAS, report email rates, count posts in a content calendar, follow a lead funnel, compare A/B variants, clean a lead list, build UTM links, judge event ROI and prepare a monthly report and a dashboard. The second half adds the next steps: summarising raw exports with SUMIFS, grouping messy sources with a mapping table, planning campaign timelines with WORKDAY, matching invoices to purchase orders, comparing social posts by engagement rate, building email segments, ordering event kit in full packs, scoring feedback with NPS and assembling a quarterly marketing pack with a combo chart. Every cell is checked as you go.
Lessons
- Campaign Budget Tracker: Planned vs SpentFree
- Paid Channel Metrics: CTR, CPC, CPM, Conversion Rate, CPA and ROAS Locked
- Email Campaign Stats: Delivered, Open, Click and Unsubscribe Rates Locked
- Social Media Content Calendar: Posts per Platform and Week Locked
- Lead Funnel: Step Conversion and Visitors Needed Locked
- A/B Test: Rates, Lift and a Sanity Check Locked
- Cleaning a Lead List: TRIM, PROPER, LOWER and Duplicates Locked
- UTM Link Builder: Joining Text into Tracking Links Locked
- Event and Webinar ROI: Costs, Show-up Rate and Return Locked
- Monthly Marketing Report: Growth %, Conversion and a Trend Chart Locked
- Q3 Marketing Dashboard: ROAS by Channel, Chart and Highlights Locked
- From Raw Export to Summary: SUMIFS by Channel and Month Locked
- Mapping Table: Grouping Messy Source Names with XLOOKUP and IFNA Locked
- Campaign Timeline: Durations, Creative Deadlines with WORKDAY and Campaigns Live per Week Locked
- Vendor Invoices: Matching to Purchase Orders with XLOOKUP and Days Overdue Locked
- Social Post Performance: Engagement Rate, Averages by Format and the Top Post Locked
- Email Segments: Opt-Ins, Segment Rules and Contacts per Region Locked
- Event Kit Inventory: Needed Quantities, Shortfalls and Orders in Full Packs Locked
- Event Feedback Survey: Score Groups, the Score Distribution and NPS Locked
- Final Project: The Quarterly Marketing Pack – Budget Use, CPA, ROAS, Review Flags and a Combo Chart Locked
Learner reviews
Be the first to review this course.