₹3,000 ₹5,000

Course Includes

Duration01 Months
Enrolled3
Lectures10
Videos0
Notes1
CertificateYes

What you'll learn

Advanced Excel focuses on powerful tools and techniques used for data analysis, reporting, and automation. It covers advanced formulas, functions, and features that help users manage large datasets, perform complex calculations, and create dynamic dashboards. Learners gain hands-on experience with data visualisation, Pivot Tables, macros to improve efficiency and decision-making. This course is ideal for students and professionals who want to enhance productivity and apply Excel in real-world business scenarios.

Show More

Course Syllabus

Microsoft Advanced Excel

Recap of Basic Excel Tools & Practicals
Advanced Date Functions
Stock Management System
Financial Functions (PMT/PPMT/IPMT/Etc)
Consolidate Function
SUMIF & SUMIFS
Advanced VLOOKUP
LOOKUP + MATCH
LOOKUP in Multiple Sheet
Double LOOKUP in Multiple Wookbooks
Advanced Attendance Sheet
Automated Fee Management System
Advanced Pivot Tables & Slicer
Pivot Chart/ Timeline/Graphs
Automated P& L Account
Common Errors in Excel
Automated Salary Sheet
Data Validation & Restrictions
Advanced Paste Special Tool
Data Dashboard (MIS)
Hotel Booking System
Fee Record with Graphs
Automated Certificated
Paste Special Tools
Retail Management System (MIS)
Automated Certificate Generation using Word
MIS Dashboard (Format Making)
2 Final Major Projects
Multiple Employee ID Card Generate using Word
Automated Multiple Report Card Generate for Students & Parents

Course Fees

Course Fees

:

₹5000/-

Discounted Fees

:

₹ 3000/-

Course Duration

:

01 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!

Copyright © 2026 Excellent Educational Hub. All Rights Reserved

Review