Advance Excel Course

Course Details

  • Introduction Ms Excel
  • School , Colleges , Education Sector Work.
  • MIS Executive Work
  • Sale Sector Reporting Work
  • Data Entry Work
  • Salary Slip and HR Reporting
  • Stock Maintenance Work
  • Excel Formatting Work
  • Column , Line , Pie , Bar Chart concept and Uses
  • Page Layout Setting , Scale, Area , Printing Concept
  • Conditional Formatting Concept
  • Data Number Category concept and uses
  • Creating Macros and Uses
  • Pivot Table and Chart concept
  • Data Analysis concept
  • Data Validation and Consolidate
  • Name Manager concept
  • Save Work space benefits and uses
  • Filter uses
  • Basic Formula and Function
  • Text Formula and Function
  • Financial Formula and Function
  • Lookup and Reference Function
  • Date and time Function
  • Logical Function
  • Math & Trig Function
  • Statistical Function

Application

  • Ms Excel
  • Internet

Career and Scope

  • Data Entry Operator
  • MIS Executive
  • Excel Executive