Mastering Excel Pivot Tables

  EVENT DATE

July 09, 2019

  PRESENTER(s)

Dennis Taylor

  1:00 PM ET | 12:00 PM CT | 10:00 AM PT | 90 Minutes


* Not able to attend the live session? We can arrange an on-demand session for You. Please call 1-‪814-892-0304


DESCRIPTION



A PivotTable in Excel is a summary table based on a list of data; it is distinct and separate from the original data, yet dependent on it. Changes you make to a PivotTable have no impact on the original data. With a PivotTable, you can find trends, analyze patterns, and complete multiple summaries based on your detailed (and sometimes voluminous) worksheet data.

In order to manage large data lists, there are many types of Excel tools available like sorting, filtering etc. However, if you need to analyze your data quickly, a PivotTable is the answer. You can create compact summary reports without writing complex formulas and you can quickly change the data interrelationships that you are viewing. A PivotTable is one Excel’s best analytical tools.

Many Excel users find PivotTables relatively easy to understand, but it is a feature that is awkward to learn if you’re just viewing instructions from a printed page. It’s a visually-oriented feature (ideal for being presented via a webinar) based on displaying fields in different locations.

To learn not just the basics but also shortcuts and power tools associated with PivotTables, attend this session by expert speaker Dennis Taylor. You will be able to create PivotTables from different input sources and use different options like conditional formatting, slicers, and date consolidation efficiently.

Session Highlights:

Comparing two or more fields in different styles Filtering and sorting results Using a more powerful filtering method – Slicers Making use of timelines for dynamic time-based displays Resurrect relevant source data with drill-down Categorizing date/time data in various levels Creating a Pivot Chart that’s in sync with a Pivot Table Putting in calculated fields in order to do additional analysis Ways to reveal/hide detail/summary information with a single click Ways to deal with the “refresh” concept and dynamic source data Techniques for applying Conditional Formatting to a PivotTable Generating PivotTables from various input sources (different workbooks and worksheets) Making use of the new Timeline feature Exploring the best techniques for updating Pivot Tables Creating ad hoc and date-based groupings within a Pivot Table 

Who Should Attend:

  • C Level Executives
  • Executive Assistants
  • Accountants
  • Administrators
  • Office Managers
  • Attorneys
  • CPA
  • Finance Professionals
  • Business Analyst
  • Accountants
  • Bookkeeper
  • HR Professionals

Download Conference Material

Download Here (Password Needed)




RELATED Virtual Summit

 


CERTIFICATION PARTNERS

HRCI
HRCI
HRCI
HRCI