Retaining a link to the original data:
This method allows the pasted cell to be connected to the original spreadsheet while being on a different document e.g. word. Thus, allowing the changes in a spreadsheet to also change automatically in the word document.
Method:
Step 1: Copy cells required from spreadsheet
Step 2: Switch to word document and then click edit
Step 3: Choose paste special
Step 4: A “paste special dialog box” appears, then choose paste link
Step 5: Then choose the document type e.g. Microsoft office, then click OK
Result: The required cell will be on Microsoft office and will behave like a graphical image, unlike a word table. To edit them, you can double click on them, spreadsheet will open and you can make your changes there.
Advantages of using spreadsheet to JEM bookshop
- Spreadsheet is very flexible
If JEM Bookshop uses spreadsheet, it would be very flexible, as you are able to open there data anywhere-as long as they computer has spreadsheet, which most computers do- or save it on the USB, and bring it to meetings outside their firm. This shows that spreadsheet it used by many people and can be used by many software’s or technologies.
- It can be used for all types of applications
As I said previously, JEM Bookshop can Use their Spreadsheet on many applications, such as: Microsoft office for mail merge. The applications that spreadsheet can used for, are widely know, and used around the world.
- The structure of table allows it to store values that represent sales figures, profit, number etc. This would help JEM Bookshop with their finance, as they could create their Break even chart; Profit and Loss account; Balance sheet; Gross Profit Margin etc.
- Spreadsheet has tools such as charts and graphs, which allow large quantities of data to be showed clearer. This would help JEM Bookshop, for example if you have a meeting, it would be easier for the audience to look at a chart or a graph with large data than a table, which would be harder to read and understand.
- They can calculate sum easily and correctly (as long as there aren’t any human errors made). This makes it more reliable and accurate. Especially if it is a business, Because JEM Bookshop could make a great loss if it was done manually which would be less reliable, whereas using spreadsheet it is more accurate; as long as you write the figures correctly.
- Lastly, it can manipulate large list of a data’s. Tools such as filtering and sorting allow the user to find a certain list of criteria, easily. JEM Bookshop could use these methods to be more organized and sort by Alphabet; Price; Name or Surname, to find something with a certain criteria.
Disadvantage of using spreadsheet to JEM bookshop:
- If you insert the wrong data or figures in the cell, all the calculations or other things, will lead to a wrong result. This error would also be hard to identify. If JEM Bookshop made an error like this, it would cause a lot of trouble; Profit could Decrease, Reputation would bad, losing customers etc. furthermore, to avoid this you need training or employing new staff, which could increase the expenses.
Overall, If JEM bookshop, used spreadsheets, it would help them to calculate their profit and loss account, budget, gross profit margin, net profit margin etc. it would be more efficient easily to use, it saves time for the business thus, allowing JEM Bookshop to spend more time on their business.
In reality JEM bookshop could use spreadsheet for a lot of things, rather than by doing it paper based. It provides better security, accuracy and reliability. A lot of successful business use spreadsheet in order to produce chart or graphs for a presentation or just using it to solve financial matters. Not only is it easier, but it provides many tools such us, filtering, sorting, calculating etc.
Refining your solution to make it easier for users to use:
Step 1: lock cells
Step 2: Highlight required cells that needs to be locked
Step 3: Select format and the cell selection
Step 4: Drop down list appears
Step 5: click lock cell.
You could use this method to lock important cells, like the cells in the diagram below which, you don’t want other staff or public to touch or change.