MS WORD

» Introduction to MS Word

» Document Creation & Editing

» Formatting (Font, Paragraph, Alignment)

» Tables & Borders

» Page Setup & Printing

» Header, Footer & Page Number

» Mail Merge

» Resume & Letter Making

MS EXCEL (BASIC)

» Introduction to Excel

» Rows, Columns & Cells

» Data Entry & Formatting

» Basic Formulas

» SUM, AVERAGE, MIN, MAX

» Sort & Filter

» Charts & Tables

MS POWERPOINT

» Create Presentation

» Slide Design & Layout

» Insert Pictures, Tables & Shapes

» Animation & Transition

» Slide Show & Presentation

MS ACCESS (Optional)

» Database Introduction

» Tables, Forms & Reports

» Basic Queries

OUTLOOK

» Email Management & Compose

» Inbox & Folder Management

» Calendar

» Signature

ADVANCED EXCEL

» Advanced Formulas & Functions

» IF, AND, OR, IFERROR

» VLOOKUP, HLOOKUP, XLOOKUP

» INDEX & MATCH

» SUMIF, SUMIFS, COUNTIF, COUNTIFS

» Conditional Formatting

» Data Validation

» Drop Down List

» Advanced Sorting & Filtering

» Pivot Table & Pivot Chart

» Data Cleaning

» Text Functions

» Date & Time Functions

» What-If Analysis

» Dashboard Creation

» MIS Reports

» Practical Office Reports

BASIC TALLY

» Golden Rules of Accounting

» Debit & Credit

» Creation of Company

» Create Groups & Ledgers

» Accounting Vouchers

» Contra, Payment, Receipt, Journal Voucher

» Sales & Purchase Entry

» Debit Note & Credit Note

» Cash Book & Bank Book

» Trial Balance

» Profit & Loss Account

» Balance Sheet

ADVANCED TALLY

» GST Configuration

» GST Sales & Purchase Entries

» CGST, SGST & IGST

» GST Tax Calculation & Reports

» GSTR-1 & GSTR-3B Reports

» Inventory Management

» Stock Groups, Categories, Items & Units

» Godown Management

» Purchase Order & Sales Order

» Bank Reconciliation (BRS)

» Cost Centre & Cost Category

» Payroll Management

» TDS & TCS (Introduction)

» Outstanding Reports

» Financial Reports

» Data Backup & Restore