Advanced Excel for HR

Code : IT002
Request In-house Training Proposal

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.

 

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

 

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.

 

Course Details
Personal Details
ACAD Professional Certificate - APC
ACAD Training & Consulting uses the power of its network to bring about positive, tangible change. We champion the training courses profession and the interests of individuals, engaged in that profession, for the benefit of all. ACAD Professional Certificates are designed for those who are enthusiastic to challenge themselves to reach the extra mile. Participants who fully attend an APC course and successfully pass the exam on the last training day, will receive an ACAD Professional Certificate (APC). APC are regionally recognized and can be esteemed when applying for more senior roles in Egypt and MENA region.

Exam Details:

Duration: 1 hour | Multiple Choice | Closed book | Pass mark: 65%

Course Schedule

Course Location and Date

29 Nov - 03 Dec
Cairo | Instructor-led
$2250
5 Sessions

Course Location and Date

03 - 07 Jan 2021
Cairo | Instructor-led
$2250
5 Sessions

Search in Courses