Students & Members/Admin Login Area -->

Excel & Advanced Excel Course Institutes|Classes in Powai, Mumbai| KNOWLEDGETECH

IT Training Page Tags > Excel | Advanced Excel course classes institutes in I.I.T powai, Excel | Advanced Excel training institutes in powai, List of the Excel|Advanced Excel training institutes in Powai, mumbai

Course Duration: 2 Months

Learn data management skills in excel with Office 2007. Maintain data sheets in excel and efficiently add functionality using macros, vlookup, pivot table.

IT Training

Course Curriculum


    - Electronic Spreadsheet Concept

    - Formatting Fonts, Numbers, Auto-Format

    - Relative & Absolute Reference, Date & Currency Formatting

    - Formula charts & Graphs, 2D/3D Graphs

    - Pie, Line Cone, Formatting Charts

    - Data Values, Sub Total Reports, Auto Filters

    - Password Protecting Worksheets,Linking Multiple Sheets

    - Intro. to MACRO's, Nested If's, Sheet Referencing.



    - Sub Total Reports, Auto Filter

    - Password Protecting Worksheets

    - Linking Multiple Sheets

    - Sheet Referencing

    - Linking Between Word/Excel/PPt

    - Functions:- LOOKUP, VLOOKUP, HLOOKUP

    - COUNTIF, SUMIF. What-if-analysis

    - Pivot Tables, NESTED IF

    - Reporting

    - Character Functions

    - Date Functions

    - Age Calculations

    - Consolidation of Data

    - Data Validation

    - MACRO’S

    - Introduction to VBA Prog.