Advanced Excel for HR

12/10

Code Date Venue Fees Registration
12/10 24 - 28 Mar 2019 Cairo 1600 USD Register Now
12/10 14 - 21 Jul 2019 Dubai 2250 USD Register Now
12/10 08 - 12 Sep 2019 Cairo 1600 USD Register Now

This 24-Hours workshop is designed especially for HR specialists and experts, to cover the tools and skills that increase their efficiency and productivity, and how to use Excel to perform their work in not only payroll, personnel, and recruitment, but also in general tasks that are related to most HR functions. This includes making quick and accurate calculations of salary additions and deductions such as taxes and insurance, applying performance appraisal, applying penalties, calculating overtime, organizing employees’ data, preparing outstanding reports, and generating the organization chart. All according to the latest updates of Egyptian laws and rules.

 

Prerequisite:

Attendees need to have basic knowledge of Excel. This is not a basic or extended systematic course. Attendees are expected to have ability to perform basic tasks like writing and formatting data, sheets and cells, basic calculations, using tables, sorting and filtering, saving and printing workbooks. This prerequisite can be met by attending a basic Excel course, or having equivalent work experience.

 

The training is aimed at HR professionals who want to walk through a new aspect of integrating Excel in their work environment.

 

Goals of the Training:

  • Creating advanced excel formulas using the most effective functions
  • Validating data entries, protecting workbooks and handling errors
  • Generating reports, pay slips, and organization chart

 

Course Modules:

Module 1: Excel formulas and functions basics review

Module 2: Using logical functions in Excel to get results based on conditions

Module 3: Protecting workbooks and worksheets

Module 4: Enhancing Excel calculations using power functions

Module 5: Reusing data differently by using lookup functions

Module 6: Manipulate and refine text using text functions

Module 7: Making the most complicated date and time calculations in Excel

Module 8: Handling formula errors and validating data

Module 9: Using conditional formatting

Module 10: Preparing reports using PivotTables and charts

Module 11: Preparing the pay slips using Excel and Word

Module 12: Preparing the organizational chart using Excel and Visio

 

Hands-on Tasks:

Bring your own laptop to run and follow up the exercises and tasks provided by the instructor. To be sure that you can perform all tasks, Office 2010 or later version is required. Office 2007 users will find lack of some features and functions used during the exercises, in addition to some differences in the user interface and commands paths changes.

 

For the organization chart preparation, Microsoft Visio is required. We use Visio 2016 in the training. We recommend the latest version because Visio, unlike Excel and Office suite, usually comes with major enhancements and new features every release.

 

Instructor:

Ayman Hassan has been working with Excel since 2006. He used the different versions of the software starting with Office 2000 up to Office 2016. He delivered courses on Excel and Office using Excel 2007 and all later versions to wide range of audiences including HR managers, seniors and specialists, senior accountants and financial managers, Engineers, teachers, and students. He teaches this course since 2014.

 

More info at: http://eg.linkedin.com/in/aymanhassanmct


Apply now
Course Details
Personal Details

Search in Courses

Download Training Plan 2018

Register Upcoming Courses