Welcome to KAMAL SIR ACADEMY

WELCOME TO KAMAL SIR ACADEMY,              Admission open for year 2025 -26                                    

 

CERTIFICATE IN ADVANCE EXCEL ( S-ADVANCE  EXCEL )

BASIC INFORMATION

  • Course Fees : 5000.00 10000.00/-
  • Course Duration : 3 MONTHS
  • Minimum Amount To Pay : Rs.5000.00
  • Introduction to Excel.
  • Cell Referencing outside of the WorkBook, Subtotals, Protection of Cell, Sheet, WorkBook, Excel File.
  • Compute and Analyze data with certain Functions.
  • Extract and Compute data with certain Functions.
  • Logical, String, Financial, Information and Numeric Functions
  • Predicting trend with Statistical functions.
  • Searching Data with Lookup, Vlookup, Hlookup.
  • Manipulating Date and Time using Functions
  • Predicting trend and Dsum Functions
  • What If Functions and Data Importation
  • Pivot Tables and Charts
  • Power Query Function
  • Filtering, Sorting & Subtotalling Lists
  • Macro and Printing Excel Data

any student