1 / 7

MT-113 COMPUTER APPLICATIONS

Learn how to effectively sort, filter, and print Excel spreadsheets to organize and present data efficiently. Understand sorting criteria and filtering methods, making data management easier. Learn printing options for clear and professional presentation. Get ready to enhance your Excel skills!

jeanfreeman
Download Presentation

MT-113 COMPUTER APPLICATIONS

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. MT-113 COMPUTER APPLICATIONS Lecture # 09 By Syed Ehtisham Gillani

  2. Sorting and Filtering

  3. Sorting • Sorting allows you to organize data based on some criteria, usually alphabetically (A-Z or Z-A) or numerically (lowest to highest or highest to lowest).

  4. Filtering • Filtering data in a spreadsheet means to set conditions so that only certain data is displayed. It is done to make it easier to focus on specific information in a large database or table of data.

  5. Filtering • Filters works with records or rows of data in the database. • The conditions that are set are compared with one or more fields in the record. If the conditions are met, the record is displayed. • If the conditions are not met, the record is filtered out so that it isn't displayed with the rest of the data records. • Filtering does not permanently remove records, it just temporarily hides them from view.

  6. Printing Excel Spreadsheets • How to print excel spread sheets • How set print area • How to apply changes to page setup for properly printing excel spreadsheets

  7. Thank You! Get Ready for Lab Task!

More Related