Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Marketing Data Analysis using Excel
Rating: 4.5 out of 5(21 ratings)
87 students

Marketing Data Analysis using Excel

With Real Time Data
Created byYelamanchili Rama Krishna
Last updated 11/2020
English
English [Auto],

What you'll learn

  • Marketing Data Analysis
  • Data Analysis using Excel
  • Analyzing real time marketing research data with pivot tables
  • Analyzing real time marketing research data with pivot charts
  • Hypothesis testing of marketing data using Chi Square test
  • Know how to rank the variables and run rank correlation in Excel

Course content

3 sections • 11 lectures • 1h 24m total length

  • Create Data Table in Excel6:13

    Learn how to create data table in excel and enter market research data. Know about data validation tool and how to use it for error proof entry of demographic data.

  • Create Data Entry Form in Excel4:37

    Learn how to create data entry form in Excel. Also know how to enter marketing research data in Excel data table using Excel data entry form.

  • Create drop down list in Excel5:39

    Learn how to create drop down list to enter market research data in Excel data table. Know the application of data validation - List option to create and use drop down list.

  • Convert option number to option name in Excel data table4:32

    With marketing data entry form or data validation you may have entered variable options in numeric values in Excel. From this lecture learn how to convert numeric data in text option names.

Requirements

  • Interest in Marketing Research
  • Interest in Data Analysis

Description

Our search for keyword "Marketing Data Analysis" on India's leading job portal resulted into 47,000 job offers, of these jobs 40,000 are directly offered by Companies. Is this not a right career to choose? Why wait and think. Join this course and learn how to perform marketing data analysis from scratch to hypothesis testing using MS-Excel.

From this course earn how to create data tables, data entry form, listed data entry form and enter data in MS Excel. Also learn how to create frequency distribution tables and cross tabulations, draw pivot charts, how to run descriptive statistics, and inferential statistics of Marketing data in Excel.

Who this course is for:

  • Beginner with interest in marketing research
  • Under graduates and graduates studying marketing course
  • B Com, BBA, MBA, M Com Graduates

Report abuse