![]() Databases You Can Access Refreshing the Data. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on. Using Pivot Table Data Outside the Pivot Table Report Create relationships between data from different sources and between multiple tables in a PivotTable. Using the Starting at: and Ending at: fields, you can even specify the range of dates that you want to group if you don’t want to group the entire list. ![]() Right-Click on any cell within the Dates column and select Group from the fly-out list. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Step One: Group your PivotTable by Month. Office 365 is a subscription-based product that provides new-feature updates as often as monthly. David also provides an Excel workbook that includes most of the examples he uses during the session. 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, David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Custom List feature, and others.ĭavid demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel. You’ll learn how to extract data from Microsoft Access databases and other sources, minimize repetitive steps in Excel by creating keyboard shortcuts, and much more. In this presentation, Excel expert David Ringstrom, CPA, digs deeper into pivot tables to show you step-by-step how to manipulate your pivot table data faster and more efficiently.
0 Comments
Leave a Reply. |