Skip to main content

BPOpti Ribbon

finPack adds a BPOpti tab to the Microsoft Excel Ribbon.

The BPOpti Ribbon provides quick access to finPack and related external resources.

The Ribbon is organized into three groups:

  • finPack
  • Data Sources
  • Resources

BPOpti Ribbon

finPack​

The finPack group contains the main command for opening the finPack task pane.

Open finPack​

Select Open finPack to display the finPack task pane on the right side of Excel.

The task pane provides access to:

  • CPI Data
  • CPI Value
  • CPI Average Change
  • Diagnostics

You can leave the task pane open while working in your workbook.

Data Sources​

The Data Sources group provides direct access to the official CPI websites used as sources for finPack data.

Statistics Canada​

Select Statistics Canada to open the Statistics Canada Consumer Price Index portal in your web browser.

Use the provider website when you want to review published Canadian CPI information or learn more about the underlying CPI data.

U.S. BLS​

Select U.S. BLS to open the Consumer Price Index website of the U.S. Bureau of Labor Statistics in your web browser.

Use the provider website when you want to review published U.S. CPI information or learn more about the underlying CPI data.

Resources​

The Resources group provides access to BPOpti resources.

BPOpti Website​

Select BPOpti Website to open the BPOpti website in your web browser.

Additional resources, including direct access to this documentation, may be added to this group in future releases.

Using the Ribbon with the task pane​

The BPOpti Ribbon and the finPack task pane serve different purposes.

Use the BPOpti Ribbon to:

  • Open finPack.
  • Access CPI data-provider websites.
  • Access BPOpti resources.

Use the finPack task pane to:

  • Browse CPI countries and series.
  • Load CPI data.
  • Retrieve CPI values.
  • Calculate CPI Average Change.
  • Insert CPI information into Excel.

Next step​

Continue to CPI Data to learn how to select a country and CPI series, review the latest CPI information, and insert CPI history into Excel.