asap19-eureka-house-ad-green.png

Excel Pivot Tables Made Easy

Share


When you analyze data in large Excel worksheets, does it feel like you are looking for a needle in a haystack? If you answered yes, you’ll probably benefit from PivotTables.

PivotTables make data analysis easier by providing a simple way to run reports on specific information. They also reduce the amount of time it takes to create a report from an Excel spreadsheet.

During this introduction to Excel PivotTables, you’ll get an overview of the feature, and learn to:

  • Choose fields to display in a PivotTable.
  • Edit the fields in a report.
  • Rearrange fields for row and/or column display.
  • Perform calculations in a PivotTable.
  • Run filters.
  • Update a PivotTable.
  • Group date fields.
  • Use quick charts.

Learn to maximize the benefits of Excel for your professional and personal use!

PivotTables are easier than they look! Learn how this valuable feature can make you look like an Excel genius.

About Julie Perrine: Julie Perrine is an executive assistant turned founder of All Things Admin. She is an enthusiastic trainer, author, Certified Myers-Briggs Type Indicator Administrator, and perpetual planner. As an advocate of the administrative profession, Julie encourages admins to be prepared, hone their skills, and always keep their minds open to new career opportunities.

Looking for more webinar access? Become an ASAP Professional Member and have unlimited access to ASAP's expansive webinar library. Learn More Here!

Published:

November 20, 2024

Join the Conversation

Welcome to the ASAP Circle, a community platform for peer-to-peer conversation on trending topics, professional challenges, and shared experiences. We even have designated spaces for weekly Tuesday Coffee Breaks.

Start Connecting Today!

Webinar FAQ's


What online training is included with ASAP Membership? 

You must be a Free or Professional Member to attend webinars. Certain webinars are exclusive to Professional Members ($199/year). Courses and workshops are not included with Membership. Learn more about the differences between webinars, courses, and workshops here

How do I access my webinar, course, or workshop?

Live sessions: You’ll receive a confirmation email from ON24, but your order confirmation email and Order History > Order Details will have a direct link to join as well. | On-demand: The post-checkout screen, your order confirmation email, and Order History > Order Details will have links to the on-demand materials.

Will I get a recording and certificate? 

Yes! Both the recording and certificate can be found under Order History > Order Details. For live sessions, please wait 1 to 3 business days after the live session for these materials to be uploaded (you’ll receive them via email as well). If you can’t attend the live session, you will still receive the recording.

Read more FAQs here.

American Society of Administrative Professionals

Producer of

APC  EA Ignite