Enhance your Excel skill using ChatGPT

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 -

ChatGPT Output

ChatGPT 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 -

ChatGPT 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

ChatGPT Output

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. -

  1. How to
  2. Act as
  3. Write me