Create unique Excel command with ChatGPT

Search and store tool for Chat GPT Prompt

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

Using ChatGPT to Count Cells with Data in Excel: A Step-by-Step Guide

Write me an excel command to use the COUNT function to count the number of cells with data in a range

excel command count function cells data range

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

excel command if and or function formula conditions result

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

excel command index match match_type approximate lookups

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

excel command concatenate left right formula text string extract

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

excel command index match offset dynamic named range

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

excel command countifs sumifs analyze data multiple criteria

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

Generate an Opinion about an Excel Command

Write me an excel command [your question]

excel command opinion

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

excel command pivot table data analysis summarize

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

excel command and or functions logical tests formula

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

excel command abs function absolute value number

How to Use the ROUND and ROUNDUP Functions in Excel to Round Numbers to a Specific Number of Decimal Places

Write me an excel command to use the ROUND and ROUNDUP functions to round numbers to a specific number of decimal places

excel command round roundup round numbers decimal places

Generating an Opinion About the Use of LEFT, RIGHT, and MID Functions to Extract Characters from a Text String

Write me an excel command to use the LEFT, RIGHT, and MID functions to extract specific characters from a text string

left right mid excel command text string extract characters

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.