Different uses for spreadsheets

Different development ups for spreadsheetsSpreadsheets Course hunt on that point are many different determinations for spreadsheets the main use for spreadsheets is utilise elementary formulas to work by various sums. They good deal in like manner utilize to be information graphically development graphs and maps. In this document I formulate to explore the various uses for spreadsheets in different champaigns and focus on unity specific area and look at the uses for a spreadsheet in that area and in like manner I will look at whatever of the limitations that using spreadsheets sewer bring.One of the main uses for spreadsheets is in finance, businesses hobo use a spreadsheet to forecast sales, and cross-file graphically how sales will rise or drop establish on past events. Spreadsheets wad also be apply to work out interest rates and monthly payments based on variables such(prenominal) as while, i.e. 5 years, 10 years or amount borrowed and also both such as 100,000 borrowed over 30 years.An opposite use for spreadsheets is in education, spreadsheets stooge be used to reposition students personal data along with grades and scores, this data can so be used to predict a students overall or average grade, this can also be used to forecast how they will do at higher levels. A spreadsheet can also be used to cope with all pupils scores and represent the data in a chart displaying the pass percentages for the school. A spreadsheet can also be used to reputation pay records for staff of the school and when they pay off paid and how much they get paid.Other uses for spreadsheets are in Health Care health organisations such as the NHS can use spreadsheets to record patients spots for easy entryway by twists and separate staff. They can also be used to show the date they were admitted and the date they were signed out by a doctor. And the doctor that is treating them. This can also be utile to chew the fat what dates are busiest and other trends. And plan accordingly for the future.Spreadsheets can be used by patronage keepers to keep detailed lists of their stock, how much the item costs and the bar rule number of the item, the shop keeper can also record sales of each item in his/her stock and then use graphs to see what items are exchange well, and also what items are non selling so that the shop keeper can then change stock accordingly. As spreadsheet can also be used for a shop owner to do their VAT and Tax returns at the end of each drag of the year.Spreadsheets can be used in sports to record the team statistics, and then work out goal per game percentages, and also it can be used to keep a game roster, games played and also mess up graphs and charts that show team performance, it can also be used to get a players averages such as average goals per game, injuries per season and other vital statistics. Also making them alot easier to be read and interpreted by the user.The application area I have c hosen to look into is haunt keepingIn shop keeping spreadsheet applications can be genuinely useful in shop keeping as it can assist a shop owner keep a detailed record of all the items in the shop keeping information such as availability and barcode number easily accessible. sell keepers can also use spreadsheets to record sales of all of their stock. They can view what items are selling well, what are not selling at all and what items are interchange out. This data can be used to make graphs, charts and tables this can be used by the shop keeper to decide what he unavoidably to get much off, or what stock he needs to assemble less of, or stop ordering. This can also be useful for the shopkeeper to use when deciding what offers to put on certain items.Shop keepers can also use spreadsheets to point their finances they can calculate daily profit or dismission and also predict using past sales what should happen for the next few weeks months or years. They can also calculat e their monthly, quarterly or yearly profits or losses and they can do their VAT and Tax returns for the financial years. making it easier, quicker and more convenient with fewer mistakes. some other use for spreadsheets by shop keepers is keeping staff details stored for quick and easy hours, this also is a good way for managers or owners to see their wage expenses and also keep track on who is working what hours and also staff holiday bookings, this makes it easier than using a conventional book and plys comparison of data faster.Spreadsheets can also be used by shop keepers by using them to work out break even points if the shop keeper cherished to obtain loans from banks or investors for expansion or other reasons.One Spreadsheet use that would be useful for shop keepers is the tables, they can clearly block out their inventories and using the SORT tool they can sort the data in any way they want, from A Z to number values. They can also pigeonholing data types together m aking it a clear more organised list than just typing it up in Microsoft word.Another use for spreadsheets that would be useful in shop keeping is graphs and charts, graphs can be used to represent sales, profit and loss and other numeric data in one or more simple(a) graphs that are easy to read. Charts can be easier to show data such as hours available Vs hours used. And stock sold Vs stock left over or returned.Spreadsheets could also be useful by using formula to work out various sums such as adding, multiplying, subtracting or dividing various cells together which could be useful for shopkeepers to work out their profit or loss margins. They can also use other functions such as averages to further time by bypassing the need for a calculator.One of the main limitations of spreadsheets is that some charts and graphs can be unclear if there is too much detail or if 3D graphs are used as the data lines and plotting can be unclear along. The axis also needs to be clearly labelled to avoid confusion.Another downside to spreadsheets is it isnt great for word processing, anything more than a few words and any more than that Microsoft word should be used or for small paragraphs comments attached to the cell.Another downside to spreadsheets is that beyond basic arithmetical the spreadsheet software gets more complex and may require more friend from someone trained in it. As some of the functions are not easily explainable this could take time.Another disadvantage is that creating tables and graphs can be composite and getting them to look right can be time consuming.In conclusion, spreadsheets can help turn huge amounts of data into simple and easily interpreted. They can also be used to sort and group large amounts of data in tables and make them easier to read and explain. They also allow people to work out the average of a set of data and cast predictions along with basic arithmetic. However they can be complicated to use and sometimes very unclear.