Introduction: Data is leading a transformation in the ways in which both Sales and Marketing are being looked upon. Any sales or marketing professional needs to understand data and should be able to analyze it to get the insights of data. Excel is a tremendously powerful tool for analyzing sales and marketing data as well as trends. Most professionals are barely scratching the surface of what Excel can really do.
In this two-day session, participants will learn best practices in Excel for a sales/marketing professional. While most of the functions and formulas are common for any Excel user, there are a few things that could be more relevant for sales and marketing. This training will highlight such features in Excel in addition to provide a good idea of the most important and advanced Excel features.
Who can attend this session?
Sales/Marketing professionals who are using Excel to analyze their data.
Any Excel user, who is interested in exploring the possibilities in Excel to perform Data Analysis.
Compiling & Analyzing Survey Data
Segmenting and Targeting the Market
Product Life Cycle Analysis
Competitive Analysis Moving from Data to Information
Presenting and Reporting the Data
The Marketing Mix
Course Contents:- Module-1:
Data Cleansing activities
Decision Making functions e.g IF, AND, OR, NOT
Usage of SUMIF, AVERAGEIF and COUNTIF functions in single condition scenarios
Creating Simple Dashboards
Creating results with minimum formulas or without formulas
Usage of Goal Seek & Data Tables
Comparing preset objectives and goals using Scenario Manager
Learning about SOLVER Add-in
Estimating Demand Curves and Using Solver to Optimize Price
What is Price Bundling?
Pricing products using tie-ins
Knowing about Nonlinear Pricing
Effect of Price Skimming on Sales
Sales Forecast with Simple Linear Regression, Multiple Regression & Correlation
Predicting future values based on past records of sales figures
Making forecasts while Special Events are to be considered
Trend and Seasonality Modelling
Moving Average Forecast methods
Identifying Customer Value:
Calculating Lifetime Customer value
Business value from customer value
Monte Carlo Simulation and Marketing Decision Making
Allocating Marketing Resources between Customer Acquisition and Retention
Using Excel for Market Basket Analysis
Identifying the Effectiveness of Advertising
Analysis of Variance: One-way ANOVA & Two-way ANOVA