Professional Course

Advanced Microsoft® Excel® PivotTables

1.5 hours
1.5 hours
This provider usually responds within 48 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.

  • Do you work at this company and want to update this page?

    Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

    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.

    Contact this provider

    Contact course provider

    Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
    If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
    Country *

    reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
    Lorman Education Services
    Lorman Education Services
    2510 Alpine Road
    54702 Eau Claire Wisconsin

    Lorman Education Services - Live and On-Demand Courses

    Lorman Education Services is a leading provider of online professional development and corporate training for organizations and individual professionals. For more than 30 years, Lorman has delivered relevant, high-quality, professional-level courses that cover a broad range of business and technical...

    Read more and show all training delivered by this supplier