Excel and Advanced Excel

Program Content and Objectives:

This program is specially designed for students willing to work as an office administrator, back or front office executive etc. Working professionals who wish to enhance their administrative skill with excel may also join this course. After completion candidate can work efficiently in MS-Excel with advanced features.

 

Course highlights  
  • Introduction to Excel
  • Formatting
  • Usage of formula
  • Implementing Functions – Mathematical Function, Statistical function, String & Date functions.
  • Creating Chart
  • Implementing different types of chart & chart modification
  • Pivot table & Chart
  • Auto & Advanced Filter
  • Linking between two workbook & worksheet
  • Validation
  • Page Layout
  • OLE
  • Goal Seek, Solver , Scenario
  • VLookup, HLookup
  • Protecting worksheet, workbook
  • Cell Referencing
  • Absolute Cell Referencing
  • Macro
 
 

Course Duration

Entry Profile

36 Hours

Students , Graduates in any stream , Working Professionls.

 
Certificate & Placement
Certificate & Placement assistance will be provided to successful candidates only