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.

Generating an Opinion about Excel Commands to Use SUMIF, IF and ROUND Functions Together

Write me an excel command to use the SUMIF, IF and the ROUND function together to sum the values of cells based on a specific condition and round the result to a specific decimal place

Using ChatGPT to Easily Combine VLOOKUP and INDEX Functions in Excel for Quick Data Retrieval

Write me an excel command to use the VLOOKUP and INDEX function together to lookup values in a table and retrieve a corresponding value from a different column

Generate an Opinion about Using INDEX, MATCH and INDIRECT Functions Together to Create a Dynamic Named Range in Excel

Write me an excel command to use the INDEX, MATCH and the INDIRECT function together to create a dynamic named range and use it in a formula

Generating an Opinion about Excel Commands Using INDEX, MATCH, ARRAY FORMULA and SUM Functions

Write me an excel command to use the INDEX and MATCH functions together with the Array Formula and the SUM function to perform a sumifs like functionality

Creating an Excel Command to Use IF, AND, and OR Functions Together

Write me an excel command to use the IF, AND and OR function together to create a formula that tests multiple conditions and returns a specific result based on those conditions

Create an Opinion About Using SUMPRODUCT, INDEX and MATCH Functions Together in Excel

Write me an excel command to use the SUMPRODUCT, INDEX and MATCH functions together to retrieve data from a table and perform calculations based on multiple criteria

Use SUMIFS and COUNTIFS Functions to Analyze Data and Return a Percentage Result

Write me an excel command to use the SUMIFS and COUNTIFS functions together to analyze data based on multiple criteria and return a result as a percentage

Creating an Opinion About Excel Command to Split a Column into 2 or More Columns

Excel command to split a column into 2 or more columns

Formula to Multiply the Value in Cell A1 by 10, Add the Result by 5, and Divide it by 2

Write the formula for the following? – Multiply the value in cell A1 by 10, add the result by 5, and divide it by 2

Generating an Opinion about Excel Commands to Use INDEX, MATCH and ROWS Function Together to Find Last Row of Data in Sheet

Write me an excel command to use the INDEX, MATCH and ROWS function together to find the last row of data in a sheet

Create an Opinion about Using the INDEX and MATCH Function in Excel

Write me an excel command to use the INDEX and MATCH function together with the INDEX and MATCH function to create a multi-dimensional lookup

Create an Opinion About the Excel Command to Use INDEX and MATCH with INDEX

Write me an excel command to use the INDEX and MATCH function together with the INDEX function to create a two-way lookup

Write an Excel Command to Use the INDEX and AGGREGATE Function Together

Write me an excel command to use the INDEX and AGGREGATE function together to return the k-th smallest or largest value in a range

Create an Opinion about the Excel Command to Use INDEX and MATCH Function with Array Formula to Extract Unique Values

Write me an excel command to use the INDEX and MATCH function together with the Array Formula to extract unique values

Create an Opinion About the Input Provided Using IF and AND Functions in Excel

Write me an excel command to use the IF and AND function together to create a formula that test multiple conditions in a single formula

Generating an Opinion on Excel Command Using INDEX, MATCH and Match_Type Parameter

Write me an excel command to use the INDEX, MATCH and match_type parameter to perform approximate match lookups

Using the IF and IFERROR Functions in Excel to Handle Errors and Return a Specific Value or Text

Write me an excel command to use the IF and IFERROR function together to handle errors and return a specific value or text

Understanding Excel Commands for Rounding Numbers

Write me an excel command to use the ROUNDUP, CEILING and FLOOR functions to round numbers to the nearest specified multiple of significance

Generating an Opinion on Excel's DATEVALUE and TIMEVALUE Functions

Write me an excel command to use the DATEVALUE and TIMEVALUE function to convert a date and time text string into a date and time serial number

Generate an Opinion about Using CONCATENATE, LEFT, and RIGHT Functions Together to Create a Formula

Write me an excel command to use the CONCATENATE, LEFT, and RIGHT function together to create a formula that extract a specific part of a text string

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.