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
Course Features
- Lectures 29
- Quizzes 0
- Duration 15 Hours
- Skill level All levels
- Language Arabic
- Students 852
- Assessments Yes
Target audiences
- HR professionals
- Non-professional HR
- Excel Beginners
