1.      Fundamental of Computers

·        Introduction to Computer

·        Types of Computer

·        Characteristics of Computer

·        Hardware & Software

·        Input Devices

·        Output Device

·        CPU

·        RAM & ROM

·        Storage Devices (HDD, SSD, Pen Drive)

·        Operating System

·        Windows Desktop

·        Start Menu, Taskbar & Icons

·        Files & Folders

·        Create, Copy, Move, Rename & Delete

·        Computer Ports

·        Booting Process

·        Shortcut Keys

·        Internet Basics

·        Browser

·        Search Engine

·        Email Introduction

2.     Paint

·        Paint Interface

·        New, Open & Save

·        Pencil, Brush, Erase, Fill Color, Shapes, Text Tool, Selection Tool

·        Resize, Rotate, Crop, Image Editing

3.     Notepad

·        Introduction

·        Create & Save File

·        Typing Practice

·        Cut, Copy, Paste

·        Undo & Redo

·        Find & Replace

·        Word Wrap

4.     WordPad

·        Interface

·        Create & Save Document

·        Font Formatting

·        Bold, Italic & Underline

·        Font Color

·        Paragraph Formatting, Alignment, Line Spacing

·        Insert Picture

·        Date & Time

·        Bullets

·        Page Setup, Print Preview, Print

5.     MS Word

·        MS Word Basics

·        Creating, saving, editing documents

·        Text formatting, paragraph alignment, bullets and numbering

·        MS Word Intermediate Features

·        Tables, headers/footers, page background

·        Page layout, margins, and styles

·        MS Word Advanced Tools

·        Mail merge, references, table of contents

·        Templates, collaboration, printing options

6.     MS Excel

·        Introduction to MS Excel

·        Spreadsheet basics, cell referencing, formulas

·        Data entry, formatting cells

·        Working with Formulas and Functions

·        SUM, AVERAGE, IF, COUNTIF, VLOOKUP, etc.

·        Absolute vs. relative referencing

·        Data Visualization & Charts

·        Creating and formatting charts

·        Sorting, filtering, and conditional formatting

·        Excel Advanced Tools

·        PivotTables, Data Validation, What-if analysis

·        Protection, exporting to PDF

7.     MS PowerPoint

·        Introduction to power point

·        PowerPoint Basics Creating slides, themes, and

·        Layouts Adding and formatting text and images.

·        Design and Multimedia

·        Animations, transitions, audio/video

·        Slide Master and templates.

·        Presenting and Sharing

·        Presenter view, printing handouts

·        Exporting presentations, sharing tips

8.     MS Outlook & Integration

·        Introduction to MS Outlook

·        Email setup, composing, folders

·        Calendar, tasks, and scheduling meetings

·        Outlook Productivity Tips

·        Rules, quick steps, search folders

·        Integration with Word and Excel

9.     Basic Excel Formulas

·         Introduction to Common Functions (SUM, AVERAGE, COUNT)

·         Deep Dive into More Functions (MIN, MAX, IF Statements)

10. Understanding Cell References

·         Absolute vs. Relative References in Excel Formulas

11. Conditional Formatting

·         Learn How to Highlight Key Data Points with Conditional Formatting

12. Sorting and Filtering Data

·         Efficiently Organize and Analyze Large Datasets

13. Using Excel Templates

·         How to Leverage Pre-built Templates for Quick Tasks

14. Introduction to Charts in Excel

·         Visualizing Data with Basic Charts (Bar, Pie, Line)

15. Customizing Charts

·         How to Modify and Format Charts for Better Presentation

16. Data Validation and Protection

·         Preventing Errors and Protecting Your Excel Sheets

17. Working with Multiple Sheets

·         Learn How to Link and Navigate Between Multiple Sheets

18. PivotTables The Basics

·         Introduction to PivotTables for Summarizing and Analyzing Data

19. Basic Formula

·         Formulae that Add / Subtract / Multiply / Divide

·         BODMAS / Formula Error Checking

·         The Sum Function

20. Absolute Referencing

·         Problems with Absolute / Relative Cell Referencing

·         Creating Absolute / Mixed References

21. LOOKUP Functions

·         The VLOOKUP/ HLOOKUP Functions

·         PivotTables

·         Creating, Formatting Simple PivotTables

·         Page Field in a PivotTable

·         Formatting a PivotTable

·         Creating / Modifying a PivotChart

22. Logical Functions 

·         IFs and Nested IF Functions

·         Using AND / OR / NOT Functions

·         Statistical Functions 

·         Using The SUMIF / COUNTIF Functions

·         Using The AVERAGE / COUNT / LARGER / SMALLER Functions

·         Pivot Tables – Advance

·         Adding new calculated Fields / Items

·         Changing the Summary Function

·         Consolidate Pivot table

23. LOOKUP Functions – Advance 

·         MATCH with VLOOKUP Functions

·         INDEX & MATCH Functions

·         OFFSET / INDIRECT functions

24. Logical Functions – Advance

·         If Loop and Nested IF Loop Functions

·         Using IF / ISERROR Functions

25. Chart Data Techniques 

·         The Chart Wizard

·         Chart Types

·         Adding Title / Legends / Labels

·         Printing Charts

·         Adding Data to a Chart

·         Formatting / Renaming / Deleting Data Series

