Sorodne teme
×
Vpišite se z Microsoftovim
Vpišite se ali ustvarite račun.
Pozdravljeni,
Izberite drug račun.
Imate več računov
Izberite račun, s katerim se želite vpisati.
angleščina
Ta članek žal ni na voljo v vašem jeziku.
Generate formula columns with Copilot in Excel

Not sure how to write a formula for a new column? Copilot for Microsoft 365 can help!

Formula columns in Copilot for Microsoft 365 allow you to create new columns in your table that perform calculations based on existing data.  For example, you might use a formula column to calculate the total cost per product, or to calculate the profit for each marketing campaign. With formula columns, you don't need to manually enter calculations for each row in your table. 

Try it

  1. Open Excel in Microsoft 365.

  2. Open a workbook stored on OneDrive or SharePoint.

    Note: Your data must be formatted as a table. See Format an Excel table for additional information. 

  3. From the Home tab, select the Copilot button on the ribbon. 

    Copilot in Excel icon on the ribbon.

  4. Select Add formula columns or Show suggestions for formula columns from the Copilot chat panel on the right-hand side. You can also describe what columns you’d like to add by typing it in your own words.

  5. Copilot provides formula suggestions with an explanation on how each formula works. View the explanation by selecting Explain formula.

  6. Select Insert column to add the formula column to your table.

Note: As with any AI-generated content, it’s important to review, edit, and verify anything Copilot creates for you.  

Give it a try 

Use these prompts as a starting point. Copy and modify them to suit your needs. 

  • Calculate total cost per product in a new column. 

  • Add a column that calculates the total profit for each marketing campaign in 2022. 

  • Add a column that calculates the number of days after the product launch event. 

Learn more

Copilot help & learning

Get started with Copilot in Excel 

Ali potrebujete dodatno pomoč?

Ali želite več možnosti?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Find solutions to common problems or get help from a support agent.

Vam je bila informacija v pomoč?

Kaj je vplivalo na vašo izkušnjo?
Če pritisnete »Pošlji«, bomo vaše povratne informacije uporabili za izboljšanje Microsoftovih izdelkov in storitev. Vaš skrbnik za IT bo lahko zbiral te podatke. Izjavi o zasebnosti.

Zahvaljujemo se vam za povratne informacije.

×