HDI

Course Includes

Duration2 Months
Enrolled1
Lectures60
Videos0
Notes0
CertificateYes

What you'll learn

The course begins with the Microsoft Excel, covering data entry, worksheet formatting, basic formulas, and commonly used functions. As learners progress, the course moves into Advanced Excel concepts, including logical functions, lookup and reference functions (such as VLOOKUP, HLOOKUP, INDEX–MATCH), text and date functions, Pivot Tables, Charts, Data Validation, and Conditional Formatting.

Advanced Formulas & Functions

🔹 Logical Functions

IF
AND
OR
Nested IF
IFS
IFERROR

🔹 Lookup & Reference

VLOOKUP
HLOOKUP
INDEX
MATCH
INDEX + MATCH (Advanced)
OFFSET
INDIRECT
CHOOSE

🔹 Text Functions

LEFT, RIGHT, MID
LEN
TRIM
CLEAN
CONCAT / CONCATENATE
FIND / SEARCH
SUBSTITUTE

🔹 Date & Time Functions

TODAY
NOW
DATE
EOMONTH
NETWORKDAYS
DATEDIF

2️⃣ Data Validation

Drop-down List बनाना
Input Message & Error Alert
Data Restriction Rules

3️⃣ Conditional Formatting

Highlight Cells Rules
Formula Based Formatting
Color Scales, Data Bars, Icons

4️⃣ Pivot Table & Pivot Chart

Pivot Table
Data Summarize
Pivot Chart
Slicer & Timeline

5️⃣ Advanced Charts & Dashboard

Dynamic Charts
Dashboard Design
KPI Indicators
Interactive Reports

6️⃣ What-If Analysis

Goal Seek
Scenario Manager
Data Table

7️⃣ Excel Security

Sheet Protection
Workbook Protection
Password Apply

Course Syllabus

Data Entry & Formatting

Data Enter (Text, Number, Date)
Font, Color, Alignment, Border
Cell Merge, Wrap Text
Number Formatting (Currency, Percentage)

3️⃣ Basic Formulas

Addition, Subtraction, Multiplication, Division
AutoSum
Relative, Absolute & Mixed Cell Reference

4️⃣ Basic Functions

SUM
AVERAGE
COUNT / COUNTA
MAX / MIN

5️⃣ Data Management

Sort & Filter
Find & Replace
Remove Duplicates

6️⃣ Charts & Graphs

Column Chart
Bar Chart
Pie Chart
Line Chart

7️⃣ Printing & Page Setup

Print Area
Page Layout
Header & Footer

Review

0.0

Course Rating (0 reviews)

Featured review

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

Call

Text Message

Review

CHAT

Certificate in Advance Excel(S-AE-3063)

Course Includes

What you'll learn

Advanced Formulas & Functions

🔹 Logical Functions

🔹 Lookup & Reference

🔹 Text Functions

🔹 Date & Time Functions

2️⃣ Data Validation

3️⃣ Conditional Formatting

4️⃣ Pivot Table & Pivot Chart

5️⃣ Advanced Charts & Dashboard

6️⃣ What-If Analysis

7️⃣ Excel Security

Course Syllabus

Data Entry & Formatting

3️⃣ Basic Formulas

4️⃣ Basic Functions

5️⃣ Data Management

6️⃣ Charts & Graphs

7️⃣ Printing & Page Setup

Review

Featured review

More Popular Courses

Certificate in Computer Operations(M-CA-8854)

Diploma In Financial Account(M-FA-3741)

Related Courses

Diploma in Computer Applications(M-CA-6831)

Diploma in Office Management(M-OM-9129)

Certificate In MS Excel & Tally Prime with GST(M-ME&TPWG-3232)