1 / 23

Mastering Excel: Sorting, Filtering, and Creating Pivot Tables for Data Manipulation

Enhance your data management skills with this comprehensive training module on Excel. Learn how to sort your data alphabetically by RIT Performance and Last Name, and filter to view specific criteria like low scores effortlessly. This session also covers creating pivot tables to transform text data into a numerical format, streamlining your analysis. Ideal for educators and administrators looking to improve their data handling capabilities. Join us for hands-on experience and practical tips to maximize Excel's powerful features!

nadine
Télécharger la présentation

Mastering Excel: Sorting, Filtering, and Creating Pivot Tables for Data Manipulation

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