Spreadsheet

1. Spreadsheet Amadhila Dave Tencin

2. Spreadsheet? • The spreadsheet has a lot of interesting uses, we’ll discuss the following uses in more details

3. Interview Forms. • “This is an exercise to get students used to spreadsheets, but which also uses spreadsheet's unique "worksheet" capability to organise work better than a word processor can. This activity is recommend when students have to interview numerous people about numerous questions. Missing or incomplete ones are easily determined.”

4. calculations on data. • Spreadsheets are very useful when it comes to making calculations. Spreadsheets make it more easier to use calculations as they offer formulas that already in the software and are easy to use. • Spreadsheets are be useful at making calculations that too many or complex, as they make use of cells that are arranged in columns and rows, this gives the user a wider space to use and they also make use of worksheets.

5. visualize relationships with dynamic graphs. • Charts and graphs create better depictions of trends and percentages than raw numbers. As they say, "A picture's worth a thousand words." Spreadsheet programs can automatically convert your data into the visual depiction of your choice, whether it's a pie chart, bar chart or line graph.

6. Database use. • Although spreadsheets are not true relational databases, they can be designed to function as simplified ones. For example, if you need to track pricing of a particular product, enter its price only one time. For all subsequent references to that price, point to the original entry as opposed to re-entering the price. When you need to change the price, change it in its original cell and all corresponding references will update automatically.

7. How they’re used to solve complex problems.

8. cash flow forecasting. • Cash Flow forecasts help you to build a model of the way in which cash moves within a project or organization. They help you to predict whether the sales or income you forecast will cover the costs of operation. • By carrying out a Cash Flow forecast on a spreadsheet package you can investigate the impact of changing factors within the forecast. If you have structured the spreadsheet correctly then you will be able to see, more or less instantly, the effect that changes will have.

9. budget control. • One of the most powerful uses for any spreadsheet program is the creation of a budget for your family or business. Using a spreadsheet to create a realistic budget can make the job a lot easier, and there are a number of tools individuals and business owners can use to balance their own budgets using a popular spreadsheet program.

10. use interpretation methods.

11. trend analysis. • Traditional spreadsheet approaches, to view data trends users will need to specify certain columns and rows to construct a graphic view on the data of interest, e.g. bar or line graphs. This process will be repeated for viewing a diagram for each data area individually • Graphical techniques in spreadsheets offer organisations a more clear illustration of how the trend is going.

12. comparisons of totals. • By using a spreadsheet, an organisation is able to analyse its previous totals and compare them to either present totals or forecasted totals, this gives an organisation a clear view if they are making a profit or loss and by how much.