Mobile No. +91-9214493851
Monday - Saturday: 10 AM - 06 PM

 

Excel for Beginners


Duration : 30 - Days


Fee : Rs. 1500 / -

Syllabus :

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.

 

Advance Excel with Formula


Duration : 30 -Days


Fee : Rs. Rs. 3500 / -

Syllabus :

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

 

Tally Prime with GST


Duration : 60 -Days


Fee : Rs. Rs. 3500 / -

Course : Practical Accounting

Cash Book & Bank Book, Purchase Register & Sales Register, Journal Voucher, Business Stock, Billing (Invoice), GST (Goods & Service Tax), Trial Bal

 

Tally Prime (Smart Accounting)


Duration : 30-Days


Fee : Rs. 2100 / -

Financial Accounting :

Financial Accounting :
 
Cash Book, Bank Book, Purchase-Sales Register, Journal Register, Trial Balance, Profit & Loss A/c, Balance Sheet.
 
Accounting with Inventory :
 
Business Stock, Purchase/Sales Order, Challan with Billing . 

 

Computer Basic Course


Duration : 60 - Days


Fee : Rs. 2100

Computer Fundamental

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...

Copyrights@ 2022 Tally Prime Education . All Rights Reserved.