Introduction to Excel

Saving Workbook and Adding / Deleting Renaming Worksheets<

Basic calculations : Sum, Product, Factorial, Square Root, Average, Max, Min, Mode & Median

Data Sorting

Format Painter

Text to Column, Text Formatting

Filter, Rand Function

Average

Count

How to insert and delete a cell, row and column from a worksheet

Round

Date & Time Functions like Date, Day, Month, Year, Today, Hour, Minute, Second

Introduction to PowerPoint

Create a presentation

Slide Setup

Save a presentation

Choose a slide design

Text Formatting in Slides (Change in font, change in font size and change in text color)

Text Alignment in Slides

Background formatting in slides

Working with Text box

Insert Pictures

Draw a shapes

Add Symbols

Working with Tables

Change Text Direction

Insert a Smartart & Chart

Text formatting through WordArt

Different types of Slide Layout

Introduction to Accounting

Accounting Concepts & Objectives

Advantages & Limitations

Types of accounting information

Uses of accounting information and their needs

Qualitative Characteristics of Accounting Information

Role of accounting in Business

Basic Accounting Terms- Business Transaction, Capital, Drawings

Liabilities (Non-Current and Current)

Assets (Non-Current and Current)

Fixed Assets (Tangible and Intangible)

Expenditure (Capital and Revenue)

Expense, Income, Profit, Gain, Loss, Purchase, Sales

Goods, Stock, Debtor, Creditor, Voucher, Discount (Trade discount and Cash Discount)

Recording of Business Transactions

Voucher and Transactions: Source documents and Vouchers, Preparation of Vouchers

Accounting Equations

Rules of Debit and Credit

Recording of Transaction: Books of Original Entry-Journal

Ledger Format, posting from journal and subsidiary books, Balancing of accounts

Preparation of Trial Balance, Trading A/c, Profit & Loss A/c & Balance Sheet

Introduction of Tally Prime

Overview of Tally Prime

Company Creation

Work with Ledger and Groups

Maintaining Day-Book entries

Inventory Management

Maintaining Stocks

Creation of Purchase and Sales Bill

Maintaining Bill-wise details

Cost Center and Cost Category

Bank Book

Debit and Credit Note

Memorandum Vouchers

Basic Payroll

Advance Payment

Trial Balance, Trading & P/L and Balance Sheet

Point of Sale (POS)