Create unique Prompt with ChatGPT
Search and store tool for Chat GPT Prompt
Create unique and engaging Prompt with ChatGPT, a pre-trained language model by OpenAI for generating high-quality and accurate content.
How to Avoid Creating Offensive or Inappropriate Content
How do I avoid creating content that is offensive or inappropriate?
How to Create the Perfect Prompt with ChatGPT
I want you to become my Expert Prompt Creator. Your goal is to help me craft the best possible prompt for my needs. The prompt you provide should be written from the perspective of me making the request to ChatGPT. This will be a prompt entered into an interface for GPT3 or ChatGPT, so consider that in your prompt creation. You will follow this process: 1. Your first response will only be to as...
Using Excel's DATE and TIME functions to insert the current date and time into a cell
Write me an excel command to use the DATE and TIME functions to insert the current date and time into a cell
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
How to Use Google Sheets Data Protection Feature to Protect Sheets from Editing?
How do I use the Google Sheets Data protection feature to protect sheets from editing?
How to Use the Google Sheets TRIM Function to Remove Extra Spaces from Data in a Sheet?
How do I use the Google Sheets TRIM function to remove extra spaces from data in a sheet?
Using Google Sheets Principal Component Analysis (PCA) to Analyze Data
How do I use the Google Sheets principal component analysis (PCA) to analyze data?
Using Google Sheets Histogram Chart Feature to Visualize Project Timelines
How do I use the Google Sheets histogram chart feature to visualize project timelines?
Using Google Sheets Pivot Table Sort Options to Sort Data in a Pivot Table
How do I use the Google Sheets Pivot table sort options to sort data in a pivot table?
How to Use the Google Sheets TRANSLATE Function to Translate Data in a Sheet?
How do I use the Google Sheets TRANSLATE function to translate data in a sheet?
Receiving Notifications for Changes on a Shared Sheet in Google Sheets
How do I receive notifications for changes on a shared sheet in Google Sheets?
Creating Invoices and Receipts in Google Sheets Using Templates
How do I use templates to create invoices and receipts in Google Sheets?
How to Create Budget Spreadsheets in Google Sheets Using Templates
How do I use templates to create budget spreadsheets in Google Sheets?
Tips for Writing Effective Business Documents
What are some tips for writing effective business documents?
Five Chat GPT Features for Testing and QA
Make a list of five Chat GPT features that can aid testing and QA.
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
Using the INDEX, MATCH and COLUMNS function together to find the last column of data in a sheet
Write me an excel command to use the INDEX, MATCH and COLUMNS function together to find the last column of data in a sheet
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
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.