Create unique OR content with ChatGPT
Search and store tool for Chat GPT Prompt
Create unique and engaging OR content with ChatGPT, a pre-trained language model by OpenAI for generating high-quality and accurate content.
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
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 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 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 Enable Two-Factor Authentication for Google Sheets Account
How do I enable two-factor authentication for my Google Sheets account?
Exporting Data from Google Sheets to Other Formats
How do I export data from Google Sheets to other formats?
Using Version History to View and Restore Previous Versions of a Sheet in Google Sheets
How do I use version history to view and restore previous versions of a sheet in Google Sheets?
Collaborating on a Sheet in Real Time in Google Sheets
How do I collaborate on a sheet in real time in Google Sheets?
Sharing a Sheet with Others in Google Sheets
How do I share a sheet with others in Google Sheets?
Creating Inventory and Database Sheets in Google Sheets Using Templates
How do I use templates to create inventory and database sheets in Google Sheets?
Exporting Data from Google Sheets to Other Formats Using Scripts
How do I use a script to export data from Google Sheets to other formats?
How to Use a Macro to Format and Clean Data in Google Sheets?
How do I use a macro to format and clean data in Google Sheets?
How to Use Macros to Export Data from Google Sheets to Other Formats
How do I use a macro to export data from Google Sheets to other formats?
Sorting Data in Google Sheets: A Guide
How do I sort data in a sheet in Google Sheets?
Generate an Opinion about Email Triggers and Personalized Messages
How can I use email triggers to send personalized messages based on subscriber behavior?
Creating a Photo Album with ChatGPT
How to make a photo album: A photo album can be a great way to preserve memories and tell your story, and ChatGPT can provide inspiration and tutorials for creating your photo album.
Create a To-Do List Using ChatGPT Tips and Templates
How to create a to-do list: A to-do list can be a great way to stay organized and on track with your tasks, and ChatGPT can provide tips and templates for creating a to-do list that works for you.
Creating a Portfolio with ChatGPT Tips and Templates
How to make a portfolio: A portfolio can be a great way to showcase your work and demonstrate your skills, and ChatGPT can provide tips and templates for creating an effective portfolio.
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.