How to Make Excel Calculate Faster. Whenever you change something on a Microsoft Excel 2010 spreadsheet, the program will recalculate some of the cells in the worksheet, even some of those that ...

If you have a lengthy column of numbers that you need to multiply by a percentage, Excel includes tools to instantly apply the product to the entire range of cells in the column.

To calculate in Excel how many hours someone has worked, you subtract the start time from the end time — the difference is the hours worked. But if the work shift spans midnight, simple ...