Microsoft Excel (Formulas & Data Analysis)
Spreadsheets, 100+ formulas, Pivot Tables, VLOOKUP, XLOOKUP, data charts, and conditional formatting.
Office Automation
35 Days (70 Hours)
1 Chapters
Certification Test Available
About This Course
Master spreadsheets for accounting, office analysis, and business reporting. Learn cell referencing, basic to advanced formulas (SUM, AVERAGE, IF, nested IF, SUMIFS, COUNTIF, VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH), Data Validation, Sorting & Filtering, Pivot Tables, and Interactive Charts.
Course Curriculum & Chapters
1 Lessons
1
Chapter 1: Excel Formulas, Referencing & Data Functions
Master rows, columns, Name Box, Formula Bar, Absolute Referencing ($), SUM, IF, COUNTIF, and VLOOKUP.
Theory
Practical
Video
Q&A
What You'll Learn
- Complete conceptual theory and architectural background.
- Step-by-step practical laboratory procedures.
- 50+ Real-world keyboard shortcuts and time-saving tricks.
- High-frequency interview & viva examination Q&A.
- Chapter-wise revision notes and test readiness checks.