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.
Who is the Marketing Analytics with MS Excel Course Target Audience?
- Accountants, Accounts, Audit
- Aviation
- Banking, CFOs
- Controllers, CPAs
- Education
- Energy
- FDA
- Finance, Financial consultants
- Human Resource
- Insurance
- Investments
- IT
- Logistics & Supply Chain
- Marketing
- Medical Devices
- Pharmaceutical
- Retail, Sales
- Telecom
What Basic Knowledge Required to Learn Marketing Analytics Training?
- This is an intermediate-level class. Attendees should be familiar with Excel and use it regularly, at least weekly.
Curriculum
Total Duration: 4 Hours
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