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