Computer Course by State Govt.

Exams are conducted from time to time by Vardhman Mahaveer Open University Kota Raj.

Exam Pattern : Objective Paper , NO Negative Marking, NO Practical. 

Practical Training of Computer with (Ms-Word, Ms-Excel & Power Point, Email & Internet)

Practical Training are provide on computer in Hindi / English by the Teacher . 

(Required course material will be provided with No Extra Fee)
 

Fundamental Accounting :

Basic of Accounting Rules & Standards with practical Industries Accounting.
Basic of Accounting Rules & Standards with practical Industries Accounting.

Financial Accounting :
 
Cash Book, Bank Book, Purchase-Sales Register, Journal Register, Trial Balance, Profit & Loss A/c, Balance Sheet (+) Manual Computerised Practical Industrial Project.
 
Prepare Trial Balance, Profit-Loss Account, Balance Sheet.

Manual Computarised Practical Industrial Project.

Fundamental Accounting
Basic of Accounting Rules & Standards with practical Industries Accounting.

Group A  : Financial Accounting 
Cash Book,Bank Book,Purchase-Sales Register,Journal Register,Trial Balance, Profit & Loss A/c, Balance Sheet(+) Manual Computerised Practical Industrial Project.

Group B  : Accounting With Inventory
Business Stock, Purchase/Sales Order,Challan With Billing (+) Manual Computerised Practical Industrial Project.

Group C  : GST (Goods & Service Tax) using tally

Introduction of GST, Components of Dual GSt:Cgst  (Central GST),SGSt (State GSt),IGSt (Integrated GST), GST Invoicing, Supply of Goods & Service, E-Way Bill,GST Report,Liablity to pay Gst.

Group D  : Interest Calculation 

 Enable Interest Calculation, Advance Interest Calculation, Create Voucher Class for Interest, USe of  Voucher Class with many more......
 

Group E  : Practical Industry Wise Accounting

Industrial Training with live project, 100% Practical Work to Finalisation of Accounts Books.        

Office Button :- Save, Save as, Open, Close, New , Print, Exit.

Home :- Clipboard, Font, Alignment, Number, Styles, Cells, Editing.

Insert :- Table, Illustrations, Charts , Links, Text, Symbols.

Page Layout :- Themes , Page setup,Scale to fit, sheet options, Arrange

Formulas :- Function Library Defined Names , Formula Auditing, Calculation

Data :- Sort & Filter, Data Tools, Outlines.

Review :- Proofing, Comments, Changes.

View :- Work book Views, Show ,Zoom, Window, Macros.

1. Sum Formula                 
2. Product Formula             
3. Average Formula             
4. Count Formula                    
5. Max Formula                 
6. Min Formula                 
7. Power Formula                    
8. Now Formula                 
9. Day-360 Formula             
10. Day Formula                     
11. Find Formula                    
12. Dollar Formula             
13. Month Formula              
14. Year Formula                    
15. Rept Formula                    
16. Roman Formula              
17. Left Formula                    
18. Right Formula
19. Upper Formula
20. Lower Formula
21. Rand Formula
22. Len Formula
23. Row Formula
24. Date Formula
25. ABS Formula
26. Volume Formula
27. Net Work Day For.
28. Hours Formula
29. MINI Formula
30. Second Formula
31. Concatenate For.
32. Proper Formula
33. PMT Formula
34. Sum Product For.
35. Sum If Formula
36. Index Formula
37. H Lookup Formula           
38. FV Formula(Future Value)        
39. Look up Value Formula      
40. V (Look up Formula)
41. If Formula Use in V look up Formula
42. Round Formula                   
43. Round Down Formula
44. Round Up Formula           
45. Fixed Formula
46. Value Count Formula        
47. Count Blank Formula
48. Count If Formula           
49. Time Formula
50. TRIM Formula                    
51. E Date Formula
52. Frequency Formula

Comuter Fundamental : 
Introduction to operating system with Windows & their Utilities, Windows, My Computer, My Documents, Windows Explorer, Recycle Bin, Find Files, Programmes (Shortcut Icons) Paint-Brush, Word Pad, Note Pad, Calculator, Display Properties (Background, ScreenSaver), Arrange Icons, Refresh Desktop.

Computerised Typing (Hindi & English Both) :
Complete Knowledge of Hindi & English with good typing speed.

MS-Office (MS-Word) :
Word Processing Application in Preparing Office Documents & All Type of Reports with More Practical Projects.

MS-Office (MS-Excel) :
Its Applications in Preparing & Analyzing Financial & Cost Statements With More Practical Project .

MS-Office (Power-Point) :
It's for Slide Preparation & Presentation with More Practical Projects.

Internet : 
Internet Explorer, Microsoft-Outlook Express, Open the Web Side, Search the Side, Create the E-mail, Open the Mail, Send & Received the Mail eith the Attechment & more.

Computer Multimedia :
USe of Laser Printer,Create/Remove the Files & Folder,Use of pen Drive,Scanning,Multimedia & More.

Page Maker with Equation Editor : 
Preparation of Commercial Letter , Visiting and Letter Pad Designing with Equation Editor and all type of test paper designing With More Practical Projects. 

Introduction to Window, My Computer, Paint-Brush, Word Pad, Note Pad, Calculator, Background, Screen Saver.

MS-Office (MS-Word) :
Word Processing Application in Preparing Office Documents & All Type of Reports with More Practical Projects & E-Learning.
 
MS-Office (MS-Excel) :
Its Application In Preparing & Analyzing Financial & Cost Statements with More Practical Projects & E-Learning.

MS-Office (Power-Point) :
It's for Slide Preparation & Presentation with More Practical Projects & E-Learning.
 
Internet :
Open the Web Side, Search the Side, Create the E-mail, Open the Mail, Send & Received the Mail with the Attachment & more...