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

Delivery and Receipt Note

Stock Rejection

Debit and Credit Note

Memorandum Vouchers

Basic Payroll

Advance Payment

Trial balance and Balance Sheet creation

POS for single-mode payment

How to Page Setup

Create Basic Shapes

Multi-Page Corel document

Corel Templates

Rulers, Grids and Guidelines

Shortcuts of Basic Commands

Freehand Tool create custom Shapes & Logos

Shape Tool, Connector, Bezier, Pen, Artistic Media, Polyline, Interactive Connector, Dimensions more tools for drawing in Freehand Tool

Blend Options Blend, Contour, Distortion, Drop Shadow, Envelope, Extrude, Transparency

Color Palette, Effects and Gradient

Objects Lock, Unlock, Grouping and Ungrouping

Weld, Trim and Intersect, Place inside Container

Text, Paragraph, Fix text to Path

Images using Powerclip

Bitmaps convert color mode

Why Typing Skills are important

Learn Keyboard letters from A to Z

25 Learning Lessons

MS WORD- Format documents efficiently in Word using Microsoft Word Styles

MS WORD- Create dynamic layouts using various techniques

MS EXCEL- Create and manage Spreadsheet Layouts

MS EXCEL- Increase your efficiency by creating and using important Excel shortcuts

COREL DRAW- Create Professional Business Card Designing

COREL DRAW- Design the shapes with the Pen Tool