Advanced Techniques Webinar - Microsoft Excel Pivot Tables

Advanced Techniques Webinar

$30.00

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

  • and much 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 for those on the live session that is suitable for submitting for 1.5 Certified Administrative Professional (CAP) recertification points.

    About the Instructor

    Marie Herman, CAP, OM, ACS, MOSM

    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 and technology. With certifications as an Microsoft Office Specialist (Master Level) and a Certified Administrative Professional with an Organizational Management specialty, 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 LLC 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 a past Division President. She has more than two decades of experience as an administrative professional and efficiency consultant. Marie has helped thousands of students achieve their certification dreams.

    Student Name
    Preferred Email Address