Microsoft Excel can replace mundane tasks with formulas and functions. One task that can streamline any manager or supervisor’s job is to create an Excel spreadsheet to figure out sick leave for employees and use formulas to replace the task of manually calculating totals. Enter the amount of sick leave the employee has earned and how much the employee has used, and the spreadsheet formulas will do the rest, adding up totals and carrying sick leave totals forward every month. =B7-C7. Copy the formula to cells D8 to D17 by dragging the fill handle (the little black square in the bottom right corner of the cell) to cell D17. Tips Writer Bio
