Course

• 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....

ALSO JOIN KLiC ADV EXCEL COURSE AND GET YCMOU UNIVERSITY MARKSHEET & MKCL CERTIFICATE.