Authorised VTP (Vocational Training Provider) Ministry of Skill Development & Enterprenureship
Authorised NSDC Training Partner
Management Information System & Advance Excel (OCMISE : Oxford Certified MIS Executive)

To the managers, Management Information System is an implementation of the organizational systems and procedures. To a programmer it is nothing but file structures and file processing.


The three components of MIS provide a more complete and focused definition, where System suggests integration and holistic view, Information stands for processed data, and Management is the ultimate user, the decision makers.

Course Contents
Microsoft-Office

  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint

Advance Excel

  • Working with Functions
  • Mathematical Functions
  • Logical Functions
  • Statistical Functions
  • Text, Date Functions
  • Financial Functions
  • Lookup Functions
  • Depreciation Functions
  • Database Functions
  • Information Functions
  • Pivot Table and Pivot Charts
  • Conditional Formatting
  • Data Validation
  • What-if-Analysis Tool (Goal Seek, Solver, Scenario & Data Table)
  • Advance Filter
  • Sorting, Subtotal, Consolidate
  • Formula Auditing
  • Creating Template
  • Microsoft Access

  • Design and Create the Tables for a New Database
  • Using Macros with Events
  • Create Forms and Reports for a New Database
  • SQL Query
  • Create Relationships and Queries for a New Database
  • VBA

    • Introduction to VBA
    • Operators, Loops
    • Strings, Arrays, Functions
    • Messages Box, Macros
    Communication Skills, Personality Development & Writing Skills

    Certification

    The students will also get training for below certifications
    • Microsoft Office Specialist Certification
    • CCC Certificate by NIELIT

    Note: The students need to pay certification/exam fee in addition to course fee and has to clear the respective exam.

    Advance Excel

    Microsoft Excel is perhaps the most important computer software program used workplace today. That's why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace. From the viewpoint of the employer, particularly those in the field of information systems, use of Excel as an end-user computing tool is essential.

    Course Contents
    Section-1 Make a start with Excel

  • Working with worksheet
  • Number formatting
  • Cell Reference
  • Fill series
  • Working with Functions:- Mathematical, Statistical, Text, Date
  • Section-2 Working with Advance Functions

  • Logical Functions:- IF, AND, OR, NOT
  • Financial Functions :- PMT, PV, RATE, FV & More
  • Look up Functions:- VLOOKUP & HLOOKUP
  • Match and Index Functions
  • Depreciation Functions
  • Database Functions
  • Information Functions
  • Section-3 Processing Data in Excel

  • Spark line
  • Pivot Table & Charts
  • Conditional Formatting
  • Data Validation
  • What-If-Analysis Tool (Goal Seek, Solver, Scenario & Data Table)
  • Auto & Advance Filter
  • Sorting, Subtotal, Consolidate
  • Formula Auditing
  • Workbook Protection
  • Creating Templates
  • Certification

    The students will also get training for below certifications
  • Microsoft Office Specialist Certification
  • CCC Certificate by NIELIT
  • Note: The students need to pay certification/exam fee in addition to course fee and has to clear the respective exam.

    Centres

    Pusa Road, Delhi
    Phone No. 45091668, 45091669

    South Extension, Delhi
    Phone No. 64605158,64605159

    Preet Vihar, Delhi
    Phone No. 65968945, 65968946

    Yamuna Vihar, Delhi
    Phone No. 43090748, 65968948

    Pitam Pura, Delhi
    Phone No. 65968951, 65968952

    Rajouri Garden, Delhi
    Phone No. 25164733, 45578601

    Dwarka, Delhi
    Ph. No. 8130225559,9582068478

    North Campus (Delhi University)
    Phone No. 43474907 , 65968954

    © Copyright Reserved 1996-2017