Course Includes:
- Price: ₹ 25000.00
- Instrutor: Yes
- Duration: 6 Months
- Language: English
- Certificate: Yes
Cursor Insert India
Advanced Excel
Advanced Excel
₹ 25000.00
Course Description
Module 1: Advanced Functions and Formulas
- Nested IF, AND, OR functions
- Advanced Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH
- Logical & Error Handling Functions: IFERROR, ISERROR, IFNA
- Date & Time Functions: TEXT, TODAY, EOMONTH, NETWORKDAYS
- Text Functions: LEN, MID, FIND, LEFT, RIGHT, SUBSTITUTE
- Dynamic Arrays & Spill Functions: UNIQUE, FILTER, SORT, SEQUENCE
Module 2: Data Validation and Conditional Formatting
- Creating custom validation rules
- Dynamic dropdown lists using Data Validation
- Applying advanced conditional formatting with formulas
- Highlighting duplicate & unique values
Module 3: Data Analysis and PivotTables
- Creating & customizing PivotTables
- Grouping and filtering data dynamically
- Calculated Fields & Calculated Items in PivotTables
- Using Slicers and Timelines for data analysis
- Introduction to Power Pivot and Data Model
Module 4: Data Cleaning and Transformation
- Removing duplicates & splitting text using Text to Columns
- Using Flash Fill for quick data transformations
- Advanced Find & Replace techniques
- Cleaning data with Power Query (Get & Transform)
Module 5: Advanced Charting and Visualization
- Creating dynamic charts with OFFSET and Named Ranges
- Customizing Combo Charts (e.g., Line + Bar)
- Creating interactive dashboards with Slicers & PivotCharts
- Waterfall, Histogram, Box & Whisker Charts
- Creating Sparklines for trend visualization
Module 6: Automation with Macros and VBA (Optional)
- Introduction to Macros & VBA
- Recording & Running Macros
- Writing Basic VBA Scripts
- Automating repetitive tasks using VBA
Module 7: Power Query & Power Pivot (Data Modeling)
- Importing data from multiple sources
- Merging & appending datasets
- Creating relationships between tables
- Introduction to DAX (Data Analysis Expressions)
Module 8: Financial & Statistical Analysis
- Using NPV, IRR, PMT, PV, FV for financial modeling
- Regression Analysis & Forecasting in Excel
- Statistical Functions: STDEV, VAR, CORREL, TREND
- Creating Monte Carlo Simulations
Module 9: What-If Analysis & Scenario Planning
- Goal Seek & Solver for optimization
- Data Tables (One-Variable & Two-Variable)
- Scenario Manager for financial projections
Course Syllabus
1: Advanced Functions and Formulas
2: Data Validation and Conditional Formatting
3: Data Analysis and PivotTables
4: Data Cleaning and Transformation
5: Advanced Charting and Visualization
6: Automation with Macros and VBA (Optional)
7: Power Query & Power Pivot (Data Modeling)
8: Financial & Statistical Analysis
9: What-If Analysis & Scenario Planning
Duration: 6 Months Months
Course Creator: Cursor Admin
Advertisements
Admission Query
Related Courses
6 Months
3 Months
6 Months
6 Months
6 Months
