Introduction to MS Excel

This module provides a comprehensive overview of Microsoft Excel, one of the most powerful and widely used spreadsheet applications in business and personal data management. Designed for beginners, this module will familiarize learners with the fundamental concepts and functionalities of MS Excel.

Excel - Data entry Basics

This module provides a comprehensive overview of Excel functions and operations. It covers fundamental tasks such as copying and pasting specific cell contents, moving or copying worksheets, creating or editing hyperlinks, inserting or deleting rows and columns, and setting rounding precision.

Excel - Formulas and functions

This module provides a comprehensive introduction to the powerful formulas and functions in Microsoft Excel, essential tools for business and personal data management. Designed for learners of all levels, this module will familiarize you with the fundamental operations and advanced functionalities of Excel formulas and functions.

Managing worksheets - working with multiple excelsheets

This module provides a comprehensive guide to effectively managing multiple worksheets and workbooks in Microsoft Excel. Learners will be equipped with essential techniques to organize, navigate, and personalize the worksheet environment efficiently.

Excel Tables - Managing data lists

This module offers a comprehensive exploration of Microsoft Excel’s table features, crucial for managing data lists in business and personal data management contexts. This module aims to acquaint learners with the core principles and capabilities of MS Excel tables.

Cell Referenicng, Flash Fill, Auto Fill

This module provides a comprehensive overview of Excel's essential features: cell referencing, Flash Fill, and AutoFill. Learn to leverage precise cell referencing, automate data entry and formatting with Flash Fill, and expedite repetitive tasks using AutoFill.

MIS Reporting - Charts

This module provides a comprehensive overview of visual data communication through Excel charts. Equips learners with essential techniques for creating, customizing, and leveraging charts to effectively present data insights.

Applying formulas and Functions

This module provides a comprehensive exploration of applying formulas and functions in Excel, essential for effective data analysis and manipulation. learners will gain proficiency in utilizing various types of functions, including text, logical, date/time, and database functions. 

Vlookup fundamentals

This module provides a comprehensive overview of Excel's essential VLOOKUP function, crucial for data retrieval and analysis. Learners will gain proficiency in effectively using VLOOKUP to search for and retrieve data, understand its arguments, construct accurate formulas, and troubleshoot common issues.

Data sorting, filtering and formatting

This module provides a comprehensive overview of Excel's essential data management tools—sorting, filtering, and formatting—crucial for organizing and presenting data effectively. Learners will gain proficiency in sorting data to enhance readability and analysis, using filtering techniques to focus on specific data subsets, and applying conditional formatting to visually highlight important trends and insights.