Advanced Techniques for Pivot Tables in Microsoft Excel Webinar
Pivot Tables are one of the best things since sliced bread! They allow you to summarize your raw data into useful information. Learn all about these fantastic features in this webinar.
Participants will learn how to:
create a pivot table or pivot chart
identify the parts of the pivot table window and ribbons
display your pivot table with different data on each page
generate reports from pivot tables split out into separate worksheets for distribution
quickly and easily rearrange data within a pivot table to best suit your needs
perform mathematical functions in pivot tables, such as summing, averaging or counting
change your columns instantly to reflect percentages of the total or or other differences for data analysis
access the data behind pivot table results with one click (and how to prevent others from doing so, if you wish)
consolidate results into segments, such as weeks, months or quarters
use formulas in pivot tables
customize formatting for blank cells or error results
include or remove subtotals and grand totals with your data
show or hide various the sections of your data
have row labels print on each page of your pivot table
insert blank lines between items of data
sort and filter the date for maximum effectiveness
Attendees will be provided access to the live webinar as well as access to the recording for 30 days. All attendees will receive a handout with step by step instructions detailing what was covered during the webinar. In addition, a letter can be provided that is suitable for submitting for 1.5 Certified Administrative Professional (CAP) recertification points.
About the Instructor
Marie Herman, CAP-OM, ACS
When it comes to career and professional development to help administrative professionals advance, Marie Herman, CAP, OM, ACS, MOSM knows how to take you from where you are, to where you want to be. She has made her career helping others to develop their skills through strategic planning, website design, and technology. With certification as an internet webmaster designer, Microsoft Office Specialist (Master Level), Advanced Toastmaster-Silver, and an Associate's Degree in Business, Marie has an expansive knowledge in many areas, and can help you become an expert as well. She is an author, mentor, and expert on a number of computer and professional development topics. Marie is the owner of MRH Enterprises and teaches classes on Microsoft Office, Windows, and various other internet topics. She has been a member of the International Association of Administrative Professionals (IAAP) since 1997 and was the 2012-2013 President of the Illinois Division of IAAP. She has more than two decades of experience as an administrative professional and efficiency consultant.