Advance Excel LIVE Course (Basic to Advance)

The Advance Excel LIVE Course Batch Timings is 6:30pm to 7:30pm 

This structured 45-day plan ensures professionals gain expertise in Advanced Excel, Data Analytics, and Dashboard Creation while also learning automation techniques using Macros and Power Query...

30-Session Advanced Excel Live Course for Professionals

Session 1-7: Advanced Formulas & Functions

1. Session 1: Introduction to Advanced Excel, Shortcuts & Efficiency Tips
2. Session 2: Logical Functions: IF, AND, OR, IFERROR, Nested IFs etc.
3. Session 3: Lookup & Reference Functions: VLOOKUP, HLOOKUP, XLOOKUP etc.
4. Session 4: INDEX-MATCH vs VLOOKUP: When & How to Use
5. Session 5: Text Functions: TEXT, LEN, LEFT, RIGHT, MID, TRIM etc.
6. Session 6: Date & Time Functions: TODAY, NOW, DATEDIF, EOMONTH, NETWORKDAYS etc.
7. Session 7: Advanced Math & Statistical Functions: SUMIFS, COUNTIFS, RANK, PERCENTILE, Filter, DSSUM, DGET etc.

Session 8-14: Data Cleaning, Validation & Pivot Tables

1. Session 8: Data Cleaning Techniques: Remove Duplicates, Flash Fill, Power Query
2. Session 9: Data Validation: Drop-down Lists, Input Messages, Error Alerts
3. Session 10: Conditional Formatting: Advanced Rules & Custom Formulas
4. Session 11: Pivot Tables: Basics & Customization
5. Session 12: Pivot Charts & Slicers for Dynamic Reports
6. Session 13: Working with Large Data Sets: Filters, Sorting, Subtotals
7. Session 14: Hands-on Practice: Real-World Data Cleaning Challenges

Session 15-21: Data Analytics & Dashboard Creation

1. Session 15: Introduction to Data Analytics in Excel
2. Session 16: Report Generation
3. Session 17: Power Query for Data Extraction & Transformation
4. Session 18: Power Pivot: Data Modeling & Creating Relationships
5. Session 19: Creating Interactive Dashboards – Layout & Design Principles
6. Session 20: Connecting Charts & Pivot Tables in Dashboards
7. Session 21: Hands-on Practice: Building a Live Dashboard

Session 22-28: Automation, Macros & Final Projects

1. Session 22: Introduction to Macros & VBA: Basics & Recording Macros
2. Session 23: Writing Simple VBA Codes for Automation
3. Session 24: Data Entry Form creation with the help of Macros
4. Session 25: Invoice Creation with the help of VBA & CHAT GPT
5. Session 26: Finalizing Dashboards & Advanced Reporting Techniques
6. Session 27: A.I Tools & Add-Ins in Excel
7. Session 28: Hands-on Project: Real-World Data Analytics & Reporting

Session 29-30: Final Q&A & Certification

1. Session 29: Q&A, Troubleshooting, and Best Practices Discussion
2. Session 30: Certification, Project Review, and Closing Session