·         Changing the Order of Data Series

26. Date / Time Functions

·         Using The To

·         Now & Date Functions

·         Using The Datedif / Networks / Eomonth Functions 

·         Using The Weeknum Functions

·         · Using The  Edate / Networks Intl / Weeks Intl Functions

27. Text Functions Using

·         The Mid / Search / Left / Right Functions

·         Using The Trim / Clean / Upper/ Lower Functions

·         Using The Substitute / Text Functions

·         Using The Trim / Clean / Proper / Dollar Function

28. Validations

·         Input Messages / Error Alerts / Drop-Down Lists

·         Conditional Formatting

29. Advanced Filters 

·         Extracting Records with Advanced Filter

·         Using Formulas in Criteria

30. Advanced Sorting

·         Sorting by Top to Bottom / Left to Right

·         Creating / Deleting Custom List

·         Sort by using Custom List

31. Hyper / Data Linking

·         Hyper linking data, within sheet / workbook

·         Linking & Updating links between workbooks & application

32. Math & Trigonometry Functions

·         Using SUMPRODUCT Functions

·         Using FLOOR / CEILING/ MROUND / MOD / QUOTIENT Functions

33. Summarizing Data

·         Creating Subtotals / Nested Subtotals

·         SUBTOTALS Formula

34. Outlining

·         Creating / Working with an Automatic / Manual Outline

·         Grouping / Ungrouping

35. Consolidation

·         Consolidating Data with Identical / Different Layout

·         Using Auditing Tools

·         Displaying / Removing Dependent & Precedent Arrows

·         Evaluate Formula – Step IN / Step Out

36. Custom Views

·         Creating Custom Views

·         Displaying Custom Views

·         Deleting Custom Views

37. Sharing and Protecting Workbooks

·         Sharing Workbooks & Tracking Changes

·         Protecting sheets/workbooks / Files

38. Importing & Exporting Data

·         Importing Data from Database / Text Files / Web

·         Exporting Data

·         Changing External Data Range

39. Creating Company

·         What is Tally Prime?

·         Gateway of Tally Explained

·         Create Company in Tally

·         Alter Company

·         Select Company / Change Company

·         Shut Company

·         Delete Company

40. Introduction of Accounting

·         What is Accounting

·         Golden Rules of Accounting

·         Business Transaction

·         Basic Concepts of Accounting

·         Journal Entries

·         Single Entry

·         Double Entry

·         Book Keeping

41. Creating Masters

·         28 Predefined Groups in Tally

·         How to Create Groups

·         What is Ledger

·         Create / Alter / Delete Ledger

·         Create Stock Group

·         Create Stock Category

·         Create Stock Unit

·         Create Stock Item

·         Create Godown / Location

·         Delete Company

42. Reports

·         Profit & Loss Statement

·         Balance Sheet

·         Stock Summary

·         Stock Group Summary

·         Stock Report (Location/Godown Wise)

43. Accounting Voucher Entries

·         What are Vouchers

·         What is Narration?

·         Journal Voucher

·         Purchase Voucher

·         Sales Voucher

·         Payment Voucher

·         Receipt Voucher

·         Contra Voucher

·         Debit Note

·         Credit Note

44. Inventory Vouchers

·         Purchase Order

·         Receipt Note

·         Rejection Out (Purchase Return)

·         Rejection In (Sales Return)

·         Stock Journal (Transfer & Consumption)

·         Stock Summary

·         Stock Group Summary

·         Stock Report (Location/Godown Wise)

45. Banking Transactions

·         Bank Ledger Creation

·         Cheque Book Printing

·         Cancel Cheque

·         Pass Blank Cheque

·         Bank Reconciliation

46. Advance Accounting

·         Bill by Bill

·         Multi-Currency

·         Round Off

·         Post Dated Vouchers

·         Discount Column in Invoice

·         Job Costing & Cost Centers

·         Budget Control

·         Interest Calculation

47. Advance Inventory Management

·         Memorandum Voucher

·         Optional Voucher

·         Physical Stock Voucher

·         Multiple Price Levels

·         Actual Qty & Billed Qty (Buy One Get One)

·         Zero Value Entry (Sampling)

·         Point of Sale (POS)

·         Interest Calculation

·         Product Manufacturing

48. GST (Goods and Services Tax)

·         What is GST?

·         Purchase Voucher (CGST & SGST)

·         Purchase Voucher (IGST)

·         Sales Voucher (IGST)

·         Sales Voucher (CGST & SGST)

·         GSTR-1

·         GSTR-2

·         Service GST

·         Multi GST

·         B2C

·         URD (Unregistered Dealer)

·         Debit/Credit Note

·         Manufacturing with GST

·         Capital Goods GST

·         Composite GST

·         GST Registration Process

49. Taxation

·         What is TDS?

·         TDS Deduction in Tally Prime

·         TCS on Purchase

·         TCS on Sales

50. Payroll Master

·         Employee Category

·         Employee Group

·         Employee Creation

·         Payroll Work Unit

·         Attendance / Production Type

·         Payroll Pay Heads

·         Payroll Voucher

·         Attendance Sheet Voucher

·         Employee Salary Structure

·         Salary Processing in Tally Prime

Practical Projects & Assessment

·        Real-World Project

·        Quiz + Practical Assignment

·        Final Assessment & Certification