MONITOR THE DAILY PRODUCTION PLAN USING MICROSOFT EXCEL

A worksheet is used to monitor daily production. The target is defined as 1,500 pieces per day. To calculate the percentage produced of the daily goal, perform the following steps.

To monitor daily production:

1. Select cell B1 and enter the predefined target: 1500.
2. Select cells C4:C11 and type the following formula: =B4/$B$1.
3. Press <-Ctrl+Enter->.
4. From the Format menu, select Cells and the Number tab.
5. Choose Percentage from Category.
6. Set Decimal places to 2.

MONITOR THE DAILY PRODUCTION PLAN USING MICROSOFT EXCEL

Microsoft Excel Tutorials, Monitor the daily production plan using microsoft excel, Microsoft Excel Video Tutorials, Basic Tutorials of MS Excel, Formulas in Excel, Advanced Tutorials, Pivot Table