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