Basic Level:(Day 1)

• Module 1. Introduction to Excel
  • Overview of Excel interface (Ribbon, Worksheets, Cells, etc.)
  • Basic terminology (Workbook, Worksheet, Cell, Range, etc.)
• Module 2. Basic Navigation and Operations
  • Opening and saving workbooks
  • Navigating through worksheets and workbooks
  • Selecting and managing cells, rows, and columns
• Module 3. Entering and Formatting Data
  • Data entry basics (text, numbers, dates)
  • Formatting cells (font, color, borders, alignment)
  • Using the Format Painter
• Module 4. Basic Formulas and Functions
  • Introduction to formulas (Sum, Average, Min, Max)
  • Understanding cell references (Relative, Absolute, Mixed)
  • Using AutoFill and Flash Fill
• Module 5. Data Managemen
  • Sorting and filtering data
  • Using Find and Replace
  • Basic data validation (drop-down lists, restrictions)
• Module 6. Basic Charts and Graphs
  • Creating and customizing basic charts (Column, Bar, Line)
  • Adding chart elements (titles, labels, legends)
  • Formatting charts
• Module 7. Introduction to Conditional Formatting
  • Applying basic conditional formatting rules
  • Using color scales, data bars, and icon sets
• Module 8. Introduction to PivotTables
  • Creating a simple PivotTable
  • Basic operations: Filtering, grouping, and summarizing data
• Module 9. Working with More Advanced Functions
  • Logical functions (IF, AND, OR)
  • Lookup functions (VLOOKUP, HLOOKUP, INDEX & MATCH)
  • Text functions (LEFT, RIGHT, MID, CONCATENATE, TEXT)

Intermediate Level:(Day 2)

• Module 1. Complex Formulas
  • Nested IF statements and advanced logical functions (IFS, SWITCH)
  • Using AND, OR, and NOT with IF
  • Array formulas and dynamic arrays (FILTER, SORT, UNIQUE)
• Module 2. Advanced Lookup and Reference Functions
  • VLOOKUP and HLOOKUP with approximate matches
  • INDEX & MATCH combination for advanced lookups
  • Using XLOOKUP (if available) and its advantages over VLOOKUP
• Module 3. Text Manipulation Functions
  • Advanced text functions (TEXTJOIN, SPLIT, SUBSTITUTE, FIND, SEARCH)
  • Parsing and cleaning data
• Module 4. Working with Dates and Times
  • Date and time functions (DATE, DATEDIF, EDATE, NETWORKDAYS, TIMEVALUE)
  • Calculating age, working days, and time differences
• Module 5. Data Analysis Tools
  • Data Tables for sensitivity analysis
  • Using Goal Seek
  • Scenario Manager to handle different data scenarios
• Module 6. Advanced Conditional Formatting
  • Creating custom rules and formulas for conditional formatting
  • Applying conditional formatting to data bars, color scales, and icon sets
• Module 7. Creating and Customizing PivotTables
  • Building and customizing PivotTables
  • Grouping data and using slicers for better filtering
  • Creating PivotCharts and analyzing data interactively
• Module 8. Creating Advanced Charts
  • Combination charts (e.g., column and line)
  • Using secondary axes and customizing chart types
  • Creating and formatting dynamic charts
• Module 9. Designing Dashboards
  • Principles of effective dashboard design
  • Integrating PivotTables, charts, and slicers into a dashboard
  • Using form controls (buttons, drop-down lists) for interactive dashboards
• Module 10. Data Import and Export
  • Importing data from various sources (CSV, web, database)
  • Exporting data to different formats (PDF, XML, CSV)

Advanced Level:(Day 3)

• Module 1: Working with Formulas & Functions
  • Understanding formulas and their importance
  • Using $ for Relative, Absolute, and Mixed cell references
  • IF Functions:
    • Single IF, Nested IF
    • Using AND, OR within IF statements
  • Essential Statistical & Logical Functions:
    • SUM, COUNT, AVERAGE, MAX, MIN
    • SUMIF, COUNTIF, SUMIFS, COUNTIFS
• Module 2: Conditional Formatting & Data Management
  • Conditional Formatting:
    • Predefined options
    • Customization using formulas
  • Name Manager:
    • Creating and using named ranges
    • Practical examples and applications
• Module 3: Lookup & Reference Functions
  • VLOOKUP & HLOOKUP:
    • Exact & Approximate Match (True/False or 0/1)
  • MATCH Function:
    • Understanding row/column lookup
  • Index & Match Combination:
    • Nesting INDEX & MATCH for advanced lookups
  • Nesting Lookup Functions:
    • VLOOKUP & MATCH
    • HLOOKUP & MATCH
• Module 4: Advanced Excel Functions
  • INDIRECT Function:
    • Understanding and using INDIRECT
    • Practical example applications
• Module 5: Data Sorting & Filtering
  • Sorting Data Efficiently:
    • Basic Sort, Multiple Sort
    • Custom Sort, Sorting Left to Right
  • Filtering Data:
    • Using Auto, Number, Text & Custom Filters
    • Using Advanced Filter for complex criteria
• Module 6: Hands-on & Real-time Applications
  • Quick Review of Day 1 Topics
  • Practical Implementation of Concepts
  • Real-world problem-solving using Excel features

(Day 4)

• Module 1: Advanced Text & Data Functions
  • Text Functions (Real-world examples and applications)
    • UPPER, LOWER, PROPER, CONCATENATE
    • LEFT, RIGHT, MID for extracting text
  • Date & Time Functions
    • DAY, MONTH, YEAR, TEXT, DATEDIF
  • Logical & Error Handling Functions
    • ISBLANK, IFERROR, ISTEXT, ISNUMBER
• Module 2: Data Manipulation & Cleaning
  • Text to Column & Flash Fill
    • Extracting external data & changing data types
  • Examples of Common Text, Information & Date Functions
• Module 3: Data Validation & Protection
  • Data Validation
    • Using predefined & custom rules with advanced functions
  • Protection Techniques
    • Protecting sheets, cells, columns, rows
    • Hiding formulas
• Module 4: Data Aggregation & Summarization
  • Subtotal & Nested Subtotal
    • Working with selected rows
• Module 5: Advanced Data Analysis
  • Pivot Tables & Pivot Charts
    • Real-time use cases and applications
  • Working with External Data
    • Microsoft Query for data extraction
• Module 6: Data Consolidation & Financial Functions
  • Data Consolidation
    • Merging data from multiple sheets/files
  • Financial Functions
    • PMT, PPMT, IPMT – Practical application
• Module 7: What-If Analysis & Scenario Planning
  • Goal Seek
    • Finding required inputs to achieve specific outputs
  • Data Table
    • Analyzing multiple scenarios
• Module 8: Introduction to Macros & Automation
  • Macros (VBA Basics)
    • Recording, Editing, and Writing Macros using VBA Editor