Category: Office Suites and Tools | Computerised Accounting & Taxation
| Medium of instruction: | English |
Diploma Office Automation
We at Aonlinetraining offer a Diploma in Office Automation, this course includes Microsoft Word, Excel, Powerpoint 2007 & Tally Accounting Software.
MS Word 2007
Introduction MS Word 2007:
Office Word 2007 is a powerful authoring program that gives you the ability to create and share documents by combining a comprehensive set of writing tools with the easy-to-use Microsoft Office Fluent user interface.
We offer online tutorials for MS Word 2007, the online tutorials covers all the topics from the basics to the advance in MS Word 2007 have a look at the course content for ms word 2007.
Features of Word 2007:
a) SmartArt diagrams and a new charting engine
b) Live word count
c) Typographic capabilities
d) Citation Manager and Reference Builder
e) Spend more time writing, less time formatting.
f) Add frequently used content to your documents with just a few clicks.
g) Communicate more effectively with high-impact graphics.
h) Quickly apply a new look and feel to your documents.
Office Word 2007 is a powerful authoring program that gives you the ability to create and share documents by combining a comprehensive set of writing tools with the easy-to-use Microsoft Office Fluent user interface.
Course Contents for Word 2007
Free Trial Session Is Limited To Phase I Only
PHASE - I in MS Word 2007
in MS
word 2003 Training Microsoft Office Online
-
How to open a new document in Word 2007
-
How to find a word
-
How to replace a word
-
How to save a file
-
How to close a file
-
How to open an existing file
-
How to use cut and paste
-
How to use copy and paste
-
How to select the whole text
-
Overview home tab
-
How to clear formats
-
How to go to different views
-
Overview Insert tab
-
How to exit from word
PHASE 2 (Online Tutorials for MS Word 2007)
-
Work with insert option
-
Cover page
-
Blank page
-
Page break
-
Insert Table
-
Insert excel sheet
-
Insert Pictures from folders
-
Insert clip-art
-
Insert shapes
-
Insert smart art
-
Insert chart
-
Use of hyperlink
-
Bookmark
-
Header and Footer Text box
-
Word art
-
Drop cap
-
Insert object and symbols
PHASE 3 (E-Learning courses in MS Word 2007)
-
Working in page layout
-
Set up themes
-
Color themes
-
Text themes
-
Page set up
-
Use of columns
-
Watermarks
-
Page Color
-
Page border
PHASE 4 (Ms Word 2007 Training)
-
Work in references tab
-
Insert foot note
-
Insert end note
-
Insert next note
-
Bibliography
-
Insert caption
PHASE 5 (Microsoft Office 2007, Word 2007)
-
Work in review tab
-
Spelling and grammar
-
Translate
-
Thesaurus
-
Comments
-
Protect document
PHASE 6 (Online Tutorials for MS Word 2007)
-
Work in view window
-
Split
-
Arrange all
-
Macros
-
Zoom
-
Show\hide items
-
Document views
MS Excel 2007
Introduction to MS Excel 2007:
Excel 2007 is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.
From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.
In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.
Applications for MS Excel 2007:
• Widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others, Microsoft Excel has become a staple of end users and business professionals.
• The beauty of Excel is that it can be used as a receiver of workplace or business data, or as a calculator, a decision support tool, a data converter or even a display spreadsheet for information interpretation. Excel can create a chart or graph, operate in conjunction with Mail Merge functions, import data from the Internet, create a concept map and sequentially rank information by importance.
Course Contents
Free Trial Session Is Limited To Phase I Only
Module 1: Getting Started with Excel 2007
-
Understanding the Excel screen
-
Navigating in a spreadsheet
-
Understanding worksheets, columns, rows and cells
-
Saving, opening, and closing workbooks
Module 2: Formatting a Spreadsheet in Excel 2007
-
Changing column widths and row heights
-
Changing alignment of cells
-
Undoing and redoing actions
-
Formatting numbers
-
Clearing formats
-
Applying borders to cells
-
Merging cells
Module 3: Formulas and Functions in Excel 2007
-
Entering formulas
-
Copying data and formulas
-
Using AutoSum
-
Understanding functions
-
Using simple aggregate functions (Sum, Count, Average, Min, Max)
-
Copying formulas
-
Types of cell referencing: relative and absolute
-
Applying conditions in a formula (The IF function)
-
Working with ranges
Module 4: Editing Feature in Excel 2007
-
Using cut , copy, and paste operations
-
Using paste special with values
-
Selection techniques
-
Navigation techniques
Module 5: Working with Large Worksheet in Excel 2007
-
Freezing and unfreezing panes
-
Splitting windows
-
Inserting page breaks for printing
Module 6: Working with Charts in Excel 2007
-
Creating charts using Chart Wizard
-
Creating different types of charts
-
Including titles and values in charts
-
Formatting of charts
Module 7: Previewing and Printing in Excel 2007
-
Previewing worksheets
-
Page setup
-
Printing of worksheets in multiple pages
-
Repeating rows and columns for multiple pages
-
Printing multiple worksheets
Module 8: Simple Database Operations in Excel 2007
-
Sorting tables
-
Filtering data with auto filter
-
Generating subtotal reports
-
Creating pivot tables
-
Referring data from other worksheets
Ms PowerPoint 2007
Introduction to MS PowerPoint 2007:
Microsoft Office PowerPoint 2007 enables users to quickly create high-impact, dynamic presentations, while integrating workflow and ways to easily share information. From the Microsoft Office Fluent user interface to the new graphics and formatting capabilities, Office PowerPoint 2007 puts the control in your hands to create great-looking presentations.
Key Features
a) Get better results faster with the Office Fluent user interface.
b) Create powerful, dynamic SmartArt diagrams.
c) Create presentations quickly and easily by re-using custom layouts
d) Apply a consistent look and feel in one click
e) Dramatically modify shapes, text, and graphics with new tools and effects
Applications for Ms Powerpoint 2007:
• With Microsoft Powerpoint you can create Company Presentations and Profiles
Course Content for MS Powerpoint 2007
Free Trial Session Is Limited To Phase I Only
PHASE - I (Online courses for Powerpoint 2007)
1) INTRODUCTION
-
To Start the Program
-
What is PowerPoint
-
Parts of PowerPoint window
-
Overview of Menu bar
2) FILE MENU (Powerpoint 2007 Online courses)
-
New auto content wizard
-
New blank presentation
-
To Save the File
-
Save As
-
Open
-
Close
-
Exit
3) EDIT MENU (Powerpoint 2007 Online Tutorials)
-
Cut & Paste
-
Copy & Paste
PHASE - II (Powerpoint 2007 Online courses)
4) EDIT MENU
-
Find
-
Replace
5) VIEW MENU (Microsoft Powerpoint 2007 Online courses)
-
Normal
-
Slide Sorter
-
Notes Page
-
Slide Show
-
Slide Master
-
Title Master
-
Black and White
-
Toolbars
-
Ruler
-
Header and Footer
6) INSERT MENU (E-Learning courses in Powerpoint 2007 Online courses)
-
New Slide
-
Slide Number
-
Date & Time
-
Comment
-
Picture
-
Text Box
-
Table
-
Object
PHASE - III (Powerpoint 2007 Online courses)
7) FORMAT MENU
-
Font
-
Bullet and Numbering
-
Slide Layout
-
Slide Color Schemeg
-
Background
-
Design Templates
Colors and lines
8) Tool MENU (Powerpoint 2007 Online courses)
-
Auto Correct
-
Macro
-
Customize
-
Option
9) SLIDE SHOW MENU (Powerpoint 2007 Online courses)
-
View Show
-
Set Up Show
-
Action Buttons
-
Preset Animation
-
Custom Animation
-
Slide Transition
-
Custom Shows
Tally
Introduction:
Tally Solutions Ltd is a financial accounting software that is currently used in 88 countries beyond its native India, including the United Kingdom, and the Middle East.
Tally's software is mainly used for vouchers, financial statements, and taxation in many industries, and has specialized packages for retail businesses
Study Tally Accounting Software Online Because..
We at Aonlinetraining offer Interactive Online Courses (e-learning) for Tally (Financial Accounting Software).
The Online Training Courses for Tally covers right from the Basics (principles of accounting, types of accounts, to the Most Advance features of Tally (Profit & Loss, Balance Sheet, Vouchers, ETC). All the tutorials, lessons for Tally are supplemented with proper assignments and projects which are monitored by us (Staff Members of Aonlinetraining)
Online training (courses) for Tally Accounting Software would take a student 30 hours to Complete
Course Contents
PHASE - I
1) What is Book Keeping?
2) What is an Account?
3) What is Double –Entry System of Book Keeping?
4) Explain the term transaction
5) What is journal entry?
6) What is Contra Entry?
7) What is Journal Voucher?
8) Explain the word Liability
9) Explain the word asset s
10) Books of Accounts
11) Definition of Indirect Exp / Indirect Income
12) Definition of Direct Exp / Direct Income
13) What is debit?
14) What is credit?
15) Difference between Journal voucher / Journal entry
PHASE - II
1) Golden rules of Accounting
PHASE - III
1) Accounting Software
2) Why use Tally to maintain Account
3) Advantage over manual Accounting
PHASE - IV
1) Creation of Company / Accounts only? Accounts with Inventory
2) Alt the company
3) Creation of password / security
4) Opening the company making it active
5) Creating ledger A/c.
6) Altering individual ledger a/c
7) Viewing / Altering multiple ledger on screen
8) Inventory creation / Altering stock group /stock items
PHASE - V
1) Entering Voucher
2) Payment voucher / Receipt Voucher / Contra voucher / Journal voucher
3) Purchase voucher / Sales voucher / Purchase return / Sales Return
4) Purchase Order / Sales order / Stock Journal voucher / physical
5) Stock voucher / Rejection out voucher / Rejection In voucher
PHASE - VI
1) Easy Access to the various Books of Account
2) Cash Book / Bank Book / Purchase Book / sales Book /
3) Journal voucher book / Debit Note book / Credit Note Book
4) Day Book / Ledger Book
PHASE - VII
1) Automatic Creation of Financial Accounting Statement
2) Trial Balance
3) Trading A/c
4) Profit & Loss A/c
5) Balance Sheet
6) Stock Summary
7) Ratio Analysis
PHASE - VIII
1) Printing various Book of Account
2) Printing all Financial Statement
| Online | ||||
| When | Duration | Where | Remarks | Price |
| Not Specified | (Total 120 Hrs) | Study Online (on your computer) | Not Specified |
INR 13,000 Per Course (Taxes As Applicable) |
| Price Notes: The cost for the course in Indian Rupees (INR) would change depending on the 'Current Rate' of US Dollar. Fees in (US $) 325. | ||||
Mumbai, Bandra West (Franchisee):- Aonline Training CO Peter Dias Road, Near Mehboob Studio,O'Priya Building1st Floor, Block No 6 Bandra West, Mumbai, Maharashtra, India
Mumbai, Andheri West (Franchisee):- Office No R- 26, 1st Floor, RNA Complex Lokhandwala rd Cross Lane, Next to High Point Restaurant Andheri West, Mumbai - 400 053, Maharashtra, India
Aonline Training
Aonlinetraining is a division of Compufield - The Pioneer Computer Institute which was established in 1985. The Institute is experienced in training students and professionals, in any field from India and Abroad. Aonlinetraining is the result-oriented solution to FAQ (Frequently Asked Questions) from the students and professionals from all parts of the World.
COMPUFIELD® Training Institute was started by Mr. M. E. Khairaz. It was the first one of its kind in Mumbai (Bombay) - INDIA and it specialized in INTERNET, DIGITAL ART, MULTIMEDIA and PROGRAMMING courses. Over the years Compufield has managed to maintain its standard for imparting quality training in all the latest software packages.
