Office Productivity
Advanced Excel: PivotTables, XLOOKUP & Dashboards
Build reliable business reports using lookup formulas, conditional formatting, PivotTables, data validation and interactive dashboards.
Provided by HiringMart India
About this course
Build reliable business reports using lookup formulas, conditional formatting, PivotTables, data validation and interactive dashboards.
What you will learn
Understand the core concepts, complete guided practice, apply the workflow to a realistic task, and demonstrate competency through module quizzes and assignments. / मूल अवधारणाएँ समझें, निर्देशित अभ्यास पूरा करें, वास्तविक कार्य पर प्रक्रिया लागू करें और मॉड्यूल क्विज़ व असाइनमेंट से अपनी दक्षता दिखाएँ।
Course curriculum
Advanced Lookup and Logic / मॉड्यूल 14 lessons
1. XLOOKUP with Exact and Approximate MatchArticle · 15 min
2. INDEX and MATCH for Flexible LookupsArticle · 18 min
3. IFERROR and Multi-Condition FormulasArticle · 21 min
4. Dynamic Arrays and Spill BehaviourArticle · 24 min
Data Preparation / मॉड्यूल 24 lessons
1. Power Query Import and TransformArticle · 15 min
2. Split, Merge and Clean ColumnsArticle · 18 min
3. Data Types, Nulls and Duplicate ControlArticle · 21 min
4. Combine Monthly Files SafelyArticle · 24 min
Pivot Analysis / मॉड्यूल 34 lessons
1. PivotTable Fields, Values and FiltersArticle · 15 min
2. Grouping Dates and CategoriesArticle · 18 min
3. Calculated Fields, Slicers and TimelinesArticle · 21 min
4. PivotCharts and Refresh ManagementArticle · 24 min
Business Dashboard Project / मॉड्यूल 44 lessons
1. KPI Selection and Dashboard LayoutArticle · 15 min
2. Interactive Filters and Conditional FormattingArticle · 18 min
3. Sales and Recruitment DashboardArticle · 21 min
4. Quality Checks and Management PresentationArticle · 24 min