logging in or signing up Stock Control in Excel iansillett Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 1360 Category: Education License: All Rights Reserved Like it (2) Dislike it (1) Added: April 24, 2008 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... By: khariharan88 (34 month(s) ago) i need d presentation which u have prepared fr stock market pls do me a favour...hariharan Saving..... Post Reply Close Saving..... Edit Comment Close Premium member Presentation Transcript Spreadsheet for Stock Control : Spreadsheet for Stock Control Slide 2: This part of the spreadsheet records what stock (things to sell) we had in January Slide 3: Each text label in column A helps us to understand the number next to it in column B Slide 4: We had no chocolate when we started the tuck shop in January. So we record that the 'opening balance' was 0. Slide 5: We bought one box of 48 bars of chocolate in January. We record it here in cell B5. Slide 6: Cell B6 shows how much stock (chocolate bars) we have now. We started with 0 and we bought 48. We enter a formula in cell B6 (1) to add the opening balance for January (in cell B4 - 2) and the bars we bought (in cell B5 - 3) together. The formula is =B4+B5 Slide 7: When we press the enter key, Excel shows the result of the formula. Adding the opening balance of 0 and the 48 bars we bought makes a total of 48. No surprise there! Slide 8: In January we sold 25 bars of chocolate in the tuck shop. Slide 9: We can make Excel work out how many bars we have left afterwards. It is the total number of bars we had in stock (48) minus the number we sold (25). We use a formula in cell B8 to do the sum for us. =B6-B7 Slide 10: And the answer is 23. Slide 11: Oops! While we were doing the spreadsheet we both had a chocolate bar! We paid for them, but we also have to make the number of bars sold two more - 27. Slide 12: When we've changed the number value in cell B7 to 27 and press the enter key, the formula in cell B8 automatically calculates the new value for how many chocolate bars we have left at the end of January - 21. Slide 13: In column C we will record our stock and sales for February. How many chocolate bars do we have at the beginning of February? Slide 14: Of course, it is the same number that we had at the end of January! At the end of January we had 21 bars, so we must start February with 21 bars. But here's a trick that will come in useful later. We enter a formula in cell C4 (1) that just copies the value in cell B8 (2). Slide 15: So Excel copies the number for us and there can be no mistakes. And if we find out later that we made a mistake in counting our stock in January, Excel will make sure that C4 always has the same value as B8.=B8 The End : The End Look through the presentation again, if you need to. When you are ready, go on to task 2 and take the test. You may need to close this window to return to the lesson guide. You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
Stock Control in Excel iansillett Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 1360 Category: Education License: All Rights Reserved Like it (2) Dislike it (1) Added: April 24, 2008 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... By: khariharan88 (34 month(s) ago) i need d presentation which u have prepared fr stock market pls do me a favour...hariharan Saving..... Post Reply Close Saving..... Edit Comment Close Premium member Presentation Transcript Spreadsheet for Stock Control : Spreadsheet for Stock Control Slide 2: This part of the spreadsheet records what stock (things to sell) we had in January Slide 3: Each text label in column A helps us to understand the number next to it in column B Slide 4: We had no chocolate when we started the tuck shop in January. So we record that the 'opening balance' was 0. Slide 5: We bought one box of 48 bars of chocolate in January. We record it here in cell B5. Slide 6: Cell B6 shows how much stock (chocolate bars) we have now. We started with 0 and we bought 48. We enter a formula in cell B6 (1) to add the opening balance for January (in cell B4 - 2) and the bars we bought (in cell B5 - 3) together. The formula is =B4+B5 Slide 7: When we press the enter key, Excel shows the result of the formula. Adding the opening balance of 0 and the 48 bars we bought makes a total of 48. No surprise there! Slide 8: In January we sold 25 bars of chocolate in the tuck shop. Slide 9: We can make Excel work out how many bars we have left afterwards. It is the total number of bars we had in stock (48) minus the number we sold (25). We use a formula in cell B8 to do the sum for us. =B6-B7 Slide 10: And the answer is 23. Slide 11: Oops! While we were doing the spreadsheet we both had a chocolate bar! We paid for them, but we also have to make the number of bars sold two more - 27. Slide 12: When we've changed the number value in cell B7 to 27 and press the enter key, the formula in cell B8 automatically calculates the new value for how many chocolate bars we have left at the end of January - 21. Slide 13: In column C we will record our stock and sales for February. How many chocolate bars do we have at the beginning of February? Slide 14: Of course, it is the same number that we had at the end of January! At the end of January we had 21 bars, so we must start February with 21 bars. But here's a trick that will come in useful later. We enter a formula in cell C4 (1) that just copies the value in cell B8 (2). Slide 15: So Excel copies the number for us and there can be no mistakes. And if we find out later that we made a mistake in counting our stock in January, Excel will make sure that C4 always has the same value as B8.=B8 The End : The End Look through the presentation again, if you need to. When you are ready, go on to task 2 and take the test. You may need to close this window to return to the lesson guide.