HDI

₹4,500 ₹6,000

Course Includes

Duration3 Months
Enrolled1
Lectures60
Videos0
Notes0
CertificateYes

What you'll learn

The Certificate in Advanced Excel course is designed to equip students with practical, job-oriented Excel skills used in accounting, business, MIS reporting, and data analysis.

This course focuses on real-world applications, enabling learners to handle large datasets, automate tasks, and create professional reports & dashboards.

By the end of the course, students will be able to:

Analyze and manage data efficiently
Use advanced formulas and functions
Create dashboards and MIS reports
Automate work using basic macros
Apply Excel in accounting & office work

Course Syllabus

🔹 Module 1: Excel Basics Revision

Interface & Workbook management
Formatting (Cells, Rows, Columns)
Basic formulas (SUM, AVERAGE, COUNT)
Shortcut keys for productivity

🔹 Module 2: Advanced Formulas & Functions

Logical Functions (IF, AND, OR, Nested IF)
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Text Functions (LEFT, RIGHT, MID, LEN, CONCAT)
Date & Time Functions
Financial functions (PMT, NPV – basic intro)

🔹 Module 3: Data Handling & Analysis

Sorting & Filtering (Advanced Filter)
Data Validation
Conditional Formatting
Remove Duplicates
Text to Columns

🔹 Module 4: Pivot Tables & Pivot Charts

Creating Pivot Tables
Grouping & Summarizing Data
Slicers & Filters
Pivot Charts for reporting

🔹 Module 5: Charts & Visualization

Column, Bar, Pie, Line Charts
Combo Charts
Data Presentation techniques
Formatting charts professionally

🔹 Module 6: Dashboard Creation

KPI-based dashboards
Interactive reports using slicers
Real-time data visualization
MIS Report designing

🔹 Module 7: Advanced Tools

What-if Analysis
Goal Seek
Scenario Manager
Data Tables

🔹 Module 8: Introduction to Macros & Automation

Recording Macros
Basic VBA understanding
Automating repetitive tasks

🔹 Module 9: Excel for Accounting & Office Work

Salary Sheet
GST Sheet (basic format)
Invoice & Billing format
Stock Management Sheet

Course Fees

₹6000/-

Discounted Fees

₹ 4500/-

Course Duration

3 Months

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 Advanced Excel(S-AE-3639)

Course Includes

What you'll learn

Course Syllabus

🔹 Module 1: Excel Basics Revision

🔹 Module 2: Advanced Formulas & Functions

🔹 Module 3: Data Handling & Analysis

🔹 Module 4: Pivot Tables & Pivot Charts

🔹 Module 5: Charts & Visualization

🔹 Module 6: Dashboard Creation

🔹 Module 7: Advanced Tools

🔹 Module 8: Introduction to Macros & Automation

🔹 Module 9: Excel for Accounting & Office Work

Course Fees

Review

Featured review

More Popular Courses

ADVANCE DIPLOMA IN COMPUTER APPLICATION(M-CA-1406)

CERTIFICATE In COMPUTER CONCEPTS(S-CC-3443)

Related Courses