BALAJI COMPUTER CENTER

₹4,000 ₹5,000

Course Includes

Duration3 Months
Enrolled0
Lectures80
Videos1
Notes1
CertificateYes

What you'll learn

Students, accountants, managers, business professionals
Basic Excel knowledge required (should know cell-editing, SUM, basic formatting)
Anyone who wants to master Excel for real-world projects

Show More

Course Syllabus

Introduction: Interface, navigation, customizing Excel, shortcuts
Data Handling: Clean, organize, validate, remove duplicates
Advanced Formulas: IF, AND, OR, SUMIF/SUMIFS, COUNTIF(S), AVERAGEIF(S), IFERROR
Lookup/Reference: VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, CHOOSE
Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, PROPER, UPPER, LOWER
Statistical & Mathematical: RANK, ROUND, ARRAY formula basics
Pivot Tables & Pivot Charts: Creating, customizing, grouping, calculated fields
Conditional Formatting & Data Visualization (advanced charts)
Data Validation & Drop-downs
What-If Analysis: Goal Seek, Scenario Manager, Solver
Dashboards: Dynamic tables/charts, interactive interface building
Printing, exporting, protecting data

Course Fees

Course Fees

:

₹5000/-

Discounted Fees

:

₹ 4000/-

Course Duration

:

3 Months

Review

0.0

Course Rating (0 reviews)

0%

0%

0%

0%

0%

Featured review

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

Please provide your details to continue with the purchase

First Name *

Last Name *

Mobile Number *

Email *

Password *

Date of Birth *

Pincode *

Address *

Total Amount:

Copyright © 2026 DITRP INDIA. All Rights Reserved

Review