Scribd
Upload
36 views2 pages

Data Analytics Using Excel - I

The document outlines a course on Data Analytics using Excel for BBA students, focusing on fundamental concepts, key tools, and statistical applications. It includes learning objectives, course outcomes, and detailed units covering Excel functionalities, logical functions, and statistical methods. A capstone project is also included to apply the knowledge gained throughout the course.

Uploaded by

birmloyal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
36 views2 pages

Data Analytics Using Excel - I

The document outlines a course on Data Analytics using Excel for BBA students, focusing on fundamental concepts, key tools, and statistical applications. It includes learning objectives, course outcomes, and detailed units covering Excel functionalities, logical functions, and statistical methods. A capstone project is also included to apply the knowledge gained throughout the course.

Uploaded by

birmloyal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Specialisation Data Analytics Semester IInd

Name of subject BBA S3- 201 Data Analytics using Excel - I

Credits 3 Duration 30

Learning Objectives

1. To Understand the fundamentals of Data Analytics

2. To Identify key Data Analytics tools and models.

3. To Acquire knowledge about Statistical and Logical application.

Course Outcome: After completing the course, student will be able to

Explain key Analytical tools and models, including those with logical
CO S3201.1
requirements.

CO S3201.2 Assess the impact of IF Functions in deriving the much needed results.

Conclude and implement Analytical strategies to enhance decision making


CO S3201.3
capacity.

CO S3201.4 Evaluate the effectiveness of alternative scenarios for a chosen capstone project

Pre-Requisites if Any: Basic Understanding of MS-EXCEL

Unit 1: Introduction to MS EXCEL: Students would be able to understand the difference


between workbook and work sheet along with merging and unmerging of cells. Half
understanding of the subject takes places the moment a student understands the different
elements present in menu and ribbon. Entering and revising data; working with the copy
paste function. Managing data using flash fill; Finding and replacing data

Unit 2: Referencing and Logical Functions: Relative and Absolute Referencing, Concatenate;
Len, If-AND-OR function, VLOOKUP, HLOOKUP, MATCH, INDEX, NESTED IF Understanding
the logic behind the working of excel is the core of the subject. If function along with Match, Index
and V-Lookup adds to the beauty of data understanding.
Unit 3: Statistical & Mathematical Functions: Sum; sumif; sumifs, count; counta, countif;
countifs, subtotal; sumproduct; sumx2; sumxpy2; sumx2my2; Average, Stdev.p; Stedev.S, Quartiles,
Covariance, Correl are few areas which needs to be explored along with Statistics which is one area
which needs to be understood by heart. Decision making is wholly based upon the understanding of
the subject Statistics along with Mathematics. Hands on of this subject will built the platform for
advance learning. Following topics will be covered in this area to make the subject more fruitful with
zero error. Some of the important functions will be Creating Name Ranges, Indexing and Name
Manager; new functions: MAXIFS, MINIFS, XLOOKUP.

Capstone project: Build upon knowledge gained through the earlier hands-on exercises and
apply it to a final capstone project that pulls together the wide range of topics the program
covers. Calculation of EMI and Matching the value with HDFC Home loan calculator.

Reference Book and Articles


Title Author
Data Analysis and Business Modelling,
Excel 2019 Wayne L Winston. PHI (2019)

Microsoft Excel 2019 Bible John Walkenbach. Wiley.

You might also like