Sailing itinerary with Copilot in Excel

Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today we have an itinerary for a sailing trip in the Caribbean. I’d like to be able to filter on which days have snorkeling.

 

Sailing itinerary table with columns for Day, Destination, Sail Distance and Highlights. Highlights include different activities for each destination.

 

I ask Copilot to:

 

Add a column with Aye/Nay for which ports will include snorkeling

 

Copilot in Excel pane with the above prompt

 

Looking at B2:E12, here's 1 formula column to review and insert in Column F:

Identifies whether snorkeling is mentioned in the highlights for each day by checking for the presence of the word "snorkel" and marking it as "Aye" if found or "Nay" if not.

=IF(ISNUMBER(SEARCH("snorkel",[@Highlights])),"Aye","Nay")

 

Hovering over the Insert Column button, I see the proposed column.

Sailing itinerary table with columns for Day, Destination, Sail Distance, Highlights, and a preview of new snorkeling calculated column.

 

After clicking on Insert column, I see the new column added.

 

Sailing itinerary table with columns for Day, Destination, Sail Distance, Highlights, and new Snorkeling column.

 

 

Today we were just having a bit of fun with talk like a pirate day in showing what Copilot can do in Excel. Over the coming weeks I will continue to share 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.