Advance Excel Course
20+ Years Experience • 5000+ Students Trained • Govt. Approved Certificate
Book Free Demo Class Call NowCourse Overview
Become an Excel expert with practical training on formulas, functions, Pivot Tables, Dashboards, Charts, Data Analysis and Office Automation.
Complete Syllabus
Module 1
Excel Interface, Workbook, Formatting, Data Validation, Conditional Formatting
Excel Interface, Workbook, Formatting, Data Validation, Conditional Formatting
Module 2
IF, IFS, SUMIF, COUNTIF, ROUND, TEXT, LEFT, RIGHT, MID
IF, IFS, SUMIF, COUNTIF, ROUND, TEXT, LEFT, RIGHT, MID
Module 3
VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, Dynamic Lookup
VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, Dynamic Lookup
Module 4
TODAY, NOW, DATE, DATEDIF, EDATE, NETWORKDAYS
TODAY, NOW, DATE, DATEDIF, EDATE, NETWORKDAYS
Module 5
Pivot Table, Pivot Chart, Timeline, Slicers, Dashboards
Pivot Table, Pivot Chart, Timeline, Slicers, Dashboards
Module 6
Sort, Filter, Advanced Filter, Remove Duplicates, Text to Columns, Flash Fill
Sort, Filter, Advanced Filter, Remove Duplicates, Text to Columns, Flash Fill
Module 7
Charts, Combo Chart, Dynamic Charts, Conditional Charts
Charts, Combo Chart, Dynamic Charts, Conditional Charts
Module 8
Hyperlinks, Templates, Print Settings, Page Layout, Workbook Security
Hyperlinks, Templates, Print Settings, Page Layout, Workbook Security
Course Features
- 100% Practical Training
- Real Office Projects
- Dashboard Creation
- MIS Report Preparation
- Expert Faculty
- Small Batch Size
- Govt. Approved Certificate
- Job Assistance
- Free Demo Class
Career Opportunities
- MIS Executive
- Data Analyst (Entry Level)
- Back Office Executive
- Office Executive
- Accounts Executive
- Excel Specialist