Start using Excel smart with 7 useful prompts for ChatGPT. Make data-driven decisions and unlock Excel's full potential.
Excel
What steps should I use for IF function in Excel to perform logical tests and return specific results?
What steps should I use for VLOOKUP function in Excel to retrieve data from a table based on a lookup value?
What steps should I use for CONCATENATE function in Excel to combine text from multiple cells into one cell?
What steps should I use for SUBSTITUTE function in Excel to replace specific text in a cell with new text?
What steps should I use for function in Excel to find the remainder of a division operation?
What steps should I follow to use the AND and OR functions in Excel to perform multiple logical tests in a single formula?
What is the Excel command for LEN function to count the number of characters in a text string?
Writing efficient prompts for ChatGPT can definitely be a bit of an art form, but with a little practice, you'll be a pro in no time.
One of the most important things to keep in mind is the more information you can give the AI about the topic or situation you want it to respond to, the better. For example, instead of writing ‘What are some good marketing tactics for my business?‘, you could write ‘What are some effective marketing tactics for a small B2B software company targeting CIOs and IT directors that can be implemented in the next 3 months?‘.
Secondly, you can try telling the AI to assume an identity or profession to help guide its responses. For example, if you're asking the AI to provide advice on a legal matter, you could tell it to assume the role of a lawyer. This can help ensure that the AI's responses are tailored to your specific needs.
Also, do not forget to write your prompts in a conversational tone. Pretend like you're talking to a friend or colleague, and try to phrase your questions in a way that feels natural and easy to understand.
7 Best Excel ChatGPT Prompts - Cheatsheet