+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)
New

4 Hour Live Training on Marketing analytics: data-driven techniques with Microsoft Excel (March 7, 2023)

  • Training
  • 4 Hours
  • March 7, 2023 13:00 EST
  • Simpliv
  • ID: 5715421

About Marketing Analytics with MS Excel Training

In this practical and interactive virtual training, you will work along with the instructor. As you progress through the provided spreadsheet of exercises, you will learn how to use Excel to make sense of marketing data. You will work along with the instructor. As you progress through the provided spreadsheet of exercises, you will learn how to use Excel to implement advanced marketing analytic techniques.

Marketing Analytics with MS Excel Course Objective

  • Most marketing departments are awash in data.
  • You will learn how to describe and summarize marketing data, price products, and forecast product sales.
  • You will see many examples (all in Excel) that will enable you to master advanced marketing analytics techniques that are needed to make better marketing decisions.

Course Content

  • Using charts to summarize marketing data
  • Using Pivot Tables to summarize marketing data
  • Using Excel functions to summarize marketing data
  • Estimating demand cures and product pricing
  • Using Multiple regression to forecast sales
  • Forecasting in the presence of special events
  • Forecasting with trend and seasonality
  • Logistic regression
  • Bundling and Nonlinear pricing
  • Cluster Analysis
  • Forecasting new product sales with the Bass model, Gompertz, and Logistic Models
  • Using conjoint analysis to understand your customer
  • Calculating customer value
  • Discriminant analysis