Reality of Advanced Excel:
Advanced Excel skills include the ability to turning your ideas into reality in the digital space or Excel Sheet. It is not about functions/formula only, we using excel to easy our work using functions/formula.
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