he office where you work would like to track the cost of office supplies used for a two month period. As office manager you're asked to compare two months worth of inventory and prepare a graphical representation of the comaprison to show th increase or decrease in supply use. You must prepare an Excel spreadsheet to be sent to the Chief Financial Officer of your company
I tried that but I just couldn't do it can you offer sime extra help??
Start with preparing some data (if not given by your teacher) for the inventory comparison.
Enter them into a spreadsheet and try to create graphics.
Here are some help on graphics if you need them:
http://www.ehow.com/how_4474239_make-graph-using-excel.html
http://spreadsheets.about.com/od/excelcharts/ss/line_graph.htm
ok, I made the chart, but how to I create the graph to show the information.
Decide on the type of graph you need, pie-charts, line graphs, or others.
Follow the first link on "how 4474239_make-graph-using-exceo.html..."
The directions are there.
To track the cost of office supplies used for a two-month period and prepare a graphical representation of the comparison in Excel, follow these steps:
1. Open Microsoft Excel on your computer.
2. Create a new spreadsheet by clicking on "Blank Workbook" or using the shortcut Ctrl + N.
3. In the first column (Column A), enter the category names or item names of the office supplies you want to track. For example, pens, paper, printer cartridges, etc.
4. In the second column (Column B), enter the corresponding cost of each item for the first month.
5. In the third column (Column C), enter the corresponding cost of each item for the second month.
6. In the fourth column (Column D), calculate the difference in supply use between the two months. Use the formula "=C2-B2" in cell D2, and then drag the formula down to calculate the differences for all items.
7. Insert a bar graph to represent the increase or decrease in supply use:
- Select the data range from column A to D.
- Click on the "Insert" tab on the Excel ribbon.
- Choose the type of chart you want to create (e.g., Column Chart).
- Customize the chart as needed by adding axis labels, chart title, gridlines, etc.
8. After creating the graph, you can customize the appearance, colors, and styles by right-clicking on different chart elements (e.g., bars, axis, etc.) and selecting the desired formatting options.
9. Once you are satisfied with the spreadsheet and the graphical representation, save it by using the shortcut Ctrl + S or going to File > Save As. Choose a name for the file and select the location where you want to save it.
10. Finally, send the Excel spreadsheet to the Chief Financial Officer by attaching it in an email or sharing it through a file-sharing platform.
By following these steps, you will be able to track the cost of office supplies and provide a graphical representation of the comparison in Excel, ensuring the Chief Financial Officer can easily understand the increase or decrease in supply use over the two-month period.