وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel for Marketers

سرفصل های دوره

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.


01 - Introduction
  • 01 - Leveraging the power of Excel for marketing
  • 02 - Using the exercise files

  • 02 - 1. Excel Basics for Marketers
  • 01 - Sources of marketing data
  • 02 - Fixing data formatting issues
  • 03 - Navigating large data sheets
  • 04 - How to use formulas for analysis
  • 05 - Common marketing metrics

  • 03 - 2. Build a Data-Driven Marketing Plan
  • 01 - Mapping out your marketing funnel
  • 02 - Building a top-down marketing plan
  • 03 - Building a bottom-up marketing plan
  • 04 - Plotting the volume vs. cost tradeoff
  • 05 - Forecasting user retention over time
  • 06 - Calculating how long to run an AB test
  • 07 - Building a marketing mix model

  • 04 - 3. Analyze Your Campaign Performance
  • 01 - Analysis with tables, totals, and filters
  • 02 - Joining multiple data sets together
  • 03 - Segmenting your data with PivotTables
  • 04 - Plotting your data visually with charts
  • 05 - Finding daily, weekly, and monthly trends
  • 06 - Building a weekly report template
  • 07 - Building a performance dashboard
  • 08 - Cell extraction for further segmentation
  • 09 - The long tail and the 8020 rule
  • 10 - Calculating statistical significance

  • 05 - 4. Build Marketing Campaigns in Bulk
  • 01 - Bulksheets for Google and Meta Ads
  • 02 - Concatenating multiple URL parameters
  • 03 - Text manipulation for ad copy generation
  • 04 - Building complex formulas the easy way
  • 05 - Introduction to task automation with macros

  • 06 - Conclusion
  • 01 - Continuing with Excel as a marketer
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 15532
    حجم: 535 مگابایت
    مدت زمان: 143 دقیقه
    تاریخ انتشار: 12 تیر 1402
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید