- Computer Science (19)
- Business Management (2)
- Arts & Design (1)
- Personal Development (1)
- Data Science (3)
- Marketing (3)
- Business & Finance (1)
- Graphics Designer (38)
- Financial Markets (1)
- Fundamental Analysis (1)
- Technical Analysis (1)
- Commodity and Currency (1)
- Excel and MS Office (12)
- Financial Planning (1)
- Banking and Credit (1)
- Web Development (3)
- Mobile Development (1)
- Programming Language (1)
- Database Design & Development (1)
- No-Code Development (1)
- Entrepreneurship (1)
- Communication (1)
- Management (1)
- Sales (1)
- Business Strategy (1)
- Operations (1)
- Business Law (1)
- Business Analytics & Intelligence (1)
- Human Resources (1)
- Industry (1)
- E-Commerce (1)
- Media (1)
- Accounting & Bookkeeping (10)
- Money Management (1)
- IT Certificates (1)
- Network & Security (1)
- Hardware (2)
- Operating Systems & Server (1)
- Microsoft (1)
- Google (5)
- SAP (9)
Cursor Insert India
Advanced Excel
Advanced Excel
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
Advertisements
Admission Query
6 Months
3 Months
6 Months
6 Months
6 Months
