Why Attend This Training Course?

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.

What Is The Training Course Methodology?

This training course methodology depends on enabling participants to interact and exchange experiences, explore their competencies and achieve their career aspirations, using forward-thinking training arts, such as theoretical lectures and/or open discussion to exchange opinions and experiences, scenarios, innovative thinking brainstorming. Participants will receive an agenda including training material as a reference, in addition to some extra notes and booklets. 

Who Should Attend This Training Course?

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.

What Are The Training Course Objectives?

• Creating advanced excel formulas using the most effective functions

• Validating data entries, protecting workbooks and handling errors

• Generating reports, pay slips, and organization chart

What Is The Training Course Curriculum?

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.