Srodne teme
×
Prijavite se pomoću Microsoft naloga
Prijavite se ili kreirajte nalog.
Zdravo,
Izaberite drugi nalog.
Imate više naloga
Odaberite nalog pomoću kojeg želite da se prijavite.
engleski
Žao nam je. Ovaj članak nije dostupan na vašem jeziku.
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. 

Da li vam je potrebna dodatna pomoć?

Želite još opcija?

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.

Da li su vam ove informacije koristile?

Šta je uticalo na vaše iskustvo?
Kada kliknete na dugme Prosledi“, vaše povratne informacije će se koristiti za poboljšanje Microsoft proizvoda i usluga. Vaš IT administrator će moći da prikupi ove podatke. Izjava o privatnosti.

Hvala vam na povratnim informacijama!

×