₹15,000 ₹21,000

Duration60 Days
Enrolled0
Lectures60
Videos0
Notes0
CertificateYes

What you'll learn

Advanced Excel refers to the use of powerful tools, formulas, and features in Microsoft Excel that help in data analysis, automation, reporting, and decision-making. It goes beyond basic calculations and makes complex tasks easy and fast.

📌 Key Features of Advanced Excel

1. Advanced Formulas

VLOOKUP / HLOOKUP
XLOOKUP
IF, AND, OR
COUNTIF / SUMIF / AVERAGEIF
INDEX–MATCH

Used for searching, comparing, and analyzing data.

2. Data Analysis Tools

Pivot Table & Pivot Charts
What-If Analysis
Scenario Manager
Goal Seek

Helps summarize large data and make decisions.

Course Syllabus

. Excel Essentials (Refresher)

Excel interface & shortcuts
Workbook and worksheet management
Data entry, formatting & cleanup
Data validation (Drop-down lists, rules)

2. Advanced Formulas & Functions

Logical Functions

IF, AND, OR, NOT
Nested IF

Lookup & Reference Functions

VLOOKUP
HLOOKUP
INDEX–MATCH
XLOOKUP

Math & Statistical Functions

SUMIF, SUMIFS
COUNTIF, COUNTIFS
AVERAGEIF, AVERAGEIFS

Text Functions

LEFT, RIGHT, MID
LEN
TRIM
CONCAT / TEXTJOIN

Date & Time Functions

TODAY, NOW
DATEDIF
EDATE / EOMONTH

3. Data Analysis Tools

Sort & Filter (Advanced filter)
Conditional Formatting
Flash Fill
Remove Duplicates
What-If Analysis
Goal Seek
Scenario Manager
Data Tables

4. Pivot Tables & Pivot Charts

Creating Pivot Tables
Grouping data
Calculated fields
Pivot Charts
Slicers & Timelines

5. Data Visualization

Line, Bar, Pie charts
Combo charts
Sparklines
Formatting dashboards
Chart customization

6. Power Tools

Power Query
Import data
Transform & clean data
Merge & append queries
Power Pivot
Data models
Relationships
DAX basics

7. Automation in Excel

Introduction to Macros
Recording Macros
Basic VBA (optional)
Automating repetitive tasks

8. Professional Reporting

Building Excel dashboards
Financial & MIS reports
KPI reports
Printing & page setup

9. Practical Projects

Sales report dashboard
HR attendance tracking
Inventory analysis
Budget & forecast model
Data cleaning exercises

Course Fees

₹21000/-

Discounted Fees

₹ 15000/-

Course Duration

60 Days

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-4670)