Skylight Education

Create a New Shortcut Menu

Generally there are three shortcuts in the top menu, which are Save, Undo Typing and Repeat Typing. However, if you want to use more shortcuts, like Copy and Cut, you can set them up as follows:

File->Options->Quick Access Toolbar, add Cut and Copy from the left column to the right, save it. You will see two more shortcuts added in the top menu.

||LIKE||COMMENT||SHARE||

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

||COME||LEARN||SET UP YOUR CARRIER||

||LIKE||COMMENT||SHARE||

Hey Guys,

Both for beginners and advanced users of Microsoft Excel 2010, there are still many useful tips and tricks that are inevitably overlooked. Here are one of the most useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on your daily work..

Enjoy... :D

& Please Follow the Below mentioned Link :

https://www.facebook.com/skylightedu1992/posts/825288050931574

Interested candidates Text on my Whatapp no (9163412733) or On my inbox..

Thank u...

Skylight Education

[03/25/16]   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 student 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

Skylight Education's cover photo

Skylight Education