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
This is a professional training course. Each license type allows a set number of users to access the training course. Please select an option from the list below. This is a professional training course. This is a single delegate licence. This allows access for one delegate. The training can be accessed live through a secure website. Username and password will be sent via email. This is a professional training course. This is a single delegate licence. This allows access for one delegate. The recorded training can be accessed through a secure website. Username and password will be sent via email.
