How to Calculate Percentage Change. Calculating percentage change is one of the most frequently used tasks in Excel. The basic formula is: (New Value / Old Value) – 1.

Smartsheet's Gantt chart template lets you input the dates for each assignment and choose their completion percentage. When you increase the percent completed, the shade of green turns darker. As a ...