Pivot Tables can summarize your data in Microsoft Excel and save you hours of time and effort. This program will provide an overview of pivot tables, including what they are, how to set up your data to create them, the parts of the pivot table window and how they interact and how to overcome some of the common issues people experience. You’ll learn how to format your pivot tables so they display the data precisely the way you need and discover the options you can modify to work with your data with ease.
Attendees will learn:
Individuals who attend this training will become more efficient with Microsoft Excel and discover the power of Pivot Tables in manipulating and summarizing their data. Take advantage of the full functionality of this feature of Excel. The training will be delivered using Office 365 (2019) for Windows although, for users of earlier versions, the functionality is available in Office 2010/2013/2016.
Any office professional who works with large amounts of Excel data.
Marie Herman CAP, OM, ACS, MOSM, conducts seminars and workshops around the world on technology and professional development topics. She leads online study groups for a variety of certification programs, including the Certified Administrative Professional exam and the Microsoft Office Specialist Master program. She writes a regular feature in Executive Secretary Magazine and has hosted multiple #adminchats.
She worked as an administrative professional for several decades, with past positions including support of the chief technology officer of the Fermi National Accelerator Lab and the Chairman Emeritus of ServiceMaster, a Fortune 1000 company. She has been a member of the International Association of Administrative Professionals (IAAP) since 1997, serving in a variety of leadership and other roles. In addition to being a Certified Administrative Professional with an Organizational Management specialty, she is also a Microsoft Office Specialist, certified at the master level in multiple versions of Microsoft Office.