Uploaded August 2023 | Updated November 2026, 2 hours ago
Need to create a payroll calculator & payslip generator with Excel? Watch this video.
β± Video topics:
0:00 - Demo of the payroll workbook
0:30 - Payroll Data (timesheet data)
0:48 - Setting up "name selection" mechanism
1:28 - Rates for various types of hours
2:00 - Setting up the Payroll worksheet
2:38 - Fixing the problem with data validation lists
4:09 - Formulas for calculating the pay
π Download the sample data here - chandoo.org/wp/wp-content/uploads/2023/08/payroll-data-1.xlsx
π§° More templates and tools with Excel -
Watch the Excel Templates & Tools playlist on my channel for more - youtube.com/playlist?list=PLmejDGrsgFyCzno10GisavsO0iD9ZPNBf
~
#payroll #excel
~
I have a funny joke about payroll
It's coming out next Wednesday π
Need to create a payroll calculator & payslip generator with Excel? Watch this video.
β± Video topics:
0:00 - Demo of the payroll workbook
0:30 - Payroll Data (timesheet data)
0:48 - Setting up "name selection" mechanism
1:28 - Rates for various types of hours
2:00 - Setting up the Payroll worksheet
2:38 - Fixing the problem with data validation lists
4:09 - Formulas for calculating the pay
π Download the sample data here - chandoo.org/wp/wp-content/uploads/2023/08/payroll-data-1.xlsx
π§° More templates and tools with Excel -
Watch the Excel Templates & Tools playlist on my channel for more - youtube.com/playlist?list=PLmejDGrsgFyCzno10GisavsO0iD9ZPNBf
~
#payroll #excel
~
I have a funny joke about payroll
It's coming out next Wednesday π










