COURSE DETAILS :
ACCOUNTANCY ADD-ON MODULES
MS Excel for Accounts
Master the most essential tool for every accountant. This module helps students build strong practical skills in MS Excel, enabling them to work faster, analyse better, and handle real-world accounting data with confidence.
📘 Module 1: Formulas
Learn the core formulas used in accounting and finance.
Students learn:
SUM, AVERAGE, COUNT functions
IF, AND, OR logical formulas
Lookup formulas (VLOOKUP, HLOOKUP, XLOOKUP)
Date & text functions
Error handling formulas
📗 Module 2: Pivot Tables
A powerful tool for quick data summaries and insights.
Students learn:
Creating and formatting Pivot Tables
Sorting, filtering & grouping data
Pivot Charts
Real-life accounting use cases (sales summary, expense tracking, etc.)
📙 Module 3: Data Analysis
Transform raw data into meaningful information.
Students learn:
📘 Module 4: Financial Models (Basics)
An introduction to how Excel is used in finance.
Students learn:
Building simple financial models
Revenue & expense forecasting
Break-even analysis
Profitability scenarios
Linking sheets and dynamic formulas
Why Excel Skills Are Essential for Students
Required in all commerce, finance & management careers
Makes accounting concepts easier to understand
Builds job-ready practical skills
Helps in projects, internships & higher studies