Master Pass
Inauguration Event Master Class Power Query Fundamentals in Excel Reducing Errors in Financial Models The Ideal Data Model – The WHY and the HOW Interesting business use of INDEX, SUMIFS, MAX, MIN, SUMPRODUCT and RAND Functions Automate Tasks with Excel and Power Automate INDEX Function – Excel’s Best Function | Welcome to the Boss Level Getting Started with Power Query Be Effective with Dashboard Report Power Query in the Fire: Using Excel for Real-World Needs Advance Excel Classes Master Reporting with MS Excel Data Viz that Works! Excel Functions & Formulas for Business Automate with Power Query & Macro Building …
Curriculum
Overview
Inauguration Event
Master Class
- Power Query Fundamentals in Excel
- Reducing Errors in Financial Models
- The Ideal Data Model – The WHY and the HOW
- Interesting business use of INDEX, SUMIFS, MAX, MIN, SUMPRODUCT and RAND Functions
- Automate Tasks with Excel and Power Automate
- INDEX Function – Excel’s Best Function | Welcome to the Boss Level
- Getting Started with Power Query
- Be Effective with Dashboard Report
- Power Query in the Fire: Using Excel for Real-World Needs
Advance Excel Classes
- Master Reporting with MS Excel
- Data Viz that Works!
- Excel Functions & Formulas for Business
- Automate with Power Query & Macro
- Building Foundation of MS Excel
Special Classes
- Prepare for MOS Associate Excel Exam
- Advance Use of XLOOKUP & VLOOKUP
- Conditional Formatting in Depth
- Advance Excel Tips & Tricks
- Preparation of Written Test on Excel
- Bring More Power to Excel with M Code
- Professional Tips, Tricks & Shortcuts
- Various Use of IF Function
- Business Intelligence with Excel
- Preparation of Verbal Interview on Excel
Panel Discussion
- Panel Discussion with CEO Panel
- Panel Discussion with University Panel
- Panel Discussion with HR Panel
- Panel Discussion with Sales Panel
- Panel Discussion with Finance Panel
- Panel Discussion with Microsoft
- Panel Discussion with Supply Chain Panel