Create unique Cell with ChatGPT

Search and store tool for Chat GPT Prompt

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

Using the INDEX, MATCH, and INDIRECT Functions together to Create a Dynamic Cell Reference

Write me an excel command to use the INDEX, MATCH and INDIRECT functions together to create a dynamic cell reference

excel index match indirect dynamic cell reference

How to Create an Excel Command to Restrict Copying a Cell from a Worksheet

Write me an excel command to restrict someone from copying a cell from your worksheet?

excel command restrict copying cell worksheet

Creating a VBA Excel Macro to Generate a PDF from Cell C2

Write a VBA Excel macro that looks at the value in cell C2 and finds the worksheet with the exact name Then create a PDF and save it to the same file location the Excel file is saved in

vba excel macro pdf cell c2

Generating an Opinion About the Content of the SUBSTITUTE Function in Excel

Write me an excel command to use the SUBSTITUTE function to replace specific text in a cell with new text

excel substitute function text cell replace

Using the CONCATENATE Function to Join Text from Multiple Cells into One Cell

Write me an excel command to use the CONCATENATE function to join text from multiple cells into one cell

excel concatenate function text cells join

Creating an Opinion about the Excel MIN Function

Write me an excel command to use the MIN function to find the lowest value in a range of cells

excel min function lowest value range of cells

Generating an Opinion about the Content of an Excel Command for the MAX Function

Write me an excel command to use the MAX function to find the highest value in a range of cells

excel max function range cells

Generate an Opinion about the Excel AVERAGE Function

Write me an excel command to use the AVERAGE function to calculate the average of a range of cells

excel average function calculate average range cells

Generating an Opinion about the SUM Function in Excel

Write me an excel command to use the SUM function to add up a range of cells

excel sum function range of cells

Explaining How to Use the NOT Function to Reverse the Logical Value of a Cell

How to use the NOT function to reverse the logical value of a cell

not function logical value cell

How to Use the SUBSTITUTE Function to Replace Specific Text in a Cell with New Text

How to use the SUBSTITUTE function to replace specific text in a cell with new text

substitute function replace specific text cell new text

Finding the MAX and MIN Values in a Range of Cells Using MAX and MIN Functions

How to use the MAX and MIN functions to find the largest and smallest values in a range of cells

max min functions range cells

Understanding How to Use AVERAGEIF and AVERAGEIFS Functions to Calculate Average of Cells Meeting Specific Criteria

How to use the AVERAGEIF and AVERAGEIFS functions to calculate the average of cells that meet specific criteria

averageif averageifs calculate average cells criteria

Summing Cells with the SUMIF and SUMIFS Functions in Excel

How to use the SUMIF and SUMIFS functions to sum cells that meet specific criteria

excel sumif sumifs functions cells criteria

Understanding Google Sheets Data Protection Feature to Track Changes in Protected Cells

How do I use the Google Sheets Data protection feature to track changes made to protected cells?

google sheets data protection track changes protected cells

How to Use Google Sheets Data Protection Feature to Allow Certain Users to Edit Protected Cells

How do I use the Google Sheets Data protection feature to allow certain users to edit protected cells?

google sheets data protection editing protected cells

Understanding Google Sheets Data Protection and Conditional Formatting for Protected Cells

How do I use the Google Sheets Data protection feature to set conditional formatting rules for protected cells?

google sheets data protection conditional formatting protected cells

Using Google Sheets Data Protection Feature to Protect Cells from Editing

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

google sheets data protection protect cells editing

Using Google Sheets Data Validation Feature to Apply Validation to Multiple Cells

How do I use the Google Sheets Data validation feature to apply validation to multiple cells?

google sheets data validation validation multiple cells

Using Google Sheets Custom Cell Formatting to Format Data

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

google sheets cell formatting data formatting

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.