Susijusios temos
×
Prisijunkite prie „Microsoft“
Prisijunkite arba sukurkite paskyrą.
Sveiki,
Pasirinkti kitą paskyrą.
Turite kelias paskyras
Pasirinkite paskyrą, kurią naudodami norite prisijungti.
Anglų
Atsiprašome, tačiau šis straipsnis neprieinamas jūsų kalba.
Identify insights with Copilot in Excel

Copilot for Microsoft 365 can show insights based on your data or a specific question you ask about your data. 

  1. Format the data in your spreadsheet as a table, then select it.

  2. Select the Copilot button in the ribbon.

  3. Select Get started.

  4. Select Analyze and choose a suggested prompt. Or describe what you’d like to know by asking a question about your data in your own words.

  5. Select Send. Copilot analyzes your data to show insights as charts, PivotTable objects, summaries, trends, or outliers.

  6. Use the refresh button to discover more prompts.

  7. After Copilot has analyzed your data, review many different insights to find ones that help you make the most of your data.

  8. To add a chart to the sheet, select Add to sheet. If multiple insights are available, you can add all insights to a grid in a new sheet. To undo this, select Undo.

Try this 

Here are some suggestions for prompts you might want to try. Copy them and modify them to suit your data.  

  • Plot sales by category over time. 

  • Show total sales for each product. 

  • Show the total of advertising sales for each region last year

Tip: Be specific with your questions - the more detail you provide, the better Copilot can help. This includes clearly specifying the column headers you want to reference for formatting or analysis queries. 

Reikia daugiau pagalbos?

Norite daugiau parinkčių?

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.

Ar ši informacija buvo naudinga?

Kas turėjo įtakos jūsų įspūdžiams?
Paspaudus mygtuką Pateikti, jūsų atsiliepimai bus naudojami tobulinant „Microsoft“ produktus ir paslaugas. Jūsų IT administratorius galės rinkti šiuos duomenis. Privatumo patvirtinimas.

Dėkojame už jūsų atsiliepimą!

×