Different uses for spreadsheets

Spreadsheets Coursework

There are many different uses for spreadsheets; the main use for spreadsheets is using basic formulas to work through various sums. They are able to also used to stand for data graphically using graphs and charts. In this record I intend to explore the many uses for spreadsheets in different areas and give attention to one specific area and look at the uses for a spreadsheet in that area and also I am going to look at a few of the limits that using spreadsheets may bring.

One of the primary uses for spreadsheets is within finance, businesses may use a spreadsheet to forecast sales, and show graphically how sales will surge or drop based on past occurrences. Spreadsheets can even be used to work out rates of interest and monthly premiums based on variables such as time, i. e. 5 years, 10 years or amount borrowed and also both such as Ј100, 000 borrowed over 30 years.

Another use for spreadsheets is in education, spreadsheets can be used to store students personal data along with marks and ratings, this data can then be utilized to forecast a student's overall or average class, this may also be used to forecast how they'll do at higher levels. A spreadsheet can be used to assemble all pupils' ratings and represent the data in a graph displaying the move percentages for the school. A spreadsheet can even be used to track record pay documents for personnel of the school and when they get paid and how much they receives a commission.

Other uses for spreadsheets are in Health Care; health organisations such as the NHS can use spreadsheets to record patient's details for quick access by doctors and other personnel. They may also be used showing the date these were admitted and the date they were authorized out by a health care provider. And the doctor that is treating them. This can also be beneficial to see what dates are busiest and other styles. And plan accordingly for the future.

Spreadsheets can be utilized by shop keepers to keep comprehensive lists of these stock, how much that costs and the pub code variety of that, the shop keeper can also record sales of every item in his/her stock and then use graphs to see what items are available well, and also what items are not selling so that the shop keeper can then change stock consequently. As spreadsheet can be used for a shop owner to do their VAT and Tax returns by the end of each quarter of the entire year.

Spreadsheets can be used in sports to record the team information, and then work out goal per game percentages, and and yes it can be used to keep a casino game roster, games played and also draft graphs and graphs that show team performance, it can be used to get a players averages such as average goals per game, accidental injuries per season and other vital statistics. Also making them alot simpler to be read and interpreted by an individual.

The request area I have chosen to consider is Shop keeping

In shop keeping spreadsheet applications can be very useful in shop keeping as it could help a shop owner keep an in depth inventory of all the items in the shop keeping information such as supply and barcode quantity easily accessible.

Shop keepers can also use spreadsheets to track record sales of all of these stock. They are able to view what items are selling well, what are not selling in any way and what items can be purchased out. This data may be used to make graphs, charts and tables this is utilized by the shop keeper to decide what he must get more off, or what stock he must order less of, or stop ordering. This can be useful for the shopkeeper to make use of when deciding what offers to put on certain items.

Shop keepers can also use spreadsheets to compute their budget; they can estimate daily profit or loss and also anticipate using previous sales what should happen for another few weeks a few months or years. They can also determine their regular, quarterly or every year profits or loss plus they can do their VAT and Taxation statements for the financial years. Making it easier, quicker and more convenient with fewer blunders.

Another use for spreadsheets by shop keepers is keeping personnel details stored for fast and simple hours, this also is a great way for professionals or owners to see their wage expenses and also keep keep tabs on on who is working what hours and also staff holiday bookings, this makes it easier than by using a conventional reserve and allows comparison of data faster.

Spreadsheets can even be utilized by shop keepers by with them to work through break even things if the shop keeper wished to obtain loans from lenders or buyers for growth or other reasons.

One Spreadsheet use that would be helpful for shop keepers is the furniture, they can evidently block out their inventories and using the "Form" tool they can sort the data in any way they want, from A - Z to quantity values. They are able to also group data types collectively making it a definite more organised list than just typing it up in Microsoft phrase.

Another use for spreadsheets that might be useful in shop keeping is graphs and charts, graphs may be used to represent sales, income and loss and other numerical data in a single or more simple graphs that are easy to read. Charts can be better to show data such as hours available Vs time used. And stock sold Vs stock left or came back.

Spreadsheets may be useful by using formula to work through various amounts such as adding, multiplying, subtracting or dividing various skin cells together which could be great for shopkeepers to work through their loss or profit margins. They are able to also use other functions such as averages to save time by bypassing the necessity for a calculator.

One of the primary restrictions of spreadsheets is the fact some graphs and graphs can be unclear when there is too much fine detail or if 3D graphs are used as the info lines and plotting can be unclear along. The axis also needs to be clearly labelled to avoid dilemma.

Another downside to spreadsheets is it isn't ideal for word processing, any other thing more when compared to a few words and any more than that Microsoft word should be used or for small paragraphs responses attached to the cell.

Another issue with spreadsheets is the fact that beyond basic arithmetic the spreadsheet software gets more complex and could require more help from someone been trained in it. As some of the functions are not easily explainable this could devote some time.

Another disadvantage is the fact that creating dining tables and graphs can be complicated and getting these to look right can be frustrating.

In finish, spreadsheets can help change huge amounts of data into simple and easily interpreted. They may also be used to type and group large amounts of data in tables and make them better to read and discuss. They also allow people to work out the average of a set of data and ensemble predictions along with basic arithmetic. Nonetheless they can be complicated to use and sometimes very unclear.

Ошибка в функции вывода объектов.