Contrasting sorting data within worksheets to the nuances of sorting data within pivot tables.Repositioning or removing subtotals within pivot tables.Creating a pivot table to transform lists of data into on-screen reports.Resetting all filters at once within a pivot table by way of the Clear Filters command.Exploring the nuances of formatting numbers within pivot tables.Filtering pivot tables to show fewer columns and/or rows of data.Determining which refresh commands will update a single pivot table versus all pivot tables in a workbook.Adding fields to a blank pivot table to create instant reports.David also provides an Excel workbook that includes most of the examples he uses during the webcast. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. In addition, he points out pivot table traps and shares tricks to help ensure your reports are accurate.ĭavid demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Microsoft 365 version of Excel. David shows you how to initiate a pivot table from a list of data, add fields, dig deeper into the numbers, and much more. Pivot tables enable you to easily create reports from complex data simply by using your mouse. Excel expert David Ringstrom, CPA, introduces the basics of creating and using Excel pivot tables in this valuable presentation.
0 Comments
Leave a Reply. |