Course Code: COM5FS112 (1)

Course Title: ADVANCED SPREADSHEET APPLICATIONS IN BUSINESS

Type of Course: SKILL ENHANCEMENT COURSES (SEC)

Semester: V

Credit: 3

Course Outcomes (CO):

CO1: Gain insight into the characteristics of data analysis and management features.

CO2: Apply statistical andfinancial analysis tools in spreadsheet to make informed business decisions.

CO3: Create and implement advanced formulas, lookup functions, and macros for streamlined data manipulation and task automation.

CO4: Apply acquired skills in spreadsheet to diverse business contexts,ensuring relevance and effectiveness in various industries and scenarios.

Module I

Introduction to Spreadsheet Applications

1 Introduction to spreadsheet applications. 

2 Common Spreadsheet Applications 

3 Basics of spreadsheet interface and functions. 

4 Navigating the interface 

5 Key features and capabilities

Module II

Data Entry and Formatting with Spreadsheets

6 Efficient data entry techniques 

7 Formatting cells, rows, and columns 

8 Introduction to cell referencing and formulas 

9 Creating and managing tables 

10 Generating charts and graphs 

11 Basic formulas and functions for business applications

Module III

Advanced Functions and Automation

12 Advanced Formulas - Nested functions and complex formulas 

13 Logical and Lookup functions (VLOOKUP, XLOOKUP,HLOOKUP) 

14 Understanding IF, AND, OR, TEXT, COUNT, COUNTIF functions 

15 Pivot Tables and Pivot Charts - Data summarization 

16 Dynamic reporting with Pivot Charts 

17 Macros and Automation - Introduction to macros 

18 Creating simple automation scripts (customers, brands, sales, credit data)

Module IV

Advanced Financial with Spreadsheets 

19 Statistical Analysis - Descriptive statistics: mean, median, mode 

20 Performing simple inferential statistics: t-tests, correlation 

21 Data visualization techniques - histograms and box plots 

22 Application of Financial ratios and key performance indicators

Module V

Open Ended Module 

1. Working on group projects to solve specific business problems or optimize business processes using spreadsheet tools..

2. Calculating key financial metrics such as net present value (NPV), internal rate of return (IRR), and return on investment (ROI)..

3. Creating charts and graphs to visualize data trends, such as sales trends over time or market share comparisons.

4. Calculate financial ratios a company and make interpretation

References

1.Excel 2019 Bible Paperback– 4 December 2018 by Michael Alexander (Author), Richard Kusleika (Author), John Walkenbach (Author)

2. Excel for Beginners (Excel Essentials Book 1) Kindle Edition by M.L. Humphrey (Author)