ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
2
Most read
www.excel-for-hr.com 1
Excel For HR
Course content
HR Database
? Database basics
? How to Create an HR Database Using Microsoft Access
? Case study (Rec database )
Dealing with Data
? Importing & Exporting data
? How to create live reports
? How to create HR reports using pivot table
? Case study ( HIRS + reports )
Com & Ben Using Microsoft Excel
? Building live payroll sheet
? HR formulas ( insurance , tax, penalties)
? New way for calculation
? Case study (payroll formulas)
? Monthly variables
? Case study ( Employees loans )
Attendance
? Time formulas
? Case study (Man Power Plan)
? Case study (Man Power Plan new way )
? Advanced HR formulas
? Case study (HR variable )
? Case study (create Leave sheet )
Another useful Excel for HR Applications
? Mail merge
? Case study( Payroll slip , sending other mails )
? Using Microsoft excel in job posting (new way )
? Linking Excel with Visio
? Case study (org chart )
? Case study (org chart , more accurate way)
? Org chat reports
www.excel-for-hr.com 2
? Some advanced tools
? Case study (payroll revision )
? Some Excel for HR templates
Instructor
Mr. Walid Al Wakeel
? More than 16 years' experience in HR filed including 8 years in managerial position.
? HR consultant in Egypt, UAE and Libya
? Founder of Excel for HR course in Egypt
Duration
? 24 Hours
Price
? 550
Ad

Recommended

