Upon completion of this workshop, participants will be able to:

• Build up data in Excel from scratch
  
• Deals with numerical data in Excel
  
• Basic Formulas & Functions in Excel
  
• Align text data in Excel
  
• Data Collection, gathering and matching by using the proper and accurate Methods.
  
• Using Power & Lookup functions - Inserting files & objects
  
• Hyperlink between different sheets
  
• Summarize and design the data quickly and accurately and report it with visual charts.
  
• Data Validation techniques
  
• Using Pivot Tables
  
• Date & Time Formatting & Calculations
  
• Useful Human Resources Functions for Excel
  
• The most common human resources sheets, formulas & metrics : (KPIS, Taxes, Insurance, Payroll Sheet,..)
  
• Introduction to Data Analysis Basics