Surendra Kr. Sinha(Excel VBA Trainer from last 15 years)
(Online and Offline)
Contact no 9999324981
Duggal colony khanpur, New Delhi
VBA Macros and Advance Excel Course
Nested Functions (IF, AND, OR)
Advanced Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)
Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Date and Time Functions (DATE, TIME, DATEDIF, NETWORKDAYS)
Logical Functions (IFERROR, ISERROR, ISNUMBER)
Financial Functions (PMT, FV, NPV, IRR)
Advanced PivotTables and PivotCharts
Slicers and Timelines in PivotTables
Creating and Using Data Models
Introduction to Power Query
Data Consolidation
Data Validation (Advanced Techniques)
Using Form Controls (Drop-Down Lists, Check Boxes)
Advanced Sorting and Filtering Techniques
Importing and Exporting Data (CSV, Text, XML)
Working with External Data Sources (Connecting to SQL, Access)
Introduction to Macros
Recording, Running, and Editing Macros
Basic Introduction to VBA (Visual Basic for Applications)
Automating Tasks with Macros
Creating Custom Functions with VBA
Creating Advanced Charts (Waterfall, Pareto, Histogram)
Customizing Charts with VBA
Using Sparklines for Data Visualization
Creating Dynamic Charts
Using Excel’s Charting Tools for Data Analysis
Introduction to Dashboards
Designing a Dashboard Layout
Using PivotTables and PivotCharts in Dashboards
Using Form Controls for Interactive Dashboards
Best Practices for Dashboard Design
Installing and Managing Add-ins
Using Analysis ToolPak for Data Analysis
Introduction to Power Pivot
Using Solver for Optimization Problems
Introduction to Power BI Integration
Co-authoring Workbooks
Tracking Changes and Comments
Protecting Workbooks and Worksheets
Using Excel Online and OneDrive for Collaboration
Sharing and Exporting Workbooks
Debugging Formulas
Error Checking and Correction
Workbook Recovery Options
Advanced Excel Tips and Shortcuts
Customizing Excel Environment
Recap of Advanced Concepts
Practical Exercises and Projects
Final Q&A Session