Prompts to try
Press Enter to insert a prompt.
Write a formula [for the average of each column]
Add a column to compare [FY24 sales] and [FY23 sales]
Add a column [that calculates the difference of two dates]
Are there any trends in my data?
Create a column that calculates [the total sales for each employee and insert it to column B]
Add two columns that split [employees' combined name into separate first and surnames]
What are some tricks for working with dates?
How do I create a drop-down menu?
Which items have the most [remaining inventory]?
Add a column to extract the month from the date
Add a column that combines [the customer's first and surname]
Highlight the [lowest 5 budgets]
How many different [teams are in this table?]
Suggest a column
Visualise this data
What is the percentage of [total revenue from each region?]
Quick tips for better prompts
Make it specific
Provide short details about what you want to do.Summarise this email in two bulleted points.
Give some context
Specify the tone you want.Write a blog post that sounds professional and witty.
Guide the response
Use cue words at the end of your prompt to give Copilot better directions.Write an article about elephants. Include: Habitat, Diet
Review and revise
Check results to make sure they're correct and refine your prompts as you go.Lions are native to ... the Arctic.