• weekwid: false
  • widHeader: false
  • orgName:
  • orwid: false

Data Analysis For Sales & Marketing Professionals Using Excel

Tue, 24 Dec 2019 9:30AM - 5:00PM
Rs 11210
51 people viewed this event.
I Am Interested

Get notified when the event happens next time.



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.

Learning Objectives:

  • 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:-

  • 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


  • Market Segmentation:

    • Classification Tree
    • Collaborative Filters
    • Cluster Analysis

  • 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
  • Inventory modelling with uncertain demand

This entire session will be a hands-on workshop.

Login to View Organizer Details
Like this event ? Share it with your friends !!

Map & Directions

Map & Directions
JW Marriott Hotel Mumbai Juhu Tara Road, Juhu Beach Mumbai India 400049
No reviews available
Write a review
Be the first one to review! Share your experience.

Frequently Asked Questions

Have any query? Drop your questions here !!
EventsHigh Specials, cluster analysis, competitive analysis, modelling, business value, data analysis, targeting, decision making, advertising, reporting, classes and workshops, tech workshops,