Spreadsheets PowerPoint

1. Spreadsheets PowerPoint By Adam, Ria, Seb & Cherie

2. What Can Spreadsheets Do ? • Spreadsheets allow you to compare one set of information with another, and display results using charts and graphs. • Spreadsheets are big tables, which are made up of rows, columns and cells. In each cell, data can be inserted and stored, and are capable of performing calculations using formulas.

3. Main Users of Spreadsheets Spreadsheets are similar to Databases, which is why they are used in the business world by small companies and specific people. • Accountants – Use spreadsheets to store customer information on income and expenditures. • Teachers – Use spreadsheets to store information such as pupil grades • Engineers – Use spreadsheets for calculations when designing and developing structures for projects. • Sales People – they use spreadsheets to keep track of sales that there company might have. • Scientists – they need to keep track of there results from there experiments that they have done. • Supermarkets Head Offices – supermarkets have to have spreadsheets to record how there company is doing, ie income and outcome, busiest time of day/month/year so the company know how many staff they will need that day/month/year.

4. Spreadsheet Manipulation Spreadsheets can be manipulated in order to produce a specific outcome. This can be anything from using formulas in cells to setting a spreadsheet out in a certain way. For example a teacher who uses a spreadsheet to store test results can manipulate the data to produce a graph.

5. Data Mining/Predictive Modelling Data Mining is the process of analyzing large amounts of data in order to find patterns and trends. When found, these patterns and trends can be used to cut expenses and increase revenue. Predictive modelling is similar to data mining, as it analyzes large amounts of data but uses the results to predict future income and outcome.

6. Complex Problems A complex problem that can be solved using a spreadsheet is totalling profit and loss for a company. A spreadsheet can total together expenditures of a month using formulas, and then use those totals to total expenditures of numerous months using macros (Linking Spreadsheets together).