Create unique Cells with ChatGPT
Search and store tool for Chat GPT Prompt
Create unique and engaging Cells with ChatGPT, a pre-trained language model by OpenAI for generating high-quality and accurate content.
Using ChatGPT to Count Cells with Data in Excel: A Step-by-Step Guide
Write me an excel command to use the COUNT function to count the number of cells with data in a range
Cough + Opacities Progress Note
Please write a progress note for a 62-year-old man being worked up for a continuous cough and pulmonary opacities. Antineutrophil cytoplasmic antibody and anti–double-stranded DNA antibody tests were negative, normal C3 and C4 levels. Negative urine legionella antigen. A bronchoscopy and transbronchial biopsy were conducted. Right middle lobe bronchoalveolar-lavage fluid was cloudy. Fluid analysis...
Using the CONCATENATE Function to Combine Text from Multiple Cells into One Cell
How to use the CONCATENATE function to combine text from multiple cells into one cell
Generating an Opinion about the Use of Excel Functions SUMIF, IF and LEN
Write me an excel command to use the SUMIF, IF and the LEN function together to sum the values of cells based on a specific condition and the length of a text in another cell
Creating a Custom Error Message for Protected Cells in Google Sheets Data Protection
How do I use the Google Sheets Data protection feature to create a custom error message for users who try to edit protected cells?
Creating a Warning Message for Users Before Editing Protected Cells in Google Sheets
How do I use the Google Sheets Data protection feature to create a warning message for users before editing protected cells?
How to Use the Protect Sheet Feature to Lock Cells or Ranges in a Sheet
How do I use the Protect sheet feature to lock certain cells or ranges in a sheet?
How to Use the Protect Range Feature to Lock Certain Cells on a Shared Sheet in Google Sheets
How do I use the Protect range feature to lock certain cells on a shared sheet in Google Sheets?
Using the CONCATENATE Function to Join Text from Multiple Cells into One Cell
Write me an excel command to use the CONCATENATE function to join text from multiple cells into one cell
Creating an Opinion about the Excel MIN Function
Write me an excel command to use the MIN function to find the lowest value in a range of cells
Generating an Opinion about the Content of an Excel Command for the MAX Function
Write me an excel command to use the MAX function to find the highest value in a range of cells
Generate an Opinion about the Excel AVERAGE Function
Write me an excel command to use the AVERAGE function to calculate the average of a range of cells
Generating an Opinion about the SUM Function in Excel
Write me an excel command to use the SUM function to add up a range of cells
Finding the MAX and MIN Values in a Range of Cells Using MAX and MIN Functions
How to use the MAX and MIN functions to find the largest and smallest values in a range of cells
Understanding How to Use AVERAGEIF and AVERAGEIFS Functions to Calculate Average of Cells Meeting Specific Criteria
How to use the AVERAGEIF and AVERAGEIFS functions to calculate the average of cells that meet specific criteria
Summing Cells with the SUMIF and SUMIFS Functions in Excel
How to use the SUMIF and SUMIFS functions to sum cells that meet specific criteria
Understanding Google Sheets Data Protection Feature to Track Changes in Protected Cells
How do I use the Google Sheets Data protection feature to track changes made to protected cells?
How to Use Google Sheets Data Protection Feature to Allow Certain Users to Edit Protected Cells
How do I use the Google Sheets Data protection feature to allow certain users to edit protected cells?
Understanding Google Sheets Data Protection and Conditional Formatting for Protected Cells
How do I use the Google Sheets Data protection feature to set conditional formatting rules for protected cells?
Using Google Sheets Data Protection Feature to Protect Cells from Editing
How do I use the Google Sheets Data protection feature to protect cells from editing?
What is “prompt engineering”?
A “prompt” is the input that guides a generative AI model to generate useful outputs. Generative AI tools like ChatGPT, GPT, DALL·E 2, Stable Diffusion, Midjourney, etc. all require prompting as their input.
In a natural language processing (NLP) context, “prompt engineering” is the process of discovering inputs that yield desirable or useful results. As is the story with any processes, better inputs yield better outputs; or commonly said another way “garbage in, garbage out.”
![Source: https://www.youtube.com/watch?v=1NQWJjgi-_k
Designing effective and efficient prompts will increase the likelihood of receiving a response that is both favorable and contextual. With a good prompt, you can spend less time editing content and more time generating it.
Going from beginner → advanced prompt engineer
As companies like PromptBase arise around the idea that the prompt is the “secret sauce” to using generative AI, prompt engineering could easily become the “career of the future.” But, any generative AI user can become an “advanced” prompt engineer. Here’s how
Spend time with the tools
- The more time you spend asking ChatGPT questions and receiving responses, the better your idea will be of various prompting approaches and their individual strengths and weaknesses
- Use Open AI’s GPT playground to perform interactive trial and error with variations in your prompt, model, temperature and top_p values (uniqueness of answer, i.e. creativity), and more available within the UI itself.
Become a prompt researcher instead of engineer
- If you’re already a subject matter expert in something, consider figuring out how to apply your personal skills to generating the best prompts in your field
- For example, if you’re an expert in SEO, what questions do you ask yourself when creating SEO strategies? How can you translate this knowledge into better prompts to generate the same level of output with AI?
Become a prompt researcher instead of engineer
- The term prompt engineer glosses over the idea that prompt formulation takes hypothesizing, research, result measurement, and repetition. Instead, approach prompting like a research project.
- Try as many different variations and formulations of your prompt as possible. One problem can have hundreds of solutions and one solution can have hundreds of approaches. The same can be said of prompting.