The Institution has been planned accordingly to provide budding ambitious young experts with Stateof-the-art technologies to meet the challenging scenario.
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.
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
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
________________________________________