MS Excel 2010 HR

Human resource professionals frequently fill out a lot of forms and keep track of many types of data, ranging from employee headcount file to career development programs. Now with Excelyou can simplify these tasks, and spend more time on people and less time on paper.

Module 1: Summarizing data

  • Creating Summary report with Subtotal
  • Creating Summary report with Pivot
  • Refreshing & Changing PivotTable Range
  • Creating sheets from Pivot table
  • Generating report on the basis of dates

Module 2: Charts

  • Creating charts on Joining & Attrition data
  • Creating % chart to show the Headcount
  • Creating Dynamic Charts
  • Adding Target Line in chart
  • Method of pasting chart into PowerPoint

Module 3: Conditional Formatting

  • Formatting Headcount file with different criterias
  • Highlight & Removing Duplicate Employee ID

Module 4: Arranging &Filtering data

  • Sorting data with Multiple Level Sorts
  • Advance Filtering on more than 1 Criteria
  • Different ways of filtering data

Module 5: Functions

  • Statistical : Count, CountA, CountIF, CountBlank, Average & Average IF
  • Lookup : Vlookup & Hlookup --
  • Text : Upper, Lower, Proper, Trim & Concatenate -- Math : Sum & SumIF
  • Logical : IF Condition with Multiple Ifs, using AND & OR in IF’s


 
Student Community Apply online FAQ Course Calendar
  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...

  • Will be updated soon...


+971 4 396 44 55