Log in

Patent Information Users Group, Inc.

The International Society for Patent Information Professionals

Log in

Webinar 2: Using PivotTables and MS Excel to Generate Simple Charts, Graphs and Tables

  • 28 Feb 2019
  • 11:00 AM - 12:00 PM
  • Webinar
  • 98


Registration is closed

Preparing Patent Analytics Projects and Patent Landscape Reports- Hands-On Lessons

PIUG presents an opportunity to learn valuable practical skills from Tony Trippe, a leading expert with many years of experience in Patinformatics. Join us for a series of webinars providing details on some of the stages required for performing patent analytics, and for the preparation of a Patent Landscape Report (PLR).

Patent analytics and PLRs support informed decision-making and are designed to efficiently address the concerns associated with making high stakes decisions in technologically advanced areas with a maximum degree of confidence. For many years’ decision-makers operated based on personal networks and intuition. With the institution of patent analytics, and PLRs, it is possible for these critical decisions to be made with data-driven approaches that deliver informed choices, and lower risk profiles. Working with patent data can be complicated due to the nature of the subject matter, and the lack of standard in the way it is delivered from the offices that generate it.

This four part series of webinars provides specific steps for the production of patent analysis projects and PLRs including step-by-step instructions for performing these operations:

  • 2.       Using PivotTables and MS Excel to Generate Simple Charts, Graphs and Tables
    • Once a data table has been created in a workbook or a spreadsheet a number of interesting and insightful analyses can be conducted using common office software tools that most practitioners have access to. The most common of these MS Excel and the PivotTable function is one of the most powerful functions available for comparing fields, or in the case of a spreadsheet columns that represent the attributes of a patent family. This webinar will cover the basics of generating a PivotTable from a data table and using this functionality to generate statistical data from a patent collection. There will also be hands-on examples of using this statistical data to create bar and column charts, as well as line graphs and table to provide insights into a patent data set.

Time listed is in US Eastern Time Zone

© 2022 The Patent Information Users Group, Inc.   

Mailing Address:  40 E. Main St., #1438

Newark, DE  19711

Phone: +1 (302) 660-3275   Fax: +1 (302) 660-3276



Follow PIUG:  


Go to PIUG TwitterGo to PIUG LinkedIn

Notice on use of PIUG name and logo:  

No one may use the PIUG name or logo for any promotional or commercial purpose or any other purpose without the prior written consent of the PIUG Board of Directors.  

Powered by Wild Apricot Membership Software