Advanced Microsoft® Excel® PivotTables

Lorman Education Services
Training overview
Professional Course
1.5 hours

Course description

Advanced Microsoft® Excel® PivotTables

Advanced Microsoft® Excel® PivotTables

You know the basics of PivotTables - now become a power user. To be truly proficient in using PivotTables in Excel®, you need to know more than just the basic techniques of creating PivotTables and switching the locations of field. To better use the analytical power of PivotTable tools, you need to master the highly visual presentation tools available through the slicer and timeline features, learn the content expansion capabilities of calculated fields, calculated items, and custom calculations, create external formulas with the GETPIVOTDATA function, and also how to group data based on dates and times, as well as grouping by any criteria you wish. Other features, like drill-down (to see specific source data in a flash), PivotCharts (instant visual support for numerical data), conditional formatting (accentuating results with icons and color variations), and grouping data on an ad hoc basis are also tools that enhance and expand the way you use this powerful feature.

Learning Objectives

  • You will be able to define how to filter PivotTables interactively with slicers.
  • You will be able to describe how to add calculated fields and calculated items to existing PivotTables.
  • You will be able to identify and group data by date and time.
  • You will be able to discuss and create a PivotTable from data on different worksheets and workbooks and use conditional formatting tools to accentuate PivotTable summaries.

  • Want to find out more?

    Who should attend?

    This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, controllers, bookkeepers and accountants.

    Training content

    • Overview of PivotTable ConceptsCalculation Enhancements
    • Custom Calculation - % of Row, % of Column and 12 Others
    • Inserting a Calculated Field
    • Inserting a Calculated ItemAnalytical Tools
    • Slicers – Interactive Filtering
    • GETPIVOTDATA Function
    • Grouping Data by Date and Time
    • Grouping Data on an Ad Hoc Basis
    • Creating PivotTables Then Consolidate Data From Different Worksheets and Workbooks
    • Advantages of Working With Source Data That Has Been Converted to a TableDisplay Enhancements
    • Conditional Formatting
    • Structured Selection
    • Outline vs. Tabular vs. Compact Form
    • PivotCharts


    The cost of this Advanced Microsoft® Excel® PivotTables live webinar is $149 per participant.

    About Lorman Education Services

    Lorman Education Services

    Lorman Education Services - Live and On-Demand Webinars

    With more than 27 years spent educating over 1.4 million professionals, Lorman has the experience and expert instructors you need to stay ahead no matter the position or profession. Search from the many courses listed here or contact the customer...

    Read more and show all training delivered by this supplier

    Request info

    Fill out your details to find out more about Advanced Microsoft® Excel® PivotTables.

      Contact the provider

      Get more information

      Register your interest

    Contact info

    Lorman Education Services

    Lorman Education Services
    2510 Alpine Road
    54702 Eau Claire Wisconsin

    Request Information

    Have a question about this course? Fill out this form and the provider will get in touch with you shortly

    View again
    Supplier Directory
    Join our Supplier Directory to:
    - Gain Traffic
    - Get Noticed
    - Showcase Your Services
    - Free Listing Available