Excel for HR Workshop

Overview

• Learn Excel for HR to can creating spreadsheets in Excel. Enter data, formulas, format, and print workbooks.

Learning outcome of Excel for HR:

• Create a worksheet with a function
• Perform calculations in an Excel worksheet.
• Modify an Excel worksheet
• Manage Excel workbooks.
• Insert and modify illustrations in a worksheet.
• Learn to work with tables.
• Learn to use conditional formatting and styles.

What You Will Cover

• Program Interface
• Navigation & Selection
• Format Cell
• Count Family Functions
  • Count
  • Counta
  • Count blank
  • Countif
  • Countifs
• Subtotal
• Date and Time Family
  • Now
  • Today
  • Day
  • Month
  • Year
  • Datedif
  • Eomonth
  • Edate
  • Days360
• VLOOKUP
• Conditional Functions
  • If – And – Or
• Conditional Formatting
• Data Validation
• Create Reports