Excel for hr
Excel for hr
Walid Al Wakeel
?
L5 sornl
L5 sornl
Lida015
?
Cep present summary
Cep present summary
KnightMaster2
?
Alic-Matt 1-26-17
Alic-Matt 1-26-17
Matt Alic
?
Berea analytics & Reporting Tool (BART)
Berea analytics & Reporting Tool (BART)
Robert Hosking
?
?????????????????????
?????????????????????
Adithap Jinakeaw
?
5 Best Practices For Recruitment Tracker Template Excel.docx
5 Best Practices For Recruitment Tracker Template Excel.docx
Saira Khalid
?
10452 Human Resources Payroll Reporting Decentralizing Reporting And Automa...
10452 Human Resources Payroll Reporting Decentralizing Reporting And Automa...
robrow01
?
HRIS assignment on Application of MS Office software (Word, PowerPoint, Excel...
HRIS assignment on Application of MS Office software (Word, PowerPoint, Excel...
Farhan Shehab
?
6 Steps To Set Up HR Management System In Excel.docx
6 Steps To Set Up HR Management System In Excel.docx
Saira Khalid
?
HOW IT IS BENEFICIAL IN HUMAN RESOURCES MANAGEMANT
HOW IT IS BENEFICIAL IN HUMAN RESOURCES MANAGEMANT
Nitesh Chaturvedi
?
Asmi Budget Monitoring Presentation 2010
Asmi Budget Monitoring Presentation 2010
aharker
?
Using open source BI. Practical experience 2012 - En
Using open source BI. Practical experience 2012 - En
Serge Ivanko
?
Resume_Cheryl Hunnicutt 2015 no address
Resume_Cheryl Hunnicutt 2015 no address
Cheryl Hunnicutt
?
hargrove_resume (July 2015)
hargrove_resume (July 2015)
Matt Hargrove
?
3 11 Ri Event @ New Horizons Pvd
3 11 Ri Event @ New Horizons Pvd
Mike Gilronan
?
Solution de gestion de paie : PAYOHR
Solution de gestion de paie : PAYOHR
senejug
?
Shelly_Weber_resume (3)
Shelly_Weber_resume (3)
Shelly Weber
?
5.11 lowry
5.11 lowry
muhamad nawawi
?
Malini Ray resume
Malini Ray resume
Malini Ray
?
How To Automate Part 1
How To Automate Part 1
Sean Durocher
?
Session 1 businessdashboardpresentation-christensen
Session 1 businessdashboardpresentation-christensen
IMA Columbia Chapter
?
Subhojit_Chaudhuri
Subhojit_Chaudhuri
Subhojit Chaudhuri
?
PremKumarTR_Programmer
PremKumarTR_Programmer
premrmdv
?
MZazzera.DChurch.SAP_HR_Hyperion_Planning.presentationvFINAL
MZazzera.DChurch.SAP_HR_Hyperion_Planning.presentationvFINAL
Michael Zazzera
?
Our Compliance Plan Templates and Tracking Worksheets
Our Compliance Plan Templates and Tracking Worksheets
John E Griggs, Ph.D.
?
Are you up to date with OASE?
Are you up to date with OASE?
Xylos
?
Fractal Enterpise Model (FEM) - a tutorial
Fractal Enterpise Model (FEM) - a tutorial
Ilia Bider
?
Strategic hr using balance score cards
Strategic hr using balance score cards
Walid Al Wakeel
?
Advanced hr diploma
Advanced hr diploma
Walid Al Wakeel
?

More Related Content

Similar to Excel for hr cairo (20)

HRIS assignment on Application of MS Office software (Word, PowerPoint, Excel...
HRIS assignment on Application of MS Office software (Word, PowerPoint, Excel...
Farhan Shehab
?
6 Steps To Set Up HR Management System In Excel.docx
6 Steps To Set Up HR Management System In Excel.docx
Saira Khalid
?
HOW IT IS BENEFICIAL IN HUMAN RESOURCES MANAGEMANT
HOW IT IS BENEFICIAL IN HUMAN RESOURCES MANAGEMANT
Nitesh Chaturvedi
?
Asmi Budget Monitoring Presentation 2010
Asmi Budget Monitoring Presentation 2010
aharker
?
Using open source BI. Practical experience 2012 - En
Using open source BI. Practical experience 2012 - En
Serge Ivanko
?
Resume_Cheryl Hunnicutt 2015 no address
Resume_Cheryl Hunnicutt 2015 no address
Cheryl Hunnicutt
?
hargrove_resume (July 2015)
hargrove_resume (July 2015)
Matt Hargrove
?
3 11 Ri Event @ New Horizons Pvd
3 11 Ri Event @ New Horizons Pvd
Mike Gilronan
?
Solution de gestion de paie : PAYOHR
Solution de gestion de paie : PAYOHR
senejug
?
Shelly_Weber_resume (3)
Shelly_Weber_resume (3)
Shelly Weber
?
5.11 lowry
5.11 lowry
muhamad nawawi
?
Malini Ray resume
Malini Ray resume
Malini Ray
?
How To Automate Part 1
How To Automate Part 1
Sean Durocher
?
Session 1 businessdashboardpresentation-christensen
Session 1 businessdashboardpresentation-christensen
IMA Columbia Chapter
?
Subhojit_Chaudhuri
Subhojit_Chaudhuri
Subhojit Chaudhuri
?
PremKumarTR_Programmer
PremKumarTR_Programmer
premrmdv
?
MZazzera.DChurch.SAP_HR_Hyperion_Planning.presentationvFINAL
MZazzera.DChurch.SAP_HR_Hyperion_Planning.presentationvFINAL
Michael Zazzera
?
Our Compliance Plan Templates and Tracking Worksheets
Our Compliance Plan Templates and Tracking Worksheets
John E Griggs, Ph.D.
?
Are you up to date with OASE?
Are you up to date with OASE?
Xylos
?
Fractal Enterpise Model (FEM) - a tutorial
Fractal Enterpise Model (FEM) - a tutorial
Ilia Bider
?
HRIS assignment on Application of MS Office software (Word, PowerPoint, Excel...
HRIS assignment on Application of MS Office software (Word, PowerPoint, Excel...
Farhan Shehab
?
6 Steps To Set Up HR Management System In Excel.docx
6 Steps To Set Up HR Management System In Excel.docx
Saira Khalid
?
HOW IT IS BENEFICIAL IN HUMAN RESOURCES MANAGEMANT
HOW IT IS BENEFICIAL IN HUMAN RESOURCES MANAGEMANT
Nitesh Chaturvedi
?
Asmi Budget Monitoring Presentation 2010
Asmi Budget Monitoring Presentation 2010
aharker
?
Using open source BI. Practical experience 2012 - En
Using open source BI. Practical experience 2012 - En
Serge Ivanko
?
Resume_Cheryl Hunnicutt 2015 no address
Resume_Cheryl Hunnicutt 2015 no address
Cheryl Hunnicutt
?
hargrove_resume (July 2015)
hargrove_resume (July 2015)
Matt Hargrove
?
3 11 Ri Event @ New Horizons Pvd
3 11 Ri Event @ New Horizons Pvd
Mike Gilronan
?
Solution de gestion de paie : PAYOHR
Solution de gestion de paie : PAYOHR
senejug
?
Shelly_Weber_resume (3)
Shelly_Weber_resume (3)
Shelly Weber
?
Malini Ray resume
Malini Ray resume
Malini Ray
?
Session 1 businessdashboardpresentation-christensen
Session 1 businessdashboardpresentation-christensen
IMA Columbia Chapter
?
PremKumarTR_Programmer
PremKumarTR_Programmer
premrmdv
?
MZazzera.DChurch.SAP_HR_Hyperion_Planning.presentationvFINAL
MZazzera.DChurch.SAP_HR_Hyperion_Planning.presentationvFINAL
Michael Zazzera
?
Our Compliance Plan Templates and Tracking Worksheets
Our Compliance Plan Templates and Tracking Worksheets
John E Griggs, Ph.D.
?
Are you up to date with OASE?
Are you up to date with OASE?
Xylos
?
Fractal Enterpise Model (FEM) - a tutorial
Fractal Enterpise Model (FEM) - a tutorial
Ilia Bider
?

More from Walid Al Wakeel (17)

Strategic hr using balance score cards
Strategic hr using balance score cards
Walid Al Wakeel
?
Advanced hr diploma
Advanced hr diploma
Walid Al Wakeel
?
????? ?????????? ????? ?????? ??????? 2017
????? ?????????? ????? ?????? ??????? 2017
Walid Al Wakeel
?
Hospital marketing course
Hospital marketing course
Walid Al Wakeel
?
Hr diploma
Hr diploma
Walid Al Wakeel
?
HR KPIs
HR KPIs
Walid Al Wakeel
?
H?R KPIs
H?R KPIs
Walid Al Wakeel
?
???? ??? 126 ???? 2014 ?????? ???? ?????? ????? ??????? ???????? ????? 15 ...
???? ??? 126 ???? 2014 ?????? ???? ?????? ????? ??????? ???????? ????? 15 ...
Walid Al Wakeel
?
Man power review and HR budget
Man power review and HR budget
Walid Al Wakeel
?
??????? ?????? ?? ??????? ???????
??????? ?????? ?? ??????? ???????
Walid Al Wakeel
?
??????? ?????? ?? ??????? ???????
??????? ?????? ?? ??????? ???????
Walid Al Wakeel
?
Labor law, insurance and tax Workshop
Labor law, insurance and tax Workshop
Walid Al Wakeel
?
Manpower review and hr budget
Manpower review and hr budget
Walid Al Wakeel
?
??? ???? ???? ??????? ??? ?????? 2009 ????? ???????? ?? ??? ????? ???????????? ?
??? ???? ???? ??????? ??? ?????? 2009 ????? ???????? ?? ??? ????? ???????????? ?
Walid Al Wakeel
?
?????? ????? ???????
?????? ????? ???????
Walid Al Wakeel
?
Strategic hr using balance score cards
Strategic hr using balance score cards
Walid Al Wakeel
?
????? ?????????? ????? ?????? ??????? 2017
????? ?????????? ????? ?????? ??????? 2017
Walid Al Wakeel
?
???? ??? 126 ???? 2014 ?????? ???? ?????? ????? ??????? ???????? ????? 15 ...
???? ??? 126 ???? 2014 ?????? ???? ?????? ????? ??????? ???????? ????? 15 ...
Walid Al Wakeel
?
Man power review and HR budget
Man power review and HR budget
Walid Al Wakeel
?
??????? ?????? ?? ??????? ???????
??????? ?????? ?? ??????? ???????
Walid Al Wakeel
?
??????? ?????? ?? ??????? ???????
??????? ?????? ?? ??????? ???????
Walid Al Wakeel
?
Labor law, insurance and tax Workshop
Labor law, insurance and tax Workshop
Walid Al Wakeel
?
Manpower review and hr budget
Manpower review and hr budget
Walid Al Wakeel
?
??? ???? ???? ??????? ??? ?????? 2009 ????? ???????? ?? ??? ????? ???????????? ?
??? ???? ???? ??????? ??? ?????? 2009 ????? ???????? ?? ??? ????? ???????????? ?
Walid Al Wakeel
?
Ad

Recently uploaded (20)

VCE Literature Section A Exam Response Guide
VCE Literature Section A Exam Response Guide
jpinnuck
?
2025 June Year 9 Presentation: Subject selection.pptx
2025 June Year 9 Presentation: Subject selection.pptx
mansk2
?
This is why students from these 44 institutions have not received National Se...
This is why students from these 44 institutions have not received National Se...
Kweku Zurek
?
YSPH VMOC Special Report - Measles Outbreak Southwest US 6-14-2025.pptx
YSPH VMOC Special Report - Measles Outbreak Southwest US 6-14-2025.pptx
Yale School of Public Health - The Virtual Medical Operations Center (VMOC)
?
Values Education 10 Quarter 1 Module .pptx
Values Education 10 Quarter 1 Module .pptx
JBPafin
?
Paper 107 | From Watchdog to Lapdog: Ishiguro¡¯s Fiction and the Rise of ¡°Godi...
Paper 107 | From Watchdog to Lapdog: Ishiguro¡¯s Fiction and the Rise of ¡°Godi...
Rajdeep Bavaliya
?
Photo chemistry Power Point Presentation
Photo chemistry Power Point Presentation
mprpgcwa2024
?
LDMMIA Yoga S10 Free Workshop Grad Level
LDMMIA Yoga S10 Free Workshop Grad Level
LDM & Mia eStudios
?
M&A5 Q1 1 differentiate evolving early Philippine conventional and contempora...
M&A5 Q1 1 differentiate evolving early Philippine conventional and contempora...
ErlizaRosete
?
ENGLISH_Q1_W1 PowerPoint grade 3 quarter 1 week 1
ENGLISH_Q1_W1 PowerPoint grade 3 quarter 1 week 1
jutaydeonne
?
HistoPathology Ppt. Arshita Gupta for Diploma
HistoPathology Ppt. Arshita Gupta for Diploma
arshitagupta674
?
June 2025 Progress Update With Board Call_In process.pptx
June 2025 Progress Update With Board Call_In process.pptx
International Society of Service Innovation Professionals
?
NSUMD_M1 Library Orientation_June 11, 2025.pptx
NSUMD_M1 Library Orientation_June 11, 2025.pptx
Julie Sarpy
?
Peer Teaching Observations During School Internship
Peer Teaching Observations During School Internship
AjayaMohanty7
?
Code Profiling in Odoo 18 - Odoo 18 ºÝºÝߣs
Code Profiling in Odoo 18 - Odoo 18 ºÝºÝߣs
Celine George
?
List View Components in Odoo 18 - Odoo ºÝºÝߣs
List View Components in Odoo 18 - Odoo ºÝºÝߣs
Celine George
?
How to Manage Different Customer Addresses in Odoo 18 Accounting
How to Manage Different Customer Addresses in Odoo 18 Accounting
Celine George
?
GREAT QUIZ EXCHANGE 2025 - GENERAL QUIZ.pptx
GREAT QUIZ EXCHANGE 2025 - GENERAL QUIZ.pptx
Ronisha Das
?
LDMMIA Shop & Student News Summer Solstice 25
LDMMIA Shop & Student News Summer Solstice 25
LDM & Mia eStudios
?
Aprendendo Arquitetura Framework Salesforce - Dia 02
Aprendendo Arquitetura Framework Salesforce - Dia 02
Mauricio Alexandre Silva
?
VCE Literature Section A Exam Response Guide
VCE Literature Section A Exam Response Guide
jpinnuck
?
2025 June Year 9 Presentation: Subject selection.pptx
2025 June Year 9 Presentation: Subject selection.pptx
mansk2
?
This is why students from these 44 institutions have not received National Se...
This is why students from these 44 institutions have not received National Se...
Kweku Zurek
?
Values Education 10 Quarter 1 Module .pptx
Values Education 10 Quarter 1 Module .pptx
JBPafin
?
Paper 107 | From Watchdog to Lapdog: Ishiguro¡¯s Fiction and the Rise of ¡°Godi...
Paper 107 | From Watchdog to Lapdog: Ishiguro¡¯s Fiction and the Rise of ¡°Godi...
Rajdeep Bavaliya
?
Photo chemistry Power Point Presentation
Photo chemistry Power Point Presentation
mprpgcwa2024
?
LDMMIA Yoga S10 Free Workshop Grad Level
LDMMIA Yoga S10 Free Workshop Grad Level
LDM & Mia eStudios
?
M&A5 Q1 1 differentiate evolving early Philippine conventional and contempora...
M&A5 Q1 1 differentiate evolving early Philippine conventional and contempora...
ErlizaRosete
?
ENGLISH_Q1_W1 PowerPoint grade 3 quarter 1 week 1
ENGLISH_Q1_W1 PowerPoint grade 3 quarter 1 week 1
jutaydeonne
?
HistoPathology Ppt. Arshita Gupta for Diploma
HistoPathology Ppt. Arshita Gupta for Diploma
arshitagupta674
?
NSUMD_M1 Library Orientation_June 11, 2025.pptx
NSUMD_M1 Library Orientation_June 11, 2025.pptx
Julie Sarpy
?
Peer Teaching Observations During School Internship
Peer Teaching Observations During School Internship
AjayaMohanty7
?
Code Profiling in Odoo 18 - Odoo 18 ºÝºÝߣs
Code Profiling in Odoo 18 - Odoo 18 ºÝºÝߣs
Celine George
?
List View Components in Odoo 18 - Odoo ºÝºÝߣs
List View Components in Odoo 18 - Odoo ºÝºÝߣs
Celine George
?
How to Manage Different Customer Addresses in Odoo 18 Accounting
How to Manage Different Customer Addresses in Odoo 18 Accounting
Celine George
?
GREAT QUIZ EXCHANGE 2025 - GENERAL QUIZ.pptx
GREAT QUIZ EXCHANGE 2025 - GENERAL QUIZ.pptx
Ronisha Das
?
LDMMIA Shop & Student News Summer Solstice 25
LDMMIA Shop & Student News Summer Solstice 25
LDM & Mia eStudios
?
Aprendendo Arquitetura Framework Salesforce - Dia 02
Aprendendo Arquitetura Framework Salesforce - Dia 02
Mauricio Alexandre Silva
?
Ad

Excel for hr cairo

  • 1. www.excel-for-hr.com 1 Excel For HR Course content HR Database ? Database basics ? How to Create an HR Database Using Microsoft Access ? Case study (Rec database ) Dealing with Data ? Importing & Exporting data ? How to create live reports ? How to create HR reports using pivot table ? Case study ( HIRS + reports ) Com & Ben Using Microsoft Excel ? Building live payroll sheet ? HR formulas ( insurance , tax, penalties) ? New way for calculation ? Case study (payroll formulas) ? Monthly variables ? Case study ( Employees loans ) Attendance ? Time formulas ? Case study (Man Power Plan) ? Case study (Man Power Plan new way ) ? Advanced HR formulas ? Case study (HR variable ) ? Case study (create Leave sheet ) Another useful Excel for HR Applications ? Mail merge ? Case study( Payroll slip , sending other mails ) ? Using Microsoft excel in job posting (new way ) ? Linking Excel with Visio ? Case study (org chart ) ? Case study (org chart , more accurate way) ? Org chat reports
  • 2. www.excel-for-hr.com 2 ? Some advanced tools ? Case study (payroll revision ) ? Some Excel for HR templates Instructor Mr. Walid Al Wakeel ? More than 16 years' experience in HR filed including 8 years in managerial position. ? HR consultant in Egypt, UAE and Libya ? Founder of Excel for HR course in Egypt Duration ? 24 Hours Price ? 550