Students & Members/Admin Login Area -->

Cancel
Member login
logo
pages Excel & Advanced Excel
Excel & Advanced Excel Course
Course Duration: 2 Months

IT TrainingKnowledgeTech, an established IT Training, Service Provider & Web Development Firm in Powai believes in empowerment of education through Complete IT based Solutions. We represent a brand that acknowledges and delivers education & all IT based requirements & services with excellence.

IT Training

Course Curriculum

  • MS-EXCEL

    MS OFFICE

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

  • ADVANCED EXCEL

    MS OFFICE

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