COURSES
MBAData Science & AnalyticsDoctorate AI | ML MarketingManagement
Job Linked
Bootcamps
Study Abroad
MS in Project ManagementMS in Information TechnologyMasters Degree in Artificial IntelligenceMBS in Entrepreneurship and MarketingMS in Computer ScienceMS Data Science MSc International Business and ManagementMS Engineering ManagementMS in Machine Learning EngineeringMS in Engineering ManagementMPS in InformaticsMS in Project ManagementMPS in AnalyticsMS in Project ManagementMS in Organizational LeadershipMPS in Analytics - NEU CanadaMPS in Informatics - NEU Canada Master in Business AdministrationMS in Digital Marketing and MediaMSc Sustainable Tourism and Event ManagementMSc in Circular Economy and Sustainable InnovationMSc in Impact Finance and Fintech ManagementMS Computer ScienceMBA in Technology, Innovation and EntrepreneurshipMSc Data Science with Work PlacementMSc Global Business Management with Work Placement MBA with Work PlacementMS in Robotics and Autonomous SystemsMS in Civil EngineeringMS in Internet of ThingsMSc International Logistics and Supply Chain ManagementMBA- Business InformaticsMSc International ManagementMBA in Strategic Data Driven ManagementMBA Business and MarketingMSc in Sustainable Global Supply Chain ManagementMSc Digital Business Analytics MSc in International HospitalityMSc Luxury and Innovation ManagementMaster of Business Administration-International Business ManagementMS in Computer EngineeringMS in Industrial and Systems EngineeringMSc MarketingMSc Global Supply Chain ManagementMS in Information Systems and Technology with Business Intelligence and Analytics ConcentrationMSc Corporate FinanceMSc Data Analytics for BusinessMaster of Business AdministrationMaster of Business AdministrationMaster of Business AdministrationMSc in International FinanceMaster of Business AdministrationBachelor of BusinessBachelor of Business AnalyticsBachelor of Information TechnologyMaster of Business AdministrationMBA Business AnalyticsMSc in Marketing Analytics and Data IntelligenceMS Biotechnology Management and EntrepreneurshipMSc in Luxury and Fashion ManagementMaster of Business Administration (90 ECTS)Bachelor of Business Administration (180 ECTS)B.Sc. Computer Science (180 ECTS) MSc in International Corporate Finance MSc in Sustainable Luxury and Creative IndustriesMSc Digital MarketingMSc Global Supply Chain Management (PGMP)MSc Marketing (PGMP)MSc Corporate Finance (PGMP)MSc Data Analytics for Business (PGMP)MS Business AnalyticsMaster of Business AdministrationMS Quantitative FinanceMS Fintech ManagementMS Business Analytics PGMPState University of New York Bachelors Program - STEM MSc Business Intelligence and Data Science (PGMP)MSc International Logistics and Supply Chain Management ( PGMP)MSc International Management (PGMP)MSc Psychology & Management (PGMP)State University of New York Bachelor's Year 1 ProgramMaster of Health Services AdministrationM.A Digital Marketing (PGMP)MS in Technology Leadership and Project ManagementMaster of Health Services Administration and Master of Business Administration (Dual Degree)MSc in Supply Chain ManagementMSc in Hospitality ManagementMaster of Business Administration 60 ECTS UAMMaster of Business Administration 90 ECTSMaster of Computer Science 90 ECTSM.Engg Industrial Engineering 90 ECTSM.A in Management 90 ECTSMS in Data AnalyticsMS in Artificial IntelligenceMaster of Business AdministrationMA International Business & LeadershipMaster of Business Administration 90 ECTSMA International Hospitality Management 120 ECTSMPS in Digital MediaMS Engineering Management
For College Students

Introduction to Data Analysis in Excel

$$/$$

Welcome to the second session of Data Analysis in Excel. In this session, you will learn to use some powerful Excel techniques used to understand and manipulate data. The learning objectives of this session are:

  1. Use CSV and delimited files to read data
  2. To understand common tricks in Data Analysis (e.g.: Bucketing & Segmenting)
  3. Use shortcuts while working in MS Excel
  4. Use formulae and Cell Referencing in MS Excel
  5. Create visualisations to analyse and present data / important insights 

 

This module assumes no pre-requisite knowledge of Excel and essentially builds on what you've learnt in session 1.

 

In this session:

In this session, you will take a bank's telemarketing business problem to understand the types of customers which should be targeted for future marketing campaigns. The dataset contains demographic and personal information of about 45000 people and their response to a telemarketing campaign, i.e. whether they bought a certain product when contacted by the company through telemarketing. 

 

Our objective is to find the attributes of customers who are likely to buy the product when contacted through telemarketing. This is a classic case of acquisition analytics where companies use past data to predict which customers are likely to buy certain products.   

 

The following topics will be covered in this session:

  • Delimited files
  • Discovering shortcuts
  • Formulae in Excel
  • Complex Functions
  • Cell Referencing and Text Functions
  • Logical Formulae
  • Creating & Formatting Charts in Excel
  • Choosing the right type of Chart

 

We suggest that you download the dataset from the end of this page and work alongside.

 

People you will hear from in this session: 

Subject Matter Expert:
S Anand
CEO, Gramener

Gramener is one of the most prominent data analytics and visualisation companies in India. Anand, currently the CEO, has previously been the Chief Data Scientist at Gramener and has extensive experience in management consulting and equity research.

 

At certain points in the videos, we have asked Anand a few "interview" like questions. These questions are meant to provide structure to the videos and answer some common doubts.

 

$$/$$

Downloads

You can download the bank-marketing dataset here.