Chapter 32
Sorting in Excel
Questions answered in this chapter:
How can I sort sales-transaction data so that transactions are sorted first by salesperson, then by product, then by units sold, and finally in chronological order from oldest to most recent?
I want to sort my data based on cell color or font color. Is this possible in Office 365?
I love the icon sets described in Chapter 24, “Conditional formatting.” Can I sort my data based on the icon in the cell?
My worksheet includes a column containing the month in which each sale occurred. When I sort by this column, I get either April (first month alphabetically) or October (last month alphabetically) on top. How can I sort by this column so that January transactions are on top, followed ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
