1 / 6

Spreadsheets PowerPoint

Spreadsheets PowerPoint. By Adam, Ria, Seb & Cherie. What Can Spreadsheets Do ? . Spreadsheets allow you to compare one set of information with another, and display results using charts and graphs.

odeda
Download Presentation

Spreadsheets PowerPoint

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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).

More Related