Basic Accounting

MS-Excel

Introduction to Excel, Basic Calculations, Basic Functions, Text Functions, Date and Time Functions, IF Condition, Lookup Functions, Mathematical Functions, PMT Functions, Conditional Formatting, Cell & Table Formats, Insertion and Deletion, Sorting and Filtering, Pivot Table and Pivot Chart, Slicer & Timeline, Cell Name Management, Formula Auditing, Calculations, Import & Export Data, Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate, What If Analysis - Scenario Manager, Goal Seek & Data Table, Group, Ungroup & Subtotal, Sheet & File Protection, Freeze Panes, Macros

Tally Prime

Create a New Company, Groups and Ledgers, Accounting Ledgers, Payment and Receipt Voucher, Contra Voucher, Accounting Project, Sales, Purchase, Sundry Debtors & Sundry Creditor Ledgers, Inventory Making - Groups, Categories, Units, Items, Godowns in Tally Prime, Accounting with Inventory Project, Journal Voucher, Stock Journal, Order Processing System, Credit Note & Debit Note, TDS, GST, Interest Calculation, Cost Center, POS - Point of Sale, Price List, Budget, Payroll, Physical Stock