Stat Modeller


Stat Modeller

Local Time

  • Timezone: Asia/Kolkata
  • Date: Jul 06 - 07 2024
  • Time: 9:30 am - 5:30 pm


Jul 06 - 07 2024


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