Local Time
- Timezone: Asia/Kolkata
- Date: Jul 06 - 07 2024
- Time: 9:30 am - 5:30 pm
Mastering Advanced Excel with ChatGPT
Day 1: Foundations and Advanced Techniques
Session 1: Excel Formulas – Basics and Beyond
- Introduction to Basic Formulas (SUM, AVERAGE, COUNT, LARGE, SMALL)
- Advanced Formulas (SUMIF(s), COUNTIF(s), AVERAGEIF(s))
- Real-world examples and hands-on practice
Session 2: Mastering Lookup Functions
- Understanding VLOOKUP, HLOOKUP, XLOOKUP
- Using INDEX and MATCH for flexible lookups
- Practical applications and exercises
Session 3: Financial Functions
- Introduction to Financial Functions (PMT, NPV, IRR, XIRR, CAGR)
- Applying Financial Functions to real-world scenarios
- Case studies and practical exercises
Session 4: Conditional Formatting
- Basics of Conditional Formatting
- Advanced Techniques with Conditional Formatting
- Creating dynamic reports with practical examples
Session 5: Data Validation
- Applying Data Validation
- Applying Custom Data Validation
- Practical exercises and examples
Day 2: Advanced Features and Automation
Session 1: Logical Functions – If-Else and Beyond
- Basics of IF, Nested IF Statements
- Using AND, OR with IF for complex conditions
- Practical exercises and examples
Session 2: Text Functions
- Introduction to Text Functions (CONCATENATE, CONCAT)
- Advanced Text Functions (SEARCH, FIND, TEXTJOIN, TEXTSPLIT)
- Hands-on practice with real-world data
Session 3: Creating Gantt Charts and Organization Charts
- Step-by-step creation of Gantt Charts in Excel
- Building Organization Charts using SmartArt and Shapes
- Practical exercises to create and customize charts
Session 4: Automation with ChatGPT
- Introduction to Excel automation and the role of ChatGPT
- Automating repetitive tasks using macros and VBA
- Integrating ChatGPT for data analysis and decision support
- Practical examples and interactive Q&A session
Conclusion and Q&A
- Recap of key concepts
- Q&A session for clarifications and advanced queries
- Providing additional resources and learning paths