Excel For Hr Training Professionals | Simfotix

Excel for HR & Training Professionals

22 February 2018


AED 800

per participant

In just 2 days, HR Professionals will learn the tips that save hours to resolve the difficulties they face on a daily basis in doing employee compensations, salary, leave, benefits etc. In this practical training, participants will learn formatting techniques to convert data from different sources and how to make the best use of most important formulas for HR. They are able to manipulate charts and diagrams, use logical functions and link their spreadsheet to other worksheets and applications. You will learn to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
Course Outline
Excel Ice Breaking Session !
  • Brief ice breaking session to bring all participants on the same learning pace
  • Be Ready for quick questions and to learn daily use short cuts
Utilizing fill handle tricks
  • Formatting and editing a series
  • Using multiple worksheets and workbooks
  • Using special number formats – Custom Formatting
  • Using functions to format text
Working with Data
  • Outlining and subtotals
  • Outlining and consolidating data
  • Creating Nested subtotals
  • Creating and using names
  • Keyboard Shortcuts to use Names
  • Assigning values to Names
Chart & Filters
  • Filtering data
  • Advanced filtering for complex queries
  • Working with tables
  • Advanced charting techniques
  • Chart formatting options
  • Combination charts
  • Graphical elements
Pivot Tables
  • PivotTables and PivotCharts
  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • Formatting PivotTables
  • Extracting multiple reports with Pivot
  • Conditional formatting with PivotTable
Who Should Take This Course?
New and Experienced HR professionals from:

  • Compensation and Benefits Professionals
  • HR Reward and Payroll Professionals
  • HR Managers
  • Admin Professionals
  • Anyone who perform HR functions in their organizations on daily basis
Working Examples During the Course
  • Display first name, last name with prefix in one single column from three different columns
  • Find years of service of employees
  • Find the total salary expenses in different regions, different departments
  • Total number of employees in the company in different departments
  • Find the total salary given to employees of a particular department or designation in a particular month
  • Find number of employees joined on particular date/month in any department in any country
  • Calculate the bonus based on overall performance of an employee
  • Find the number of leaves taken by any employee, find the designation of an employee from his salary
  • Count number of directors or any designation in a company
  • Display the records according to department, by hire date, by salary etc.
  • Calculate the total overtime hours for employees for any month
  • View summarized salary for all the different countries in different departments
  • Set the status, department of an employee through data validation
  • Validate the hire date upon data entry
  • Calculate salary based on overtime hours
  • Calculate the net pay of an employee from his/her daily pay and leaves taken
  • Consolidate overtime hours and rate for two employees
  • Compare employee’s involvement in department from the working hours using charts
  • Find total number of employees working in specific department from specific dates
  • How to effectively calculate overtime hours using Excel
  • Track expiry of work permits and passports using conditional formatting
  • Identify the oldest employees at a glance using conditional formatting
  • How to profile employees using Pivot Table, Age formula
  • How to monitor training cost spending against training budgets using formulas
  • Monitor training hours clocked by employees, job grade, department, etc
Hands–On Training
Throughout this course, exercises provide you with experience applying Excel features, formulas and formatting. Hands-on exercises include:

  • Navigating the Excel interface for efficiency and speed
  • Formatting existing data for greater visual impact
  • Designing formulas to manipulate, summarize and refine raw data
  • Troubleshooting and tracing formula errors
  • Charting your data for clearer presentation
  • Solve your real time work problems and learn from one of the best GCC Trainer.
  • Linking worksheets with references
Course Facilitator
Ramzan Rajani
Microsoft Certified Trainer
Microsoft Office Specialist
ITIL FoundationMr. Ramzan Rajani carries more than 8 years of experience in the field of IT Training & Project Management. After getting a Diploma in Information Technology, he did his MBA with Dual specialization in IT and Project Management. He has experience of designing, managing & implementing large databases bearing very good understanding and extensive experience in Advance Excel, VBA – Macros, advance PowerPoint, Excel Dashboard, Access & MSP (Microsoft Project 2010). Many participants from large number of companies in GCC region have attended his programs as public and inhouse sessions. Some of these companies include: The Executive Council of Dubai, Ferrari World, General Civil Aviation Authority, Etisalat, National Bank of Fujairah, Roche Diagnostics, Abu Dhabi Finance, Thuraya, DEWA, Emirates Post, Dubai World, Majid Al Futtaim Group, RAK Cement, Tamkeen, Tawam Hospital, Imdaad Group, Wild Wadi, Al Etihad Credit Bureau, IFC (WorldBank Group), Emirates NBD, Sharjah Islamic Bank, RedBull, CareStream Health, Rotana, Funcity, Johnson & Johnson, Mastercard, Internet City, Manipal University , Dulsco, AstraZeneca (Pharma)…etc.