Scribd
Upload
9 views2 pages

LSVA602-Data Analysis Using Excel

The document outlines the curriculum for the MBA course LSVA602: Data Analysis Using Excel, which aims to provide students with a foundational understanding of Excel for business data analysis. It covers various topics including Excel functionalities, creating formulas, data analysis techniques, and the use of PivotTables. Upon completion, students will be equipped to apply Excel for data-driven decision-making and predictive analysis.

Uploaded by

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

LSVA602-Data Analysis Using Excel

The document outlines the curriculum for the MBA course LSVA602: Data Analysis Using Excel, which aims to provide students with a foundational understanding of Excel for business data analysis. It covers various topics including Excel functionalities, creating formulas, data analysis techniques, and the use of PivotTables. Upon completion, students will be equipped to apply Excel for data-driven decision-making and predictive analysis.

Uploaded by

gaganpanchal2002
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Course Curriculum

[Master of Business Administration (MBA)]

LSVA602: Data Analysis Using Excel


Introduction The use of Excel is widespread in the industry. It is a very powerful data analysis
tool and almost all big and small businesses use Excel in their day-to-day functioning. This is an
introductory course in the use of Excel and is designed to give you a working knowledge of Excel
with the aim of getting to use it for more advance topics in Business Statistics later.

Objectives:

The objective of the course is to help students integrate their learning from functional
areas, decision making process in an organization and role of data analysis using Excel

Credits: 2 Semester II L-T-P: 2-0-0

Units Teaching
Content
Hours
Introduction to Excel About Excel & Microsoft, Uses of
Excel, Excel software, Spreadsheet window pane, Title Bar, 6
Menu Bar, Standard Toolbar, Formatting Toolbar, the
I Ribbon, File Tab and Backstage View,
Formula Bar, Workbook Window, Status Bar, Task Pane,
Workbook & sheets

Columns & Rows


Selecting Columns & Rows, Changing Column Width & 6
Row Height, Autofitting Columns &
Rows, Hiding/Unhiding Columns & Rows, Inserting &
II Deleting Columns & Rows, Cell, Address
of a cell, Components of a cell – Format, value, formula,
Use of paste and paste special
Functionality Using Ranges 6
Using Ranges, Selecting Ranges, Entering Information into a
III Range, Using AutoFill

Creating Formulas. Using Formulas, Formula Functions – 6


Sum, Average, if, Count, max, min, Proper, Upper,
IV
Lower, Using AutoSum,

Data Analysis Sorting, Filter, Text to Column, Data


Validation 6
Creating PivotTables, manipulating a PivotTable, Using the
PivotTable Toolbar, Changing Data
V
Field, Properties, displaying a PivotChart, Setting PivotTable
Options, Adding Subtotals to
PivotTables
* Provision for presentations / assignments / case analysis in additional sessions
** 1 Session = 60 Minutes
Course Curriculum
[Master of Business Administration (MBA)]

Course Outcomes: After completion of course, the student will be able to:

✵ Understand the fundamentals of Microsoft Excel and its role in business


data analysis.
✵ Apply basic and advanced Excel functions for data cleaning,
transformation, and manipulation.
✵ Perform descriptive statistical analysis using Excel tools (e.g., pivot
tables, charts, summary statistics).
✵ Use Excel to conduct predictive analysis including regression,
forecasting, and trend analysis.
✵ Solve business problems through data-driven decision-making using
scenario analysis and solver tools.

Reference Books:
• Winston, Wayne L. – Microsoft Excel 2019 Data Analysis and Business
Modeling (Microsoft Press)
• Swayne, David F., et al. – The Excel Data Analysis Handbook (Oxford
University Press).
• Paul McFedries – Excel Data Analysis for Dummies (Wiley)
• Michael Alexander & John Walkenbach – Excel Dashboards and Reports
(Wiley)

You might also like