Advanced Techniques for Pivot Tables in Microsoft Excel Webinar

Pivot Tables in Microsoft Excel

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:

bullet create a pivot table or pivot chart

bullet identify the parts of the pivot table window and ribbons

bullet display your pivot table with different data on each page

bullet generate reports from pivot tables split out into separate worksheets for distribution

bullet quickly and easily rearrange data within a pivot table to best suit your needs

bullet perform mathematical functions in pivot tables, such as summing, averaging or counting

bullet change your columns instantly to reflect percentages of the total or or other differences for data analysis

bullet access the data behind pivot table results with one click (and how to prevent others from doing so, if you wish)

bullet consolidate results into segments, such as weeks, months or quarters

bullet use formulas in pivot tables

bullet customize formatting for blank cells or error results

bullet include or remove subtotals and grand totals with your data

bullet show or hide various the sections of your data

bullet have row labels print on each page of your pivot table

bullet insert blank lines between items of data

bullet sort and filter the date for maximum effectiveness

and more!!!

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.

Student Name
Preferred Email Address