Master Excel - Pivot Table Advanced Proficiency

In this webinar, speaker David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Linked Picture feature, the PowerPivot feature, and others.

David Ringstrom
Instructor:
David Ringstrom
Date:
Tuesday, September 29, 2020
Time:
10:00 AM PDT | 01:00 PM EDT
Duration:
60 Minutes

More Trainings by this Expert   Product Id : 503303

Price Details
$150 Live
$290 Corporate Live
$190 Recorded
$390 Corporate Recorded
Combo Offers
Live + Recorded
$289 $340 Live + Recorded
Corporate (Live + Recorded)
$599 $680 Corporate
(Live + Recorded)
Price Detail Options
Overview:

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.

You’ll learn how to (1) extract data from Microsoft Access databases and other sources, (2) minimize repetitive steps in Excel by creating keyboard shortcuts, and (3) adapt simple macros that can be recorded. In addition, David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Linked Picture feature, the PowerPivot feature, and others.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 version of Excel (formerly known as Office 365). 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. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Microsoft 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Areas Covered in the Session:

  • Utilizing the Timeline feature in Excel 2013 and later to filter pivot tables based on date ranges
  • Preventing pivot tables from automatically resizing columns when you refresh or filter the data
  • Filtering two or more pivot tables simultaneously by way of the Slicer feature in Excel 2010 and later
  • Summarizing data from Access databases with pivot tables, even if you don't have Microsoft Access installed
  • Displaying two or more pivot tables close together on a single worksheet without triggering a conflict
  • Utilizing the Tabular Format command to display pivot table data in two or more columns instead of a single column in Compact Form
  • Altering the default sort order within pivot tables to a hierarchy of your choice with Custom Lists
  • Resolving situations where data appears more than once within a pivot table
  • Utilizing the Tabular Format command to display pivot table data in two or more columns instead of a single column in Compact Form
  • Altering the default sort order within pivot tables to a hierarchy of your choice with Custom Lists
  • Resolving situations where data appears more than once within a pivot table
  • Determining which refresh commands in Excel update a single pivot table versus all pivot tables in a workbook

Learning Objectives:
  • Recall how to clean up your pivot tables with a mouse click
  • Recognize when and why to apply the Slicer feature
  • Identify pivot table data in new ways by grouping based on dates or custom arrangements that you define
  • Apply the Timeline feature in Excel 2013 and later

Who Will Benefit:
  • Practitioners who would like to learn advanced pivot table techniques to manipulate their data faster and more efficiently


Speaker Profile
David Ringstrom CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.


You Recently Viewed