# Unleash Your Inner Excel Pro: Master Formulas and Macros with ChatGPT

Share the Knowledge

Do you often find yourself scratching your head trying to remember the exact Excel formula you need?

It can be frustrating to waste time searching for solutions on Google, leaving you feeling like a beginner instead of an expert.

Well, we have a solution for you. With the help of ChatGPT, you can now take your Excel skills to the next level and become a true master in no time.

All you need to do is learn how to create effective prompts to utilize ChatGPT to its fullest potential. In this guide, we will provide you with the most useful ChatGPT prompts for Excel.

From basic functions to complex formulas, we will demonstrate how to create prompts that will always generate the right formula or macro for you. So, get ready to take your Excel expertise to the next level with the help of ChatGPT!

1. Can you explain the [formula/function] in Excel and give an example of how to use it?
2. Can you explain the [formula/function] in Excel and give an example of how to use it for a [calculation]?
3. Write me an excel formula [your question]
4. How do I perform a [calculation] in Excel?
5. How can I perform a [calculation] on [data set] in Excel?
6. Write an excel formula to find the [statistical calculation] of values in cells [cell1] through [cell2]
7. Write an excel formula to use the [function name] to [function purpose] in [cell range/text string]
8. Can you show me how to use the [formula/function] in Excel?
9. How to use [function name] in Excel to perform [specific task].
10. How can I count the number of unique values in a column in Excel?
11. How can I find the maximum value in a column in Excel?
12. Can you show me how to use the INDEX and MATCH formula in Excel to look up values in a table?
13. Write an excel formula to concatenate [cell1], [cell2], and [cell3].
14. How do I create a drop-down list in Excel?
15. Can you explain the SUM formula with the COUNTIF function and the ROW function in Excel and give an example of how to use it to calculate the cumulative average?
16. How do I sum every nth row in Excel?
17. How can I transpose data in Excel from rows to columns or from columns to rows?
18. How do I sum data based on a cell color in Excel?
19. Can you show me how to use the SUM formula with the OFFSET function in Excel to calculate the cumulative sum?
20. Can you show me how to use the AVERAGE formula with the OFFSET function and the EDATE function in Excel to calculate the moving average of the last 3 months?
21. Can you show me how to use the formula (new value – old value) / old value in Excel to calculate the percent change?
22. How can I calculate the moving average of the last N periods in Excel?
23. Can you explain the AVERAGE formula with the OFFSET function and the MOD function in Excel and give an example of how to use it to calculate the moving average of the last N periods?
24. Write me an excel formula to use the DATEVALUE and TIMEVALUE function to convert a date and time text string into a date and time serial number
25. Write an excel formula to perform a [mathematical operation] on [cell1] and [cell2].
26. Write an excel formula to round [cell1] to [x] decimal places.
27. Write an excel formula to return “Pass” if [cell1] is greater than or equal to [value], and “Fail” otherwise.
28. Write an excel formula to return [cell2] if [cell1] is greater than [value1] and less than [value2], and [cell3] otherwise.
29. Write an excel formula to return [cell2] if [cell1] is not blank, and [cell3] otherwise.
30. Write an excel formula to return the maximum value between [cell1] and [cell2].
31. Write an Excel formula to return the maximum or minimum value based on a condition.
32. Write an excel formula to return [value1] if [cell1] does not contain [text], and [value2] otherwise.
33. Write an excel formula to return [value1] if [cell1] is between [x] and [y], and [value2] otherwise.
34. Can you write an IF formula to return ‘Greater than 10’ if the value in cell [cell1] is greater than 10, otherwise return ‘Less than or equal to 10’?
35. Write an excel formula to extract the first [x] characters from [cell1].
36. Write an excel formula to replace [old text] in [cell1] with [new text].
37. Write an excel formula to find the number of characters in [cell1].
38. Write an excel formula to convert [cell1] to lowercase.
39. Write an excel formula to extract the text between [start text] and [end text] in [cell1].
40. Write an excel formula to calculate the number of days between [cell1] and [cell2].
41. Write an excel formula to add [x] days to [cell1].
42. Write an excel formula to calculate the age (in years) based on [cell1].
43. Write an excel formula to look up [value] in [range] and return the corresponding value from [column].
44. Write an excel formula to find the value in [cell1] based on the value in [cell2].
45. Write an excel formula to return the value in [cell1] if [cell2] is blank, and [cell2] otherwise.
46. Write an excel formula to [function] the [calculation type] of the values in [range].
47. Write an excel formula to return the largest value in [range1] that is also in [range2].
48. Write an excel formula to find the number of occurrences of [value] in [range].
49. Write an Excel formula to find the maximum value in a range, excluding certain values.
50. Can you write a formula to apply red fill color to cells in the range A1 to A10 if the value in the cell is less than 10?
51. Can you code a function in VBA to extract unique values from a range of cells in Excel?
52. Write an Excel formula to calculate the [function] of a set of data.
53. Write an Excel formula using the VLOOKUP function to [task] based on [criteria].
54. Write a macro to automatically [task] [data].
55. Write an Excel macro to [task] by [method].
56. Write an Excel macro to apply formatting, such as bold or italic, to a range of cells based on a specific condition.
57. Can you help me find the sum of column A where column B contains the word “ChatGPT” and column C is today’s date in Excel?
58. Write an Excel formula to [task] in column A based on [criteria] in columns B and C.
59. Write a VLOOKUP formula to find the salary of an employee based on their name in cells A1 to C10, where column A contains names, column B contains IDs, and column C contains salaries.
60. How do I extract the first 3 characters from the value in cell A1 using the LEFT function?
61. Write a formula to extract the names of all employees whose salary is greater than \$50,000 in cells A1 to C10, where column A contains names, column B contains IDs, and column C contains salaries.
62. Write a formula to look up the value for “apple” based on the criteria “fruit type” in cells A1 to B10.
63. Code a formula to calculate the total sales of a company based on the data in columns A to D.
64. Code a solution to automatically sort the data in column A whenever data is entered into column B.
65. How to code a macro in Excel to format cells based on their values, for example, to highlight cells with values greater than 100.

Share the Knowledge

### 1 thought on “Unleash Your Inner Excel Pro: Master Formulas and Macros with ChatGPT”

1. dileepa

Write an excel formula to replace [old text] in [cell1] with [new text].

Scroll to Top