Course

CERTIFICATE IN ADVANCED EXCEL


2 Months 3500 /-

Course Brief

  • Introduction to Advance Excel
  • Working with Rows and Columns, Cell References
  • Filling Series/ Custom List Conditional Formating
  • Maths And Trignometric Function
  • Logical Function
  • Data Validation Function
  • V/H Look up Function / Text Function
  • Function With Condition, Sumifs, Countiffs, Averageifs
  • Financial Function
  • Scenerio, Goal Seek & Solver
  • Database Function
  • Sorting, Sub Totaling, Auditing, Macro & Consolidate
  • Filtering of Data / Pivot Table and Chart
  • Split / Hyperlink to Database Freeze
  • Tracking Workbook Charge Protecting / Page Setup / MIS Report
  • Project on Excel With Assignment 

 YOU CAN BECOME ADVANCE COMPUTER OPERATOR....