The most popular app in every industry is Excel. We frequently have trouble recalling intricate Excel calculations. That makes us less productive.
Therefore, we will master 3 different ChatGPT commands today, which will help us 10X our Excel sheet productivity.
Type 1 - How to command
In case you want to ask something, we go on Google and type how to …., similarly you can ask “How to …" from ChatGPT AI.
On Google, you will get many links, and then you must open the link and find the right link for your question. But on ChatGPT, you will get direct answers which you can use for your purpose.
Example -
How to use the MAX and MIN functions to find the largest and smallest values in a range of cells
Output -
Type 2 – Write the command
You can ask ChatGPT to write a command for a specific scenario, for example -
Write me an Excel command to use the COUNT function to count the number of cells with data in a range
Output -
Type 3 - Act as Command
ChatGPT is a text-based AI tool, so you can command ChatGPT to as an English teacher, Act as Excel, and Act as Heath Coach.
For Example -
I want you to act as a text-based excel; you’ll only reply to me with the text-based 10 rows Excel sheet with row numbers and cell letters as columns (A to L); the first column header should be empty to reference row numbers, I will tell you what to write into cells and you’ll reply only the result of excel table as text, and nothing else, Do not write explanations, I will write you formulas, and you’ll execute formulas, and you’ll only reply the result of excel table as text, First, reply me the empty sheet
Output – ChatGPT will act like Excel
This is how you can get the maximum out of ChatGPT. And improve your productivity in Excel Sheet.
Conclusion
Today we learned 3 commands type for ChatGPT to improve your Excel skills. -
- How to
- Act as
- Write me