Microsoft Excel 2021365 - Beginner to Advanced - Exercise 07 - format data as a tabl

The video tutorial covers formatting data as a table, sorting and filtering data, and applying subtotals. It begins with formatting data on the Customer Invoices worksheet into a table and naming it Invoices_2020. The tutorial then demonstrates sorting the data by month, invoice total, and status using a custom list. Next, it shows how to filter invoices over $3000 with a past due status. Finally, it explains how to apply subtotals to the data on the Customer Invoices Subtotal worksheet and collapse them to show only monthly totals.

What new insight or understanding did you gain from this video?