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.

Create an Opinion about Using the INDEX, MATCH and Offset Functions to Create a Dynamic Named Range

Write me an excel command to use the INDEX, MATCH and Offset functions to create a dynamic named range

Create an Opinion on Excel Formulas Using VLOOKUP, INDEX and MATCH Functions Together

Write me an excel command to use the VLOOKUP, INDEX and MATCH functions together to create a robust data lookup formula

Creating an Excel Formula Using IF and SUMIF Functions

Write me an excel command to use the IF and SUMIF function together to create a formula that sums the values of cells based on a specific condition

Create an Opinion About Using COUNTIFS and SUMIFS Functions Together to Analyze Data Based on Multiple Criteria

Write me an excel command to use the COUNTIFS and SUMIFS functions together to analyze data based on multiple criteria

Generate an Opinion about the SUMPRODUCT Function in Excel

Write me an excel command to use the SUMPRODUCT function to multiply corresponding ranges or arrays and then return the sum of products

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

Writing an Opinion about the HLOOKUP Function in Excel

Write me an excel command to use the HLOOKUP function to retrieve data from a table based on a horizontal lookup value

Generating an Opinion on the Content of Input

Sum of column A when column B contains the word marketing and column C is today's date

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?

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

Troubleshooting Data Validation on Cells with Formulas in Excel

I've been trying to use data validation on cells that have formulas in them But it seems like it doesn't work even on the latest excel versions? For example, cell A2 contains formula =B2+C2 If i set the validation on cell A2 saying that the sum shouldn't be greater than 10, any number could still be put into cells B2 and C2,

Generate an Opinion about an Excel Command

Write me an excel command [your question]

Generating an Opinion about the Content of an Excel Command for Pivot Tables

Write me an excel command to use the Pivot Table to summarize and analyze large amounts of data

Generate an Opinion About Excel INDEX and MATCH Functions

Write me an excel command to use the INDEX and MATCH functions to perform advanced lookups

Creating an Opinion about the Excel IFERROR Function

Write me an excel command to use the IFERROR function to handle errors in a formula and return a specific value instead

Generating an Opinion about the Excel NOT Function

Write me an excel command to use the NOT function to reverse the logical value of a cell

Generating an Opinion About the Content of an Excel Command Using AND and OR Functions

Write me an excel command to use the AND and OR functions to perform multiple logical tests in a single formula

Create an Opinion About the Content of the Input Using the PI Function in Excel

Write me an excel command to use the PI function to insert the value of pi into a cell

Generating an Opinion about an Excel Command to Use the ABS Function to Find the Absolute Value of a Number

Write me an excel command to use the ABS function to find the absolute value of a number

Writing an Excel Command to Use the MOD Function to Find the Remainder of a Division Operation

Write me an excel command to use the MOD function to find the remainder of a division operation

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.


What is prompt engineering

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.


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.
play background gpt3

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.