Ravindra BagaleCourses & study guides

6. Tables, Sorting and Filtering

By Last updated:

Chala mitrano, aaj aapan data la "shistit" basavuya. Excel Table (Ctrl + T) he Excel madhla sagalyat underrated feature aahe – ekda vaparla ki tumhi range kadhich vaparnar nahi. Tyasobat multi-level sort, custom sort, filters, Advanced Filter, SUBTOTAL, AGGREGATE aani Group/Outline pan shikuya.

What you will learn in this module

  • Creating and naming Excel Tables, and why they beat plain ranges
  • Structured references and the Total Row
  • Multi-level sort and custom sort orders (city order, Mon–Sun, Low–High)
  • AutoFilter, and Advanced Filter with AND/OR criteria (निकष)
  • SUBTOTAL and AGGREGATE for visible-only and error-proof totals
  • The Subtotal command and Group/Outline

Concepts in this chapter

  1. 6.1Excel Tables (Ctrl + T)
  2. 6.2Structured References
  3. 6.3The Total Row
  4. 6.4Sorting: Multi-level and Custom Sort
  5. 6.5AutoFilter
  6. 6.6Advanced Filter
  7. 6.7SUBTOTAL and AGGREGATE
  8. 6.8The Subtotal Feature
  9. 6.9Group and Outline

The chapter recap is at the end of the last concept page.