Office Productivity
MS Excel for Office & MIS Reporting
Learn spreadsheets from formulas and formatting to lookup functions, PivotTables, charts and practical MIS reports used by office, operations and back-office teams.
Provided by HiringMart India
About this course
Learn spreadsheets from formulas and formatting to lookup functions, PivotTables, charts and practical MIS reports used by office, operations and back-office teams.
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
Spreadsheet Foundations / मॉड्यूल 14 lessons
1. Workbook, Worksheet and Cell NavigationArticle · 15 min
2. Data Entry, Number Formats and Clean LayoutsArticle · 18 min
3. Relative, Absolute and Mixed ReferencesArticle · 21 min
4. Essential Keyboard ShortcutsArticle · 24 min
Formulas and Functions / मॉड्यूल 24 lessons
1. SUM, AVERAGE, MIN, MAX and COUNTArticle · 15 min
2. IF, AND, OR and Nested LogicArticle · 18 min
3. Text Functions for Cleaning DataArticle · 21 min
4. Date and Time FunctionsArticle · 24 min
Data Management / मॉड्यूल 34 lessons
1. Sort, Filter and Structured TablesArticle · 15 min
2. Remove Duplicates and Data ValidationArticle · 18 min
3. Conditional Formatting and Error ChecksArticle · 21 min
4. Lookup Functions: VLOOKUP and XLOOKUPArticle · 24 min
MIS Reporting Project / मॉड्यूल 44 lessons
1. PivotTables and GroupingArticle · 15 min
2. Charts and KPI SummariesArticle · 18 min
3. Daily Attendance and Operations MISArticle · 21 min
4. Build and Present a Monthly MIS ReportArticle · 24 min