Excel Pivot Tables 101: 2007, 2010, 2013 and 2016
Instructor:
David H Ringstrom
Product ID: 704603
Training Level: Basic
- Duration: 90 Min
Why Should You Attend:
This webinar will help you learn how to create pivot tables in Excel 2007, 2010, 2013, and 2016. How to instantly create accurate reports from complex data with only a few mouse clicks and use Excel pivot tables to easily create reports? Discover which document format cripple key pivot table related features in Excel 2007 and later. Avoid the common trap that causes Excel to treat numbers as text within a pivot table and save time and avoid frustration by understanding the nuances of pivot table formatting. Quickly summarize data for analysis, but instantly dive into the details when warranted.
Areas Covered in the Webinar:
- Identifying the requirements of ideal data sets to be analyzed with pivot tables.
- Convert obsolete Excel spreadsheet files to modern workbook formats.
- Discovering how pivot tables behave differently from worksheet formulas when you make changes to the underlying data.
- Understand how to avoid the cryptic prompt that appears if you try to rename a pivot table field in the wrong fashion.
- Drill down into the detail of your numbers with a double-click.
- Learn how to use the Recommended PivotTables feature in Excel 2013 and later.
- Identify how to expand and collapse groups of data within a pivot table.
- Identify the best approach for formatting numbers with pivot tables.
- Understand the hierarchy Excel users when adding fields to a pivot table.
- Manage subtotals within your Excel pivot tables.
- Avoid disabled pivot table features by using the appropriate workbook format.
- Understand the significance of refreshing Excel pivot tables.
Who Will Benefit:
- Accountants
- CPAs
- CFOs
- Financial consultants
- Controllers
- Banking
- Finance
- Insurance
- Education
- Telecom
- I.T
- Marketing
- Sales
- Investments
- Pharmaceutical
- Medical Devices
- FDA
- Aviation
- Energy
- Retail
- Human Resource
- Logistics & Supply Chain
- Accounts
- Audit
David H Ringstrom
Owner, Accounting Advisors, Inc
David H. 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. His 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.
Refund Policy
Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange. Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar please contact us at below email or by call mentioning your feedback for resolution of the matter. We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).
