Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Campaign Budget Tracker: Planned vs SpentLabFree
  2. Paid Channel Metrics: CTR, CPC, CPM, Conversion Rate, CPA and ROASLab Locked
  3. Email Campaign Stats: Delivered, Open, Click and Unsubscribe RatesLab Locked
  4. Social Media Content Calendar: Posts per Platform and WeekLab Locked
  5. Lead Funnel: Step Conversion and Visitors NeededLab Locked
  6. A/B Test: Rates, Lift and a Sanity CheckLab Locked
  7. Cleaning a Lead List: TRIM, PROPER, LOWER and DuplicatesLab Locked
  8. UTM Link Builder: Joining Text into Tracking LinksLab Locked
  9. Event and Webinar ROI: Costs, Show-up Rate and ReturnLab Locked
  10. Monthly Marketing Report: Growth %, Conversion and a Trend ChartLab Locked
  11. Q3 Marketing Dashboard: ROAS by Channel, Chart and HighlightsLab Locked
  12. From Raw Export to Summary: SUMIFS by Channel and MonthLab Locked
  13. Mapping Table: Grouping Messy Source Names with XLOOKUP and IFNALab Locked
  14. Campaign Timeline: Durations, Creative Deadlines with WORKDAY and Campaigns Live per WeekLab Locked
  15. Vendor Invoices: Matching to Purchase Orders with XLOOKUP and Days OverdueLab Locked
  16. Social Post Performance: Engagement Rate, Averages by Format and the Top PostLab Locked
  17. Email Segments: Opt-Ins, Segment Rules and Contacts per RegionLab Locked
  18. Event Kit Inventory: Needed Quantities, Shortfalls and Orders in Full PacksLab Locked
  19. Event Feedback Survey: Score Groups, the Score Distribution and NPSLab Locked
  20. Final Project: The Quarterly Marketing Pack – Budget Use, CPA, ROAS, Review Flags and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy