Excel tutorials

In Excel a common task is to check progress for ordered and delivered items.

Below we have number of ordered and delivered fruits, our goal is to calculate how big percentage is delivered.

Follow the below steps:

• Create a column with products/items.
• Create one column with ordered items
• Create one column with delivered items
• Create a column labelled % Delivered
• Use the formula D7/C7
• To make it appear as % format the cells as percent