nawerilike.blogg.se - Pivot table training

#Pivot table training how to#
#Pivot table training update#

Correcting Number Fields Treated as Text 01:23:50.Pivot Table Sorting Nuances (cont.) 01:15:01.Delete Report Filter Worksheets 01:05:29.Generate Multiple Pivot Tables 01:03:13.Pivot Table Subtotaling Quirks 00:48:31.

Adding Columns to Pivot Tables 00:33:09.

Adding Fields to a Pivot Table 00:20:17.

NASBA Field of Study: Computer Software & Applications (2 hours) Instructional Method: Group: Internet-based

Define the default location for pivot table data when you click a checkbox for a given field.

Identify the best approach for formatting numbers within pivot tables.

Identifyhow to expand and collapse groups of data within a pivot table.

Presenting the largest or smallest values in chart form by way of a Top 10 pivot chart.

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.

#Pivot table training update#

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.

#Pivot table training how to#

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.