Create unique function with ChatGPT

Search and store tool for Chat GPT Prompt

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

Creating Custom Export Functions with the Google Sheets Script Editor

How do I use the Google Sheets Script editor to create custom export functions?

google sheets script editor custom export functions

Create a Custom Import Function with Google Sheets Script Editor

How do I use the Google Sheets Script editor to create custom import functions?

google sheets script editor custom import function

How to Use the Google Sheets CLEAN Function to Remove Unwanted Characters from Data in a Sheet

How do I use the Google Sheets CLEAN function to remove unwanted characters from data in a sheet?

google sheets clean function data unwanted characters

How to Use the Google Sheets CONCATENATE Function to Join Data From Different Cells

How do I use the Google Sheets CONCATENATE function to join data from different cells?

google sheets concatenate function join data different cells

How to Use the Google Sheets JOIN Function to Combine Data from Different Columns?

How do I use the Google Sheets JOIN function to combine data from different columns?

google sheets join function data columns

How do I use the Google Sheets SPLIT function to split data into different columns?

google sheets split function data columns

Creating an Opinion About the Google Sheets TRANSPOSE Function

How do I use the Google Sheets TRANSPOSE function to flip rows and columns in a sheet?

google sheets transpose function rows columns sheet

Creating Links with Google Sheets HYPERLINK Function

How do I use the Google Sheets HYPERLINK function to create links to other sheets or websites?

google sheets hyperlink function links sheets websites

Understanding the Google Sheets IMPORTRANGE Function

How do I use the Google Sheets IMPORTRANGE function to import data from other sheets?

google sheets importrange function import data other sheets

How to Use the Google Sheets IMPORTXML Function to Import Data from the Web

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

google sheets importxml function import data web

Creating Custom Functions with Google Sheets Script Editor

How do I use the Google Sheets Script editor to create custom functions?

google sheets script editor custom functions

How to Use the Google Sheets Query Function to Filter and Sort Data

How do I use the Google Sheets Query function to filter and sort data?

google sheets query function filter sort data

How to Use Dynamic Reference Functions in Google Sheets

How do I use the dynamic reference functions in Google Sheets (e.g., INDIRECT, OFFSET)?

google sheets indirect offset dynamic reference functions

How to Use Lookup Functions in Google Sheets (e.g. VLOOKUP, HLOOKUP, INDEX, MATCH)

How do I use the lookup functions in Google Sheets (e.g., VLOOKUP, HLOOKUP, INDEX, MATCH)?

google sheets lookup functions vlookup hlookup index match

Using Nested Functions in Google Sheets: Exploring IF, SUM, COUNTIF, and SUMIFS

How do I use the nested functions in Google Sheets (e.g., IF inside SUM, COUNTIF inside SUMIFS)?

google sheets nested functions if sum countif sumifs

Understanding Date and Time Functions in Google Sheets

How do I use the date and time functions in Google Sheets (e.g., NOW, TODAY, YEAR, MONTH, DAY)?

google sheets date and time functions now today year month day

Using Text Functions in Google Sheets

How do I use the text functions in Google Sheets (e.g., UPPER, LOWER, PROPER, CONCATENATE)?

google sheets text functions upper lower proper concatenate

How to Use INDEX and MATCH Functions in Google Sheets

How do I use the INDEX and MATCH functions to find the value in a specific cell in Google Sheets?

google sheets index and match functions value specific cell

Using IF, AND, and OR Functions Together in Google Sheets

How do I use the IF, AND, and OR functions together in Google Sheets?

google sheets if and or functions

How to Use the CONCATENATE Function to Combine Text in Google Sheets?

How do I use the CONCATENATE function to combine text in Google Sheets?

google sheets concatenate function combine text

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.