Microsoft Excel: Advanced Formulas, Data Analysis & Productivity at just ₹1499

Trained by working IT professionals from leading companies

10 HOUR Microsoft Excel: Advanced Formulas, Data Analysis & Productivity SYLLABUS

This course takes your Excel skills to the next level. Learn advanced formulas, PivotTables, data analysis tools, automation using macros, and modern Excel features for professional data-driven work.

Fee: ₹1499 Training Mode: Instructor-led live class Duration: 10 hours Next Batch: Loading...
Book the Course Talk to Us
Prerequisite: Microsoft Excel: Beginner

Syllabus Overview

  • Advanced Formulas & Functions
    • IF(), Nested IF()
    • IFS()
    • VLOOKUP(), HLOOKUP()
    • XLOOKUP()
    • INDEX() & MATCH()
    • CHOOSE()
    • OFFSET()
    • INDIRECT()
    • TEXT(), VALUE()
    • Advanced logical functions (AND, OR, NOT)
    • ERROR handling functions (IFERROR, IFNA)
  • Pivot Tables & Pivot Charts
    • Creating Pivot Tables
    • Fields, Filters, Values, Rows, Columns
    • Grouping data
    • Calculated fields & items
    • Pivot Table formatting
    • Creating Pivot Charts
    • Using slicers & timelines
  • Data Analysis Tools
    • What-If Analysis (Scenario Manager, Data Tables, Goal Seek)
    • Solver
    • Descriptive Statistics (Data Analysis ToolPak)
    • Regression analysis
    • Forecasting
  • Data Cleaning & Preparation
    • Removing duplicates
    • Text-to-Columns
    • Flash Fill
    • TRIM, CLEAN, SUBSTITUTE
    • Find & Replace advanced use
    • Handling blank cells & errors
  • Data Validation & Protection
    • Restricting entries
    • Creating drop-down lists
    • Input messages & error alerts
    • Custom formulas for validation
    • Protecting worksheets
    • Password-protecting workbooks
  • Charts & Visualizations
    • Column, Bar, Line, Pie charts
    • Combo charts
    • Dynamic charts
    • Advanced chart formatting
    • Sparklines
    • Waterfall, Funnel, Histogram
  • Advanced Filtering & Sorting
    • Custom Sort
    • Advanced Filter
    • Unique values extraction
    • Extracting with criteria
  • Macros & Automation
    • Introduction to Macros
    • Recording Macros
    • Running Macros
    • Assigning Macros to buttons
    • Intro to VBA
  • Power Tools
    • Introduction to Power Query
    • Loading data from multiple sources
    • Transforming data
    • Introduction to Power Pivot
    • Creating Data Models
    • DAX basics
  • Collaboration & Security
    • Sharing workbooks
    • Tracking changes
    • Comments & Notes
    • Restricting permissions
  • Practical Case Studies
    • Business dashboards
    • Sales data analysis
    • Financial modeling
    • HR data management
TALK TO US FOR FREE