About This Program
The Advanced Excel course is designed for learners who want to develop strong spreadsheet, data-management, reporting, and analysis skills. It is suitable for students, office employees, accountants, business owners, and job seekers.
Students learn advanced formulas and functions, data organization, sorting and filtering, conditional formatting, charts, data analysis, PivotTables, reporting, and practical business spreadsheet techniques. The course emphasizes real-world exercises and professional reporting.
Key Skills: Advanced Formulas, Functions, Data Cleaning, Sorting & Filtering, Conditional Formatting, Charts, PivotTables, Data Analysis, Reports and Spreadsheet Automation Concepts.
Career Opportunities: MIS Executive, Excel Executive, Data Processing Executive, Reporting Executive, Office Executive, Accounts Assistant and Business Support Executive.
Comprehensive Syllabus
6 Modules-
Introductio• Excel interface and workbook management • Worksheets and multiple-sheet operations • Data entry and formatting • Cell references: Relative, Absolute & Mixed • Named ranges • Advanced form Preview1.5 Hours
-
• Mathematical and statistical functions • SUM, AVERAGE, MIN, MAX • COUNT, COUNTA, COUNTIF, COUNTIFS • SUMIF and SUMIFS • AVERAGEIF and AVERAGEIFS • IF, nested IF and IFS • AND, OR, NOT • IFERROR • VL
-
• Sorting and advanced filtering • Advanced Filter • Removing duplicates • Text to Columns • Flash Fill • Data cleaning • Data validation lists • Excel Tables • Subtotals • Grouping and outlining • Pi
-
• Choosing appropriate chart types • Column and bar charts • Line and area charts • Pie and doughnut charts • Combination charts • Dynamic charts • Sparklines • Interactive dashboards • KPI cards • Da
-
• Introduction to Power Query • Importing data from Excel and CSV files • Importing data from folders • Data cleaning with Power Query • Merge and Append queries • Transforming columns and data types
-
• Business data analysis • Sales dashboard project • Inventory management project • Employee attendance and payroll report • Expense and budget tracker • Customer database • Financial reporting basics
Related Academic Programs
Admissions Open 2026-27
₹36,000
₹45,000
Inclusive of all course materials, lab access & certification.
- Duration: 6 Months
- Delivery Mode: Hybrid
- Course Level: Professional
- Eligibility: 10+2 or Equivalent
- Accreditation: ISO 9001:2015 Verified