Day by day the industries are orienting themselves towards automation & Computerisation resulting in a huge demand of qualified Computer Professionals. Private computer training institutes are offering various courses to take advantage of this situation but they are so much of Professional. So I start thinking to open a Computer Training Centre where we can Provide our best Training part to the st
udent for their better Future. Skylight Education has come forward in this connection to help set up Computer Training centre to cater to the increasing needs of the students.
• Courses offered at this institute:
Computer Fundamentals Tutorial:
::::::::::::::::::::::::::::::::::::::::::::::::::::::
Duration : 4 months
Theoretical Computer Basic
Operating System - Windows 7 or windows 8
Others - Paint, note-pad, word-pad, File & folder Management System, Uses of other tools. Ms-Office (Word, Excel & PowerPoint). Project. Eligibility : NA
• Advance Excel & Functions:
::::::::::::::::::::::::::::::::::::::::::::::::
Duration : 6 months
Formulas & Macros Formulas:
Use the Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
Nested functions , Name cells /ranges. Logical functions using IF, AND, OR, NOT
________________________________________
DATA Analysis:
Sub Total Reports, Auto Filter
Password Protecting Worksheets
Linking Multiple Sheets using Hyperlink
Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
What-if-analysis, GOAL SEEK
PIVOT Tables
Reporting
Date Functions
Age Calculations
Consolidation of Data
Data Validation
MACRO’S
________________________________________
Macros:
Definition and use , Record a macro
Assign a macro , Run a macro
________________________________________
Develop the Worksheet:
Plan a worksheet , Row and Column labels
Split worksheet /box /bar, Copy data and
formulas
Display /move toolbars , Enhance worksheet
Appearance
________________________________________
Special Operations:
Use multiple windows : Copy/ paste between Worksheets
Link worksheets , Consolidate worksheets
Import and link from other Applications
Use AutoFormat : Create, use and modify styles and templates
Print features : Create /edit an outline
Project
Eligibility : Eligibility : Madhyamik or Equivalent
Passed / Appeared or higher
Computerized Accounting System (Tally)
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Accounting With Tally
• Accounting Basics (Theory)
• Understanding Ledgers & Groups
• Understanding Voucher Types
• Entering:
o Sales & Purchase
o Payments & Receipts
o Contra & Adjustments
o Debit & Credit Notes
• Reports :
o Printing - Exporting - Mailing
• Bank Reconciliation & Printing Cheque
Duration : 6 months
Eligibility : Class XI or Equivalent Passed /
Appeared or 10+2
Computerized Accounting System (Advance)
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Basics of Accounts (Theory part)............................
Finalisation of Accounts
Rectification of Errors
Depreciation
Cost Accounting
•Accounting Applications
Tally ERP
POS
Job Costing
TDS
TCS
• Advance Accounting:
Preparation of Final Accounts as per Schedule - VI
Banking Operations (Theory)
BRS
• Financial Data Analyst with EXcel (Theory & Practical Both)
• Statutory Compliance with Excel (Theory & Practical Both)
Taxation & e-Filing:
:::::::::::::::::::::::::::::::
Direct Tax (Theory & Practical Both)
• Income Tax
• Corporate tax
• Advance Tax
• Computation and Assessment Procedure
• Wealth Tax
• TDS
• Return Filing
Indirect Tax (Theory & Practical Both)
• CST
• VAT
• Excise Duty
• Service Tax
• Implementation of Indirect Tax in Tally ERP
• e - Filing (Basic Knowledge)
Duration : 9 months
Eligibility : Class XI or Equivalent Passed /
Appeared or 10+2
•Other Courses:
> Spoken English
> Career Development Course
Duration : 3 months
Eligibility : NA
