1 / 23

Manipulating Data With Excel

Manipulating Data With Excel. Sorting and Filtering. SORTING DATA. To sort the RIT Perfomance alpabetically, click on Data - Sort. Sort by click on RIT Perf. Then click on Studentlastname. Click OK. Your data is sorted by RIT Performance and Last Name. FILTERING.

nadine
Download Presentation

Manipulating Data With 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. 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. Manipulating Data With Excel Sorting and Filtering MCSC Technology Training, October 2002

  2. SORTING DATA To sort the RIT Perfomance alpabetically, click on Data - Sort MCSC Technology Training, October 2002

  3. MCSC Technology Training, October 2002

  4. Sort by click on RIT Perf MCSC Technology Training, October 2002

  5. Then click on Studentlastname MCSC Technology Training, October 2002

  6. Click OK MCSC Technology Training, October 2002

  7. Your data is sorted by RIT Performance and Last Name MCSC Technology Training, October 2002

  8. FILTERING MCSC Technology Training, October 2002

  9. CLICK ON ANY CELL IN ROW ONE (YOUR FIELD NAME ROW) MCSC Technology Training, October 2002

  10. CLICK DATA – FILTER - AUTOFILTER MCSC Technology Training, October 2002

  11. DOWN ARROWS APPEAR IN EACH CELL IN ROW ONE MCSC Technology Training, October 2002

  12. LET’S SAY YOU WANT TO SEE JUST THE LOW SCORES UNDER RIT PERFORMANCE. CLICK THE DOWN ARROW IN THE RIT PERF. FIELD. SELECT LO MCSC Technology Training, October 2002

  13. ONLY THE LOW SCORES ARE SHOWN. MCSC Technology Training, October 2002

  14. TO SEE ALL YOUR DATA, CLICK ON DATA – FILTER – SHOW ALL. MCSC Technology Training, October 2002

  15. CREATING PIVOT TABLES MCSC Technology Training, October 2002

  16. CLICK ON DATA – PIVOT TABLE AND PIVOT CHART REPORT MCSC Technology Training, October 2002

  17. CLICK NEXT MCSC Technology Training, October 2002

  18. BY DEFAULT THE PROGRAM WILL SELECT ALL YOUR DATA. CLICK NEXT MCSC Technology Training, October 2002

  19. CLICK LAYOUT MCSC Technology Training, October 2002

  20. DRAG GRADENAME TO ROW DRAG RIT PERF TO BOTH COLUMNand DATA CLICK OK MCSC Technology Training, October 2002

  21. PLACE THE TABLE IN A NEW WORKSHEET (BY DEFAULT). CLICK FINISH MCSC Technology Training, October 2002

  22. YOUR PIVOT TABLE HAS CONVERTED THE TEXT DATA (RIT PERF) TO NUMERICAL DATA. CLICK ON ANY OF THE NUMBERS TO SEE THE SPECIFIC DATA. Make changes to your pivot table by clicking on the Pivot Table Wizard icon MCSC Technology Training, October 2002

  23. QUESTIONS? Call Ray at 5385 or E-mail me at rdhamilt@mvsc.k12.in.us MCSC Technology Training, October 2002

More Related