Objectives

The purpose for studying Open Office is to prepare ourself working with computer doing the office works like prepare official document, put a table on it, make printout, send bulk printout using mail merge, making calculation on calc etc...

This package includes the following applications like Operating System,Notepad,Wordpad,Control panel,Basic & Essential,Office Packages,Tally GST 1&2 etc

Eligibility

Students with their academic qualification from 8th on wards are eligible to learn this course, who are already having system knowledge or not.

Target Audiences :-

School Students from 8th onwards 11th Mpcc - Maths, Physics, Science , Computer Science.
11th ACEC- Accounts, Commerce, Economics, Computer Science.
12th Mpcc - Maths, Physics, Science , Computer Science.
12th ACEC- Accounts, Commerce, Economics, Computer Science.
BCA - Bachelor of Computer Application.
B.Sc -CS Bachelor of Science. Computer Science.
MCA - Master of Computer Application.
M.Sc - CS Master of Science.
B.E - All Branches.
M.E - All Branches.

DOA Course Syllabus

Basics

Windows OS
Control Panel
Wordpad
Notepad
Paint
Fingering

Home

Home Options
Formatting
Elements
Alignments
Sorting
Indentation
Pre-defined Headings
Styles

Edit

Edit
Clipboard
Find Text and Options
Format Painter

Insert

Insert - Pages
Table
Picture
Clip Art
Shapes
SmartArt
Chart
Screenshot
Links
Header & Footer
Textbox
Quick Parts
Word Art
Drop Cap
Equation & Symbol.

Page Layout

Page Layout - Themes
Margins
Orientation
Size
Columns
Page Break
Line Numbers & Hyphenation.

References

References - Table of Content.
Footnote & End Note.
Citations & Bibliography .
Captions
Index & Table of Authorities.

Mail Merge

Mailings :- Write & Insert Fields
Preview Results.

Review

Review - Proofing .
Language
Comments
Tracking
Changes & Compare.

Excel - Home

Home - Formatting Elements
Alignments.
Sorting
Indentation
Pre-defined Headings.
Styles.

Edit

Editing.- Editing Options
Find Options
Links
Plug-in
Objects

Insert

Insert :- Functions (Text,Date & Time, Numerical)
Charts
Links
Pictures

Format

Format :- Cells
Rows
Columns
Sheet
Conditional Formatting
Graphics

Tool,Data,Window

Tools & it's Menu Items
Data & it's Menu Items
Window & it's Menu Items

PowerPoint Presentations

Home
Clipboard
Slides
Font
Paragraph
Drawing
Editing

Insert

Insert
Tables
Images
Illustrations
Links
Text
Symbols
Media.

Design

Design
Page Setup
Themes
Background

Transitions & Animation

Transitions
Preview
Transition to this slide
Timing
Animations.
Animation, Advanced Animation, Timing

Slideshow

Slide Show :- Start Slide Show
Set up
Monitors.

Review

Review :- Proofing
Language
Comments
Compare

MS-Access

Databases
RDBMS
SQL Commands
Table , Constraints,Attributes , Template Wizard
Joins

Essentials

Mailing & Attachments
Print
Scan
Copy

Introduction to Accounts

Introduction
Branches of Accounting
Financial Accounting
Cost Accounting
Management Accounting
Types of Accounts
Real Accounts.
Personal Accounts.
Nominal Accounts.
Accounting Principles or concepts
Rules of Accounting

Accounting Master

Journal.
Ledgers
Groups
Vouchers
Assets.
Liabilities.
Capital.
Revenue
Expenses.

Terms Used

Accounting
Business Transaction
Purchase
Sales
Purchase return or Rejection in or Outward invoice
Sales return or Rejection out or Inward invoice
Assets
1.Fixed Assets
2. Current Assets
Liabilities
Capital
Debtors
Creditor
Debit
Credit
Drawings
Receipts
Account
Ledger
Journal entries
Trial balance
Profit
Profit and Loss Account
Balance Sheet
Sundry Debtors
Sundry Creditors
Entity

Types of accounts

Personal account
Real Account
Nominal account

Mode of Accounting

Journals and Ledger
Posting
Accounting Period
Financial Statements
Trail balance
Profit and Loss Account
Balance sheet

Golden Rule of Accounting

Real Account  
Debit what comes into the business
Credit what goes out from the business
Personal Account
Debit the receiver
Credit the giver
Nominal Account
Debit the expense or loss of the business
Credit the income or gain of the business
Getting Started with Tally Prime

Company Features
Configuration
Getting functions with Tally.Prime
Creation / setting up of Company in Tally.Prime

Inventory Masters

Stock Groups
Multiple Stock Groups
Stock Categories
Multiple Stock Categories
Units of Measure
Stock Items

Contra Banking

Bank Accounts.
Bank OD Accounts.
Bank OCC Accounts.

Vouchers in Tally

Introduction
Types of Vouchers
Accounting Vouchers
Inventory Vouchers
Invoicing
Receipt Voucher
Payment Voucher
Sales
Purchase
Contra

Advanced Accounting

Bill-wise details
Cost centers and Cost Categories
Interest calculations
Budget and controls
Scenario management
Bank Reconciliation
Group Creation.
Voucher Creation

Order Processing

Order Processing
Purchase order
Sales order
Reorder Levels
Batch-wise details
Bill of Materials
Different Actual and Billed Quantities
POS

Price List

Retail Sale.
Whole Sale.
Export Sale.

Payroll

Employee Category
Employee Creation
Salary Define
Employee
Attendance Register
Pay Heads Creation Salary Report

Non-Accounting Vouchers

Memorandum Voucher
Reversing Journal Voucher
Optional
Post Dated

Method of Adjustment

New Reference
Against Reference
On Advance
On Account

Technology Advancement

Backup and restore
Split company data
Import and export of data
Consolidation of Accounts
ODBC connectivity
Filter
Regional languages

Taxation in India

Taxation in India
Concept of Sales Tax
Concept of Service Tax
TDS
Income Tax
Excise Duty
Customs Duty
Fridge Benefit tax
GST

Getting Reports

Profit & Loss Account
Balance Sheet
Exception Reports
Statutory Reports
Payroll Reports
Trail balance
Day Book
Stock Summary
Outstanding Statement
Functional keys

FAQ

  • Time Schedule for Office Regular Training?

  • Class Schdule & Class Mode

  • About Faculty and her experience ?

  • Regular Courses or Online ?

  • What about post courses support ?

  • What about course Subject Materials Assistance ?

  • How to enroll ?

  • How to pay Course Fees ?

    View Details
  • Placement Support

    View Details
Enroll the course

Reviews

Provide Your Rating
Quality
Outstanding
Puncuality
Outstanding
Quality
Outstanding
Your Feedback
Nirmala

Instead of not knowing the Tamil language , the trainer here make me understand the open office concept very well. Now i am fulfilled with the skill of the subjects . Thanks all of them.

Selvi

I studied this openoffice as one of the subject of my course DOA . This course is well suited for the beginners who are start their career in the IT journey.