₹9,000 ₹15,000

Duration3 Months
Enrolled0
Lectures72
Videos0
Notes0
CertificateYes

What you'll learn

This program is designed for working professionals, graduates, and students who want to gain advanced data analysis, reporting, and automation skills using Microsoft Excel. The course covers advanced formulas, data cleaning, Pivot Tables, dashboards, MIS reporting, and basic automation tools to handle large data sets efficiently. Learners gain hands-on experience in creating professional reports and automated solutions used in corporate offices, accounts departments, and business environments.

Course Syllabus

📘 Syllabus

Module 1: Excel Foundation & Productivity

Excel interface, shortcuts & workbook management
Data formatting, custom formats & productivity tips

Module 2: Advanced Formulas & Functions

Logical functions (IF, IFS, Nested IF)
Lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH)
Text, Date & Time functions
Statistical & Financial functions
Error handling functions

Module 3: Data Cleaning & Validation

Data validation rules
Conditional formatting (advanced)
Remove duplicates, Flash Fill, Text to Columns
Data structuring techniques

Module 4: Pivot Tables & Pivot Analysis

Pivot Table creation & customization
Pivot Charts & slicers
Advanced Pivot calculations
Dynamic reporting using Pivot

Module 5: Dashboard & MIS Reporting

Chart types & visual best practices
Interactive dashboards
Management Information System (MIS) reports
Business-ready presentation techniques

Module 6: Automation & Advanced Tools

Macro recording & basics of VBA concepts
Introduction to Power Query
Automated data refresh & report generation
Practical automation examples

Course Fees

₹15000/-

Discounted Fees

₹ 9000/-

Course Duration

3 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

Certificate In Advanced Excel(S-AE-1474)