Menu
Log in


Patent Information Users Group, Inc.

The International Society for Patent Information Professionals

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


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

© 2019 The Patent Information Users Group, Inc.

Mailing Address: 40 E. Main Street, #1438, Newark, DE 19711
Phone: +1 (302) 660-3275 | Fax: +1 (302) 660-3276 | Email: PIUGinfo@piug.org
Webmaster: Tom Wolff (webmaster @ piug.org) – Updated: 28 January 2019

Follow PIUG: Go to PIUG Twitter page Go to LinkedIn PIUG group page Go to PIUG wiki
Authorize.Net Merchant - Click to Verify Credit Card Online Payments
Powered by Wild Apricot Membership Software