Back to Services & Courses
1.5 Months ProgramCareer Skill
Advanced Excel & Business Analytics
Level up from basic sheets to dynamic formulas, advanced lookups, pivot tables, data cleaning, and executive dashboard reporting.
Target: Students, College Graduates & Beginners in Data
Duration: 1.5 Months
Mhaska In-Person Lab
Complete Fee
2000All inclusive
- Individual PC assigned for every class
- Real capstone projects & exercises
- Verified QR Certificate upon completion
Structured Syllabus
Course Curriculum & Modules
Module 112 Hours
Module 1: Advanced Formula Ecosystem
Nested IFs, SUMIFS, COUNTIFS, AVERAGEIFS, dynamic lookup functions (XLOOKUP, INDEX/MATCH).
Module 210 Hours
Module 2: Data Cleaning & Text Manipulation
Flash Fill, Text-to-Columns, TRIM, CONCAT, data deduplication, and input validation.
Module 312 Hours
Module 3: Pivot Tables & Multi-Dimensional Analysis
Grouping data, calculated fields, timeline filters, slicers, and summary metrics.
Module 414 Hours
Module 4: Dynamic Dashboard Construction
Interactive KPIs, sparklines, chart styling, and executive summary reporting.
Practical Capstone Projects
Retail Sales Performance Dashboard with Slicers
Students build and present this project before course graduation.
Student Attendance & Grading Automated Gradebook
Students build and present this project before course graduation.
Inventory Stock Reorder Tracker
Students build and present this project before course graduation.
Expected Learning Outcomes
- Clean and structure messy real-world datasets with ease
- Extract critical business insights using advanced lookup algorithms
- Construct automated interactive dashboards for academic and professional reporting
Class Format & Lab Schedule
Batch Timing:Morning: 9:00 AM – 11:00 AM | Evening: 4:00 PM – 6:00 PM
Days:Monday to Friday (Saturday open for optional practice lab)
Location:TechGrow Academy Campus, Mhaska, Maharashtra
Course FAQ
Basic familiarity with opening spreadsheets is recommended. We refresh foundational concepts in the first 2 sessions.