You can always ask an expert in the Excel Tech Community or get support in the Answers community. If you have complicated or nested data, use Power Query to transform it (for example, to unpivot your data) so it is organized in columns with a single header row. Avoid double rows of headers or merged cells.įormat your data as an Excel table (select anywhere in your data and then select Insert > Table from the ribbon). Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Use clean, tabular data for best results. If your PivotTable is on a separate sheet that has no other data you want to keep, deleting that sheet is a fast way to remove the PivotTable. It won't have any affect on other data or PivotTables or charts around it. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents.If you created a PivotTable and decide you no longer want it, you can simply select the entire PivotTable range, then press Delete. Note: This course was recorded in Microsoft 365. Plus, he goes over how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables. Curt steps you through how to sort and filter PivotTable data, format your PivotTable and, and apply conditional formats. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable.

Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Jump in wherever you need answersbrisk lessons and detailed screenshots show you.

Many Excel users aren’t sure how to use PivotTables. Get more done quickly with Microsoft Excel 2019.

Excel pivot table training pdf