Forum Discussion

EricPatterson's avatar
EricPatterson
Icon for Microsoft rankMicrosoft
Aug 16, 2024

Using Copilot in Excel to show additional units of measure

Greetings, This is the fifth in a series of posts that provides examples of what is possible with Copilot in Excel.  Today I will continue with the list of major league baseball ballparks from yesterday.

 

Table with these columns: Name Distance to center field Roof type Center field distance. First 2 rows of data: American Family Field‡ 400 feet (122 m) Retractable 400 Angel Stadium 396 feet (121 m) Open 396

 

Since I previously created a new center field distance column, measured in feet, I’d like to add a separate column that shows the distance in meters. To accomplish this, I'll start by clicking on the copilot button on the right side of the Home tab, showing the copilot pane and type the prompt:

 

Add a new column that shows the center field distance in meters

 

Copilot in Excel looks at the content in the table and then suggests inserting a new calculated column that multiples the center field distance by 0.3048 to calculate the distance in meters.

 

Looking at A1:I31, here's 1 formula column to review and insert in Column J: Center Field Distance (m) Converts the center field distance from feet to meters by multiplying the distance by 0.3048 (meters per foot). =[@[Center Field Distance]]*0.3048

 

Hovering the mouse cursor over the "Insert columns" button in the copilot pane shows a preview of what inserting the new column formulas will look like. From the preview, it looks like it is doing what I wanted.

 

Picture of the list of stadiums with a preview of the new center field distance in meters column that would be added.

 

Clicking on the Insert Column button will accept the proposed change, inserting a new calculated column formula that converts the center field distance from feet to meters.

 

Picture showing the Excel workbook with copilot pane open. Includes the Stadiums table with Center field distance in meters column added.

 

Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.

 

Thanks for reading,

Microsoft Excel Team

 

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

 

No RepliesBe the first to reply

Resources