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 is the first step you need to take to format the data on the Customer Invoices worksheet?

How do you name the table after formatting it?

What criteria should you use to sort the invoices in the table?

What filter should you apply to show invoices over $3000?

What is the final step regarding subtotals that you need to perform?