Encapsulate Excel Data with Pivot Tables - By Compliance Global Inc

NEW HYDE PARK, N.Y. - Aug. 10, 2015 - PRLog -- Overview

The webinar leads off with techniques for quickly transforming raw data into pivot table-ready formats. The webinar then moves into creating pivot tables, expanding and collapsing data, and issues that can affect pivot table integrity.

David will teach from primarily from Excel 2010, but will demonstrate new features in Excel 2013 when warranted, as well as disclose any differences in Excel 2007.  As a special feature of this webinar, David will provide four different handouts so that you can see exactly how pivot tables work in your version of Excel. The handouts will be specific to:

• Excel 2013
• Excel 2010
• Excel 2007
• Excel 2003

Why Should You Attend

Even experienced Excel users sometimes fall prey to nuances in pivot tables. Pivot tables that aren’t future-proofed with Excel’s Table feature can lead to data integrity issues should another user append more data to the original list
•  The choice of workbook format can vastly color one’s pivot table experience. Users relying on workbooks saved in the legacy XLS document format may encounter disabled features in Excel, as well as inefficient pivot table formatting
•  Seemingly simple tasks related to pivot tables such as applying number formats can yield to frustration as changes to the structure of a pivot table can cause formatting to be discarded. In this webinar David shows you the right way to ensure that your formatting never gets lost

Areas Covered in the Session

•  Avoid frustration by understanding the nuances of pivot table formatting. Pivot tables are best thought of as having one foot in worksheet cells and one cell out
•  Dig deeper into the numbers by using the Report Filter command to create break-out tables. This empowers you to easily share reports with team members by breaking their data out to separate worksheets
•  Disable the GETPIVOTDATA function if you don't need it for your analysis. This function can make simple ad hoc calculations involving pivot table data more difficult than necessary
•  Discover the new Recommended Pivot Tables feature in Excel 2013, which gives even someone that’s never seen a pivot table a jump start on summarizing data

Learning Objectives

•  Quickly transform lists of raw data into usable reports in just a few simple steps
•  Format and analyse pivot table data with ease
•  Avoid frustration by understanding nuances in your data that can cause errors or integrity issues in pivot tables

Who Will Benefit

•  Human Resource
•  Payroll Professionals
•  Employee Management Personnel
•  Auditors
•  Managers
•  Admin
•  Anyone that builds spreadsheets for use by others

Level:

Intermediate

For more information, please visit  https://www.complianceglobal.us/product/700167