Group Services: Technology Consulting
phone +91-9999-283-283/9540-283-283
email info@sisoft.in

Course Details

Course outline for Advance MS Excel

Goal:

The goal of Advance Excel Training is to give you a solid understanding of Advance Excel.

Audience:

This course is designed for those , Who are willing to make carrier in Advance Excel .

Pre-requisites:

Any Graduate or Post-Graduate having Knowledge of Basic Computer

Duration:

14 - 15 hours

Course Structure

Topic-1

  • Introduction of MS Excel
    • OVERVIEW OF EXCEL
    • ROW, COLUMN, CELL, RANGE, Ribbon
    • INSERT SHEET, DELETE SHEET
    • FORMATTING, BORDER, MERGE, WRAP TEXT
    • EXCEL SHORTCUTS

Topic-2

  • Text Functions
    • UPPER
    • LOWER
    • PROPER
    • LEN
    • LEFT
    • RIGHT
    • MID
    • TRIM
    • FIND
    • CONCATENATE
    • TEXT TO COLUMN

Topic-3

  • Date & Time
    • DATE FUNCTION
    • TIME FUNCTION
    • TODAY ()
    • NOW ()
    • NETWORKDAYS
    • WORKDAYS
    • DATEDIF

Topic-4

  • EXCEL FUNCTIONALITIES
    • FILTERS
    • SORTING
    • ADVANCE FILTER
    • REMOVE DUPLICATE
    • MOVE or COPY a Sheet
    • CONDITIONAL FORMATTING
    • GROUP AND UNGROUP
    • SUBTOTAL ANALYSIS

Topic-5

  • Advance Functions
    • ABSOLUTE REFERENCE
    • RELATIVE REFERENCE
    • Rank Function
    • SMALL AND LARGE FUNCTION
    • IFERROR FUNCTION
    • IFERROR FUNCTION
    • PASSWORD PROTECTION
    • LOCKING CELLS CONTAINING FORMULAS
    • PROTECTING SPECIFIC CELLS

Topic-6

  • EXCEL Advance FUNCTIONALITIES
    • DATA VALIDATION
    • DATA CONSOLIDATION
    • GOAL SEEK
    • LINKING SHEETS AND WORKBOOKS
    • DROP DOWN LIST
    • DEPENDENT DROP DOWN LIST
    • NAMING MANAGER
    • SCENARIO MANAGER

Topic-7

  • PIVOT TABLE, Match and Index Function
    • PIVOT TABLE
    • PIVOT CHART
    • ADDING CALCULATED FIELD
    • CHANGING DATA IN PIVOT
    • PIVOT FROM MULTIPLE TABLES
    • INDEX
    • MATCH

Topic-8

  • LOOKUP AND Conditional Functions
    • VLOOKUP
    • HLOOKUP
    • COUNTIF
    • SUMIF
    • SUMIFS
    • AVERAGEIF
    • AVERAGEIFS
    • IF FUNCTION
    • NESTED IF FUCTION

Topic-9

  • Charting And Dashboard
    • CHART INTERPRETATION
    • COLUMN CHART
    • PIE CHART
    • LINE CHART
    • COMBINED CHART
    • DASHBOARD
    • DYNAMIC CHART

Topic-10

  • Macro & Advance Functions
    • MACRO OVERVIEW
    • RECORDING OF MACRO
    • EXECUTION OF MACRO
    • ASSIGNING MACRO TO COMMAND BUTTON
    • INDEX AND MATCH
    • OFFSET FUNCTION

Our Faculty youTube Channel