Welcome to Excellent Educational Hub

Excellent Educational Hub provides quality Computer Classes. All Computer Courses are available - Basic Computer Course, D.C.A, D.F.A, C.F.A, A.D.C.A, Tally Erp 9 & Prime with GST, HTML & CSS, Web Developent, Digital Marketing , Advance excel, MIS ec.

CERTIFICATE IN ADVANCED EXCEL ( S-03 )

BASIC INFORMATION

  • Course Fees : 3000.00 5000.00/-
  • Course Duration : 1 MONTH
  • Minimum Amount To Pay : Rs.1000.00

 Microsoft Advanced Excel

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