Using formulas in Microsoft Excel is a reliable method to calculate payroll for your business. Microsoft Excel contains over 300 built-in formulas to aid in the production of a functional worksheet.