₹3,000 ₹4,000

Course Includes

Duration2 Months
Enrolled0
Lectures40
Videos0
Notes0
CertificateYes

What you'll learn

Advanced Excel is used for data analysis, reporting, automation, and decision-making. It is very useful for office work, accounting, data analysis, MIS, and digital marketing.

Course Syllabus

1. Advanced Formulas & Functions

Logical: IF, IFS, AND, OR
Lookup: VLOOKUP, HLOOKUP, XLOOKUP
Indexing: INDEX, MATCH
Text: LEFT, RIGHT, MID, LEN, TRIM
Date & Time: TODAY, NOW, DATEDIF
Math & Stats: SUMIF, COUNTIF, AVERAGEIF

2. Data Analysis Tools

Pivot Tables & Pivot Charts
What-If Analysis
Goal Seek
Scenario Manager
Data Tables
Data Validation (drop-down lists)

3. Data Cleaning & Management

Remove duplicates
Text to Columns
Flash Fill
Conditional Formatting
Sorting & Filtering (Advanced Filter)

4. Charts & Dashboards

Column, Bar, Line, Pie Charts
Combo Charts
Interactive Dashboards
Slicers & Timelines

5. Automation

Macros
VBA (Visual Basic for Applications) – Basics
Automating repetitive tasks

6. Power Tools (Advanced Level)

Power Query – Data cleaning & transformation
Power Pivot – Large data handling
DAX Basics

Course Fees

₹4000/-

Discounted Fees

₹ 3000/-

Course Duration

2 Months

Review

0.0

Course Rating (0 reviews)

Featured review

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

CERTIFICATE In Advance Excel(S-AEWV-7526)