Encapsulate Excel Data with Pivot Tables - By Compliance Global Inc.

1
Toll Free 1-844-746-4244 support_at_complianceglob
al.us
Compliance Global Upcoming Webinar

• .

.
Encapsulate Excel Data with Pivot Tables
Speaker David Ringstrom Tuesday , August 25th
0100 PM EST
Compliance Global Inc 2015


www.ComplianceGlobal
.us
2
Upcoming Webinar of David
Ringstrom Encapsulate Excel Data with Pivot
Tables Tuesday , August 25th 0100 PM
EST Overview In this webinar Excel expert David
Ringstrom, CPA helps you master one of the most
overlooked, yet easiest to use features in
Excelcreating Pivot Tables. 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. For the uninitiated,
pivot tables are a means of creating reports in
Excel by simply dragging and dropping with your
mouse. Work that could take hours to do by
manually isolating unique items and writing
summary formulas can be accomplished in seconds.
Not only do pivot tables enable you to easily
summarize large sets of data, you can easily
drill back down into the details with a simple
double-click. Youll also be able to quickly
expand and collapse reports so that you can
always work with as much or as little detail as
you need.
Compliance Global Inc 2015



www.ComplianceGlobal.us
3
Upcoming Webinar of David
Ringstrom Encapsulate Excel Data with Pivot
Tables Tuesday , August 25th 0100 PM EST Why
Should You Attend Even experienced Excel users
sometimes fall prey to nuances in pivot tables.
Pivot tables that arent future-proofed with
Excels 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 ones 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
Compliance Global Inc 2015



www.ComplianceGlobal.us
4
Upcoming Webinar of David Ringstrom Encapsula
te Excel Data with Pivot Tables Tuesday , August
25th 0100 PM EST Areas Covered in the
webinar 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 thats never seen
a pivot table a jump start on summarizing data
Drill down into numbers with a double-click--or
prevent users from being able to do so
Incorporate calculations within, or alongside,
pivot tables Learn the basics of pivot table
creation, as well as differences in the user
interface between Excel 2003, 2007, 2010, and 2013
Compliance Global Inc 2015



www.ComplianceGlobal.us
5
Upcoming Webinar of David
Ringstrom Encapsulate Excel Data with Pivot
Tables Tuesday , August 25th 0100 PM
EST Learning Objective 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 This course will
provide valuable assistance and guidance to all
industry for spreadsheet design techniques that
minimize spreadsheet maintenance and improve
spreadsheet integrity. The following job titles/
positions will benefit from attending this
seminar Human Resource Payroll
Professionals Employee Management Personnel
Compliance Global Inc 2015



www.ComplianceGlobal.us
6
Upcoming Webinar of David Ringstrom Encapsula
te Excel Data with Pivot Tables Tuesday , August
25th 0100 PM EST Level Intermediate
Speaker profile David Ringstrom is a CPA and
owner of Accounting Advisors, Inc., an
Atlanta-based spreadsheet consulting firm that he
started in 1991. David speaks at conferences and
presents webinars to thousands of attendees
annually on Excel and other topics. He has
written hundreds of freelance articles on
spreadsheets, some of which have been published
internationally. David's catch phrase is "Either
you work Excel or it works you." His goal is to
make you a smarter and more effective spreadsheet
user.
Compliance Global Inc 2015



www.ComplianceGlobal.us
7

• Webinars
• Seminars
• Consulting

For more information...www.ComplianceGlobal.us
Or contact us at Toll Free 1-844-746-4244
Tel[phone]Fax [phone] Email
support_at_complianceglobal.us
Compliance Global Inc 2015



www.ComplianceGlobal.us