Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

H. ZhouMastering Excel Through Projectshttps://doi.org/10.1007/978-1-4842-7842-0_3

3. Payroll Calculation

Hong Zhou¹  

(1)

University of Saint Joseph, West Hartford, CT, USA

 

Please download the sample Excel files from https://github.com/hhohho/master-Excel-through-projects for this chapter’s exercises.

There are outstanding software systems and tools that can automate the payroll calculation process; Excel remains an essential tool for small business owners, however. Education-wise, Excel is not replaceable for accounting.

Payroll calculation is fairly complicated due to the fact that tax laws are evolving almost every year. Taking the United States as an example, ...