Learn the basics of creating and using Excel pivot tables in this comprehensive webcast presented by Excel expert David Ringstrom, CPA. Pivot tables allow you to create reports from complex data simply by using your mouse. David explains how to initiate a pivot table from a list of data, expand and collapse pivot table elements, remove fields from a pivot table, and more. Pivot tables have a few nuances that can trip up the unaware user, so David points out the traps and shares tricks that will help ensure the reports you create are accurate.
Those who wish to learn how to use Excel pivot tables to easily create accurate reports.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016.
David draws participants’ attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts.
David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward.
David provides an Excel workbook that includes a majority of the examples he uses during the session
Those who wish to learn how to use Excel pivot tables to easily create accurate reports.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016.
David draws participants’ attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts.
David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward.
David provides an Excel workbook that includes a majority of the examples he uses during the session
David H. Ringstrom
David H. 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 dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
How to Write Contracts for Procurement Professionals
Sunshine Act Reporting - Clarification for Clinical Research
How to Deal with Employees Who Love to Argue and Debate Eve…
Project Management for administrative professionals
ChatGPT and Project Management: Leveraging AI for Project M…
Onboarding Best Practices for 2025: Proven Strategies to Po…
Terminating Toxicity: Strategies For Leaders To Confidently…
Transform Data into Insights: A Beginners Guide to Excel Pi…
Reprogramming your mind for Corporate Excellence: 4 Steps t…
How to Write Effective Audit Observations: The Principles f…
How to Manage the Legal Landmine of the FMLA, ADA and Worke…
Uplifting the Credibility of HR: How to Build the Credibili…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Bridging Generational Divides in the Workplace
Strategic Interviewing & Selection: Getting the Right Talen…
Onboarding Best Practices for Millennial and All Employees
2-Hour Virtual Seminar on How to Conduct an Internal Harass…
FDA Audit Best Practices - Do's and Don'ts
Emotional Intelligence: Mastering the Emotions of Great Lea…
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Accounting For Non Accountants : Debit, Credits And Financi…
Successful Strategies for FDA Expedited Pathways for Your D…
Regulation update Q1 2025: New and Proposed Regulations for…
Pay Transparency in Action: Strategies for Building Trust a…
Designing Employee Experiences to Build a Culture of Compli…
Developing and Implementing Quality Culture in the Organiza…
Excel Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP Made …
Break Free from Toxicity: Reclaim Your Power and Peace
Tips and Techniques for Conducting an Effective Fraud Risk …
Physician Employment Agreements: Problem Areas that can be …
Measure the Effectiveness of Compliance Programs by Engagin…
FDA Regulation of Artificial Intelligence/ Machine Learning
Navigating 2025 Employment Laws: What Every Employer Needs …
Implementing an Effective Human Error Reduction Program
Cleaning Data without Complex Functions - A Course for Data…
Succession Plan for 2025: It's Not Just for Emergencies - I…
Employers Should Prepare for Immigration Raids in 2025! Thi…
Managing Toxic Employees: Strategies For Leaders To Effecti…
Using High-Performance Coaching for Managers to Address Per…
6-Hour Virtual Seminar on Learning the Highlights of Excel …
Principles & Practices for the Cybersecurity of Legacy Medi…