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.
These posts will be pinned within the Tech Community Forum, where you can follow along. Here is the pinned post from the week of August 12th - 16th.
Microsoft
