collating data in excel n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Collating Data in Excel PowerPoint Presentation
Download Presentation
Collating Data in Excel

Loading in 2 Seconds...

  share
play fullscreen
1 / 7
vivek

Collating Data in Excel - PowerPoint PPT Presentation

126 Views
Download Presentation
Collating Data in Excel
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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Collating Data in Excel

  2. Learning Objective • “Learn how to collate data using Microsoft Excel”. • Write this Learning Objective onto your Self Assessment Sheet. Thursday, 19 February 2009

  3. Results of a Survey • Your job will be to put the results of a survey into an Excel spreadsheet and create graphs from the data. Learn how to collate data using Microsoft Excel

  4. Laying out the Spreadsheet Summary of each question. Answers to go in columns under male and female headings. Learn how to collate data using Microsoft Excel

  5. Task • Create a spreadsheet laid out like the one below to record all of the results from the survey: Learn how to collate data using Microsoft Excel

  6. Extension Task • Customise your spreadsheet by adding borders and colours to make it look more appealing. Learn how to collate data using Microsoft Excel

  7. Learning Objective • “Learn how to collate data using Microsoft Excel”. • Put  or  onto your Self Assessment sheet to show whether or not you have achieved today’s learning objective. Thursday, 19 February 2009