Module 1

Introduction: What is Computer, Concepts of Data and Information, Data, Information, Processing, limitations of computers

Characteristics of Computer: Speed, Accuracy, Storage, Diligence, Versatility, Automatic, No I.Q, No Feelings. 

Evolution of Computer: Abacus, Napier's Bone, Slide Rule, Pascal's Machine, Leibnitz’s Calculating Machine, Charles Babbage, Difference Engine, Analytical Engine, SOME WELL-KNOWN EARLY COMPUTER.

Generations of Computer:

First Generation (1940 to 1956): Using Vacuum Tubes Hardware Technology.

Second Generation (1956 to 1963): Using Transistors Hardware Technology. 

Third Generation (1964 to 1971): Using Integrated Circuits Hardware Technology.

Fourth Generation (1971 to present): Using Microprocessors Hardware Technology.

Fifth Generation (Present and Next): Using Artificial Intelligence.

Classification of Computer: Classification of computers based on working principle, Classification of computers based on size and type.

Computer system: Hardware, Software, Live-Ware, Firmware. 

BASIC ORGANIZATION OF COMPUTER: Inputting, Outputting, Storing, Processing, Controlling.

Input device: Keyboard, Mouse, Joystick, Light pen, Track ball, Scanner, Digitizer, Microphone, Magnetic Ink Character Reader, Optical Character Reader, Bar Code Readers, Optical Mark Reader.

Output device: Monitors, Cathode-Ray Tube (CRT) Monitor, Flat-Panel Display Monitor, Printers, Impact Printers, Character Printers, Dot Matrix Printer, Advantages, Daisy Wheel, Line Printers, Drum Printer, Chain Printer, Non-impact Printers, Laser Printers, inkjet/Deskjet Printers. 

Central Processing Unit (CPU): Arithmetic Logic Unit, Control Unit.

Hardware: Input devices, Output devices, Secondary storage devices, Internal components.

Software: System Software, Application Software.

Number system: Decimal Number System, Binary Number System, Octal number system, Hexa Decimal number system.

    Important Abbreviations & their Short notes

Introduction Operating Systems: Definition CUI & GUI, what is system, what is Prompt/DOS prompt.

Basic DOS Command: Internal & External Command, Comparison of DOS and Windows, File/Directory Manipulations, copying of files and Disks, Delete/Undelete, Formatting a floppy.

Introduction of Windows: What is an operating system and basics of Windows, my computer Icon, The Recycle Bin, Status Bar, Start and Menu, Menu selection. 

Windows Setting: Control Panels, Wallpaper and Screen savers, setting the data and Sound, Concept of menu Using Help.

Advance Windows: Using right Button of the Mouse, Creating Shortcuts, Basics of Window Setup, Notepad, Window Accessories.

Introduction & Features: Table of Contants, Opening MS Word, Document information & properties, entering text & move around, Save, opening, closing documents, Content help using function key & using help icon.

Editing Documents: Insert and add text, replace text, select text & using selection bar & keyboard, Move, copy, zoom in-out, special symbol, undo changes.

Formatting Text: Setting text fonts, text decoration, change case, text color, alignment, bullet, numbering, line spacing and indentation.

Working with table: Create a table, row and column definition, Move, resize margin, split, formula, border and shader. 

Advance operating: Use templates, Graphic, auto correction, auto formatting, Table of content, Preview, printing, Email, Translate, compare, security, set watermark.

Introduction & Feature: Calculation or Computation Capabilities, Pivot Table % A Micro Programing Language Called Visual Basic for Application (VBA), Sparkline & Slicers. 

Programs Fundamentals: Starting Excels, New Workbook, Command shortcut, Printing Worksheet, Using Helf, Editing Worksheet, Formating text & Value, Cell Alignment, Conditional Formatting & Theme, Rules finding and                                                                          replacing.

Creating & working with chart: Inserting Chart, Editing, Sdding, Changing Chart Data, Layout & Style, Chart Lable & chart Gridlines, Chart Templates & Spark lines.

Managing Workbook: Using workbook view, selecting and switching between worksheet, Splitting & Freezing a window, Creating Header & Footer.

More Function & Formula: Multiple Operation , Editing Function, Using Logical , Financial , Numerical, Database, V Lookup, H Lookup Function.

Working with Data Range: Shorting Logical Sequence, Filtering Data, Auto Filtering & Advance Filtering, Shorting by One Column or Colors or Icon.

Working with Table: Creating a Table, Total Row & Total Column, Duplicate Row of Date, Using Data validation, Conditional Formatting.

Working with Pivot Table: Creating a Pivot Table, Changing a Pivot Table's Calculation, Filltering & Shorting a Pivot Table, Pivot Table Layout, Uploting, Grouping, Formatting .

Analyzing Data & Review: Creating Scenarios Report, Working With Data Table, Using Goal seek, Using Sub Total, Consolidate Data Using Formula. Inserting Hyperlink, Importing Data from an Access Database or Text File, Importing Data From The Web & Other Sources.

Working with Macros & Review: Recording, Playing, Deleting, Editing, Adding, Macro, Inserting Copied Code In a Micro, Using the if.....Then....Else Statement, Customizing Excel. 

Customizing & Security: Quick Access Toolbar & Ribbon, Using Auto Correct, number Format, Protect Workbook, Worksheet. 

Module 2

Topics to be covered:

• Ledger Entry
• Stock Item Entry
• GST Stock Item Creation
• Journal Voucher Entry With GST Voucher Entry
• Purchase Voucher With GST Entry With Discount.
• Sales Voucher With GST Entry
• Payment Voucher Entry GST With
• Receipt Voucher With GST
• Contra Voucher With GST
• Adjustment Entry with GST
• Purchase Return and sales Return with GST
• Purchase Order and Sales Order with GST
• Create Challan/Bill For Delivery  Goods Challan Entry with GST
• Rejection Inward and rejection Outward Note in Tally with GST
• Purchase Order(Supplier) and sales order rejection (Coustomer) Entry with GST

                   Tally Part 36 Tally GSTR 1 Full Details with How to upload GST Portal

                    Import and Export entry.

• GSTR1/GSTR2/GSTR3...........Entry
• Cheque Bounce Entry Tally
• TDS Entry in Tally
• Petty Cashbook Entry in tally
• E Way Bill Generate with GST in Under State Or Other State.
• ITC GST