2 Months · Certificate Included
Advanced Excel
Master Microsoft Excel with practical training. Learn advanced formulas, dashboards, reporting, data analysis and automation skills used in real Jaipur offices.
Course Details
- Duration: 2 Months
- 100% Practical Training
- Certificate Provided
- Live Project Practice
- Job Oriented Training
Course Syllabus
- Advanced Excel Formulas & Functions
- IF, Nested IF, SUMIF, COUNTIF
- SUMIFS & COUNTIFS
- VLOOKUP, HLOOKUP & XLOOKUP
- INDEX & MATCH Formula
- Data Cleaning Techniques
- Conditional Formatting
- Data Validation
- Pivot Table & Pivot Chart
- Excel Dashboard Creation
- Professional Reports
- Power Query Basics
- Excel Automation Basics
Benefits
- Become an Excel Professional
- Useful for Accountant Jobs
- Improve Office Skills
- Create Business Reports
- Increase Productivity