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.
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.”
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.