Excel Blog:
Kicking off a new weekly series that aims to explore new ways in which Copilot in Excel can help empower and inspire the way you work.
This week, the focus is on how Copilot can create calculated column formulas to improve your tables. The posts highlight formulas that can split full names, concatenate values to create email addresses, work with date columns, convert text to numbers, and show additional units of measure.
Here is an example from Monday, of how Copilot can help split existing columns into multiple columns using a single prompt:
Use Copilot to create new columns given a text prompt
- Monday, 12-Aug - Using Excel Copilot to split columns
- Split an existing column into multiple columns.
- Tuesday, 13-Aug - Adding email addresses using Excel Copilot
- Insert a new column based off an example prompt.
- Wednesday, 14-Aug - Working with date columns using Excel Copilot
- Add a new column where Copilot uses dates to insert a new data column.
- Thursday, 15-Aug - Converting text to numbers with Excel Copilot
- Copilot is able to convert a text column to a number format column.
- Friday, 16-Aug - Using Excel Copilot to show additional units of measure
- Select specified data to create a new column.
Source:
See what's possible with Copilot in Excel
Learn more about how Copilot in Excel can help you in this new weekly series.
techcommunity.microsoft.com
