How to create a great Microsoft Copilot prompt | Microsoft Copilot Tutorial
- Make it specific
- Give some context
- Guide the response
- Review and revise
RICCE = Role, Intent, Context, Constraints, and Examples
- Include task and details
- Structure your prompt
- Set expectations
- Iterate and refine
- Verify outputs
CREATE framework:
- Characeter
- Request
- Examples
- Additions
- Type of output
- Extras
Making Prompts Re-Usable
{variable} <-- put this in your prompt
Spreadsheet of Prompts
Get the example spreadsheet file at: davebirss.com/ai-productivity
- Columns:
- PROMPT NAME
- DESCRIPTION
- CHATBOT
- PROMPT
- VARIABLES
- WRITER
5 Examples from the spreadsheet above:
i) Plan A Project
You are a highly experienced project manager who has a reputation for running successful projects. I want you to help me create a project plan for {project title}. Here are the {details}. The project will begin on {start date} and it needs to be delivered on {end date}.
Start by listing project objectives that are specific and measurable, list the success metrics, list the milestones and deliverables. Now ask me if I'd like to see the timeline. Stop and wait for my response. Do not continue until I answer.
If I say yes, show a timeline as a table. The timeline will include the different stages of the project, the job title with responsibility for the task and the dates they should start and end. Break the tasks down into as many smaller tasks as you can and present it in a tabular format. Remember that some tasks can happen concurrently so there will be overlaps in the timeline.
{project title}:
{details}:
{start date}:
{end date}:
ii) Generate Ideas
You are a highly experienced and awarded creative thinker with the ability to come up with fresh and different ideas. I want you to provide 5 unexpected ideas about {subject}. These ideas should not use the typical approach or copy what other people are doing. Please present your ideas using markdown and bullet points, giving each idea a snappy title and then clearly describing the idea. Once you have given me your ideas, I want you to ask me if I would like you to expand on any of them. Stop and wait for my response. If I select one of the ideas, I want you to expand on it by writing the following sections: title, one sentence description, full description, what makes the idea so good, how to make the idea happen and the resources needed to make it happen.
{subject}:
iii) Generate a Mind Map
You are an expert at creating mind maps, breaking down topics into their constituent parts and sub-parts. I'm going to give you a {subject} and you're going to use markdown to deliver a mind map in a list format.
{subject}:
iv) Excel Formula Creator
Play the role of an excel spreadsheet expert with an uncanny ability to write the perfect formula for the situation. I’m going to give you {context} about my spreadsheet and the {calculation} or action I want, and you’re going to reply with the exact formula I need. Assume that I don’t know anything and need everything explained to me clearly and simply. Start by giving me a code box with the simplest and most direct formula that answers my query - together with a step-by-step explanation of how to implement it successfully. Follow this with an explanation of how your formula works, breaking it into its elements and making it simple for me to understand. If there are alternative methods that would achieve the same thing, tell me what they are and a brief description of how they work.
{context}:
{calculation}:
v) Create visual aids and graphics
Play the role of an expert graphic designer with a lifetime of experience designing images that help communicate a concept. I need your help creating an image to help me communicate {concept}. I want you to start by channeling the great graphic designers and giving me 10 very different suggestions of how you could bring this concept to life visually. Avoid cliches and obvious approaches. Think conceptually. Consider approaches like cartoon strips, infographics, combining elements, showing consequences, before and after, isometric, scientific annotations, visual metaphors, collage, diagrams, charts, flat layouts, cinematic, typography, graffiiti, abstract representations, future scenarios. Present me with your 10 suggestions along with text for an AI image generator to create it in the {style} with {aspect_ratio}.
Then ask me if I would like you to create one of the images. If I select an image, please create it in {style} with {aspect_ratio}.
{concept}:
{aspect_ratio}:
{style}:
Comments
Post a Comment