Are you working with large tables in Excel and preparing summary reports? If so, you need to use just some mouse clicks to make interactive summary of your records efficiently. This is it: Pivot Tables tool.
This is mainly for starters. Let's assume, you're creating a large table of data, several columns wide, thousands of rows. It's a good practice to organize the table in such a way that it
- has unique and relevant headers,
- doesn't contain any blank cells and subtotals, and
- is named (by typing the name in the Table Name box, located under the Table Design tab in the ribbon, at the upper left corner of your worksheet)
Now your table is ready for converting (if not converted yet) into the Excel Table. It might look like in this small sample: