Monday, December 2, 2019

Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve efficiency Essay Example

Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve efficiency Essay Excel offers many faciliets, one of them being shortcut keys. A shortcut key makes it easier for a user to move among large or multiple worksheets. 1: shortcut key 2: effect For moving around a worksheet: 1: Ctrl + End We will write a custom essay sample on Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve efficiency specifically for you for only $16.38 $13.9/page Order now We will write a custom essay sample on Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve efficiency specifically for you FOR ONLY $16.38 $13.9/page Hire Writer We will write a custom essay sample on Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve efficiency specifically for you FOR ONLY $16.38 $13.9/page Hire Writer 2: This moves the cell pointer back to the last cell used in the worksheet 1: Ctrl + Home 2: This moves the cell pointer Moves to cell A1 1: Home 2: This moves to the beginning of a current row e.g. column A1 1: Page Down 2: This moves the screen one down 1: Page up 2: This moves the screen one up Selecting Cells 1: Ctrl + A 2: This selects the current data region in the worksheet 1: Ctrl 2: This allows you to select regions that are not next or close to each other Moving between worksheets 1: Ctrl + Page Up 2: This moves to the next worksheet 1: Ctrl + Page Up 2: This moves to the previous worksheet Formatting 1: Ctrl + Shift + $ 2: This applies a currency format 1: Ctrl + Shift + % 2: This applies a percentage format Combining information Mail merge: You are able to copy data from excel and then insert the data into word document. This data then will turn into a word table and can be edited. When the data is in word document, it will no longer be connected with the original spreadsheet. This could be a great advantage for JEM Bookshop, because it would allow them to produce a report e.g. on their profit and loss account, on Microsoft office for their shareholders or staff. If data, table or graph is needed in the report, you can mail merge it into Microsoft office, making it easier to write the report or change anything in the table, chart or graph. 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 softwares 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 arent 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 datas. 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 dont want other staff or public to touch or change.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.