Create unique Tips with ChatGPT

Search and store tool for Chat GPT Prompt

Create unique and engaging Tips with ChatGPT, a pre-trained language model by OpenAI for generating high-quality and accurate content.

Generate an Opinion about Using the SUMIF and SUMIFS Functions with Wildcards in Excel

Write me an excel command to use the SUMIF and SUMIFS function with wildcards to sum cells that match specific criteria containing wildcards

ChatGPT: Automate Extracting Words from Cells When Conditions are Met

Extract the fourth word in [Cell] only when cell [Cell Number] is greater than 100 and when [Cell] starts with the word xyz and ends with the word zyx Example: Extract the fourth word in A1 only when cell B1 is greater than 100 and when C1 starts with the word hello and ends with the word goodbye

Coding an Excel Macro to Generate an Employee Table with 10,000 Randomized Entries

Code an excel macro to generate and employee table with the following columns and 10000 randomized entries

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 Google Sheets Data Protection Feature to Protect Ranges from Editing

How do I use the Google Sheets Data protection feature to protect ranges from editing?

Using the REPLACE Function in Google Sheets to Replace Specific Values

How do I use the Google Sheets REPLACE function to replace specific values in a sheet?

How to Use the Google Sheets FILTER Function to Filter and Remove Unwanted Data

How do I use the Google Sheets FILTER function to filter and remove unwanted data?

How to Use the Google Sheets Flash Fill Feature to Automatically Fill Data in a Sheet

How do I use the Google Sheets Flash fill feature to automatically fill data in a sheet?

How to Use Google Sheets Remove Duplicates Feature to Remove Duplicate Data in a Sheet

How do I use the Google Sheets Remove duplicates feature to remove duplicate data in a sheet?

How to Use Google Sheets Text to Columns Feature to Separate Data into Different Columns

How do I use the Google Sheets Text to Columns feature to separate data into different columns?

How to Use the Google Sheets Find and Replace Feature to Search and Remove Unwanted Data in a Sheet

How do I use the Google Sheets Find and Replace feature to search for and remove unwanted data in a sheet?

How to Use Google Sheets Data Validation to Clear Validation Rules?

How do I use the Google Sheets Data validation feature to clear validation rules?

Creating an Opinion about the Google Data Validation Feature and Adding Custom Error Messages

How do I use the Google Sheets Data validation feature to add custom error messages?

Creating Custom Validation Formulas Using Google Sheets Data Validation Feature

How do I use the Google Sheets Data validation feature to create custom validation formulas?

How to Use Google Sheets Data Validation Feature to Set Data Validation Rules

How do I use the Google Sheets Data validation feature to set data validation rules?

How to Use Google Sheets Data Validation Feature to Restrict Data Input?

How do I use the Google Sheets Data validation feature to restrict data input?

How to Use Google Sheets Custom Time Formatting Feature to Format Data?

How do I use the Google Sheets custom time formatting feature to format data?

Using the Google Sheets IMPORTJSON Function to Import Data from the Web

How do I use the Google Sheets IMPORTJSON function to import data from the web?

How to Use Google Sheets Auto-Fill to Populate Data Quickly

How do I use the Google Sheets auto-fill feature to populate data quickly?

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.


What is prompt engineering

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.


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.
play background gpt3

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.