Tally

• Data entry
• Accounts maintenance
• Inventory management
• Payroll
• Statutory compliances

MS EXCEL

• Computer Basics – Hardware & Software – Generalized software.
• Introduction to MS Excel – Work books – Work sheets/Spreadsheets (Adding sheets, deleting & Renaming sheets) – Datatypes in Excel – Spreadsheet Analysis – Calculations using MS Excel – Accounting related analysis – Comparison tests – generating reports using MS Excel.
• Formatting the sheet – Explaining groups in Home Tab – Font – Clipboard – Alignment – Number – Wrap Text – Merge & Center.

• Using formulas in MS Excel.
• Excel Functions – Basic functions in Excel.
• Assignment 1- Preparing Mark list of 5 students.
• Filling series – sorting the list (Using Filter & Sort Button and using Data-sort).

• Assignment 2 – Preparation of Payroll – calculating DA, HRA, Net Salary, PF, and Gross Pay.
• Filter – Advanced Filter.
• Types of Charts- Preparing charts using the table prepared.

• Conditional formatting.
• Inserting Headers and Footers, Text boxes, Word Art and Comments.
• Assignment 3 – Preparation of Data table (What if Analysis).
• Preparing charts using the Data table prepared.

• Page Layout tab – Margins, size, Orientation and Print Area.
• Formulas tab – Logical functions.
• Mathematical and Lookup functions

• Data Validation.
• Data Consolidation.
• Introduction to MS Word.
• Preparing word documents – inserting images, Word Art, Header & Footer, Tables and Text Boxes.
• Drafting Letters in MS Word.
• Macros