With the implementation of the National Education Policy (NEP) 2020, the educational landscape in India has seen significant reforms designed to enhance practical learning, skill development, and adaptability to the evolving needs of industry and society. This book aligns with the NEP 2020 guidelines, which emphasise the importance of equipping students with essential digital skills, particularly in widely used applications like Microsoft Excel, to prepare them for real-world business environments. This text has been specifically structured to meet the curriculum requirements set forth by Mumbai University for B.Com. Semester II students.
Microsoft Excel is a powerful tool for handling, organising, and analysing business data. This book provides a foundational understanding of Excel, starting from basic functions such as creating and formatting workbooks, adding and managing worksheets, and performing essential data entry. These preliminary chapters introduce students to Excel’s core functionalities, including inserting and removing hyperlinks, adjusting layouts, and managing rows and columns, which are fundamental to organising data effectively in business contexts.
As students progress through the book, they will explore Excel’s capabilities in data analysis, learning to apply formulas and functions to interpret data accurately and efficiently. Special emphasis is placed on practical applications of functions like SUM, AVERAGE, IF, and SUMIF, enabling students to make informed business decisions based on data insights. Additionally, the book covers methods for visualising data through tables and charts, giving students the tools to present data trends and analyses in a clear and compelling manner. Exercises and examples are designed with the Indian industry context in mind, enhancing relevance and practical applicability.
Written in a straightforward and accessible style, this book is ideal for students who are new to Excel, and it guides them step-by-step through the various tools and functions. The book is also designed to support teachers in effectively imparting Excel skills in alignment with the NEP 2020 objectives.
Contents –
1. Introduction to MS-Excel for Handling Data of Business
2. Excel Operations with Formulas and Functions for Analysing Data
