Create unique Functions with ChatGPT
Search and store tool for Chat GPT Prompt
Create unique and innovative Functions with ChatGPT, a powerful pre-trained language model by OpenAI that can generate high-quality and accurate content. Our tool can help you develop the most effective Functions that align with your goals and objectives. With ChatGPT's assistance, you can optimize your Functions to meet the needs of your target audience, minimize complexity and maximize efficiency. Let ChatGPT take the guesswork out of Functions development and help you achieve superior results!
15 Innovative ChatGPT Prompts: Automate Your Excel Tasks
<div data-block-id="d7b717e8-d6a4-49c3-a9de-9b64b06605a4" class="notion-selectable notion-sub_sub_header-block" style="width: 100%; max-width: 1398px; margin-top: 1em; margin-bottom: 1px;"><div style="display: flex; width: 100%; color: inherit; fill: inherit;"><h4 spellcheck="true" placeholder="Heading 3" data-content-editable-leaf="true" contenteditable="false" style="max-width: 100%; width: 100%...
How to Use Date and Time Functions to Insert the Current Date and Time into a Cell
How to use the DATE and TIME functions to insert the current date and time into a cell
Optimizing Python Code: Rewriting Functions with Python Conventions
Rewrite this function following python conventions {enter function}
Generating an Opinion about the Use of Excel Functions SUMIF, IF and LEN
Write me an excel command to use the SUMIF, IF and the LEN function together to sum the values of cells based on a specific condition and the length of a text in another cell
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
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
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 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
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
Using COUNTIF and COUNTIFS Functions to Count Cells That Meet Specific Criteria
How to use the COUNTIF and COUNTIFS functions to count cells that meet specific 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
Using Google Sheets Text Functions to Clean and Format Data in a Sheet
How do I use the Google Sheets Text functions (e.g., UPPER, LOWER, PROPER, CONCATENATE) to clean and format data in a sheet?
Creating Custom Reporting Functions with the Google Sheets Script Editor
How do I use the Google Sheets Script editor to create custom reporting functions?
Creating Custom Validation Functions with Google Sheets Script Editor
How do I use the Google Sheets Script editor to create custom validation functions?
Creating Custom Export Functions with the Google Sheets Script Editor
How do I use the Google Sheets Script editor to create custom export functions?
Creating Custom Functions with Google Sheets Script Editor
How do I use the Google Sheets Script editor to create custom functions?
How to Use Dynamic Reference Functions in Google Sheets
How do I use the dynamic reference functions in Google Sheets (e.g., INDIRECT, OFFSET)?
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)?
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)?
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.