100+ ChatGPT Prompts for Excel That Will Make You a Spreadsheet Ninja

Learn how to use ChatGPT to make Excel easier and more productive.

ChatGPT is a powerful AI tool that can help you automate your Excel tasks, write formulas and functions, and create macros and VBA code. With ChatGPT, you can save time and effort, and focus on what's important.

In this blog post, you'll learn how to use ChatGPT to:

• Automate repetitive tasks, like data entry and formatting
• Write formulas and functions faster and more accurately
• Create macros and VBA code to automate complex tasks
• Generate reports and dashboards to visualize your data

By the end of this blog post, you'll be able to use ChatGPT to make Excel your most powerful productivity tool.

Formulas and functions Basic ChatGPT Prompts Excel

• SUM: Write a formula that calculates the sum of the values in column A.
• AVERAGE: Write a formula that calculates the average of the values in range B2:B10.
• COUNTIF: Write a formula that counts the number of cells in range C2:C10 that contain the value "Yes".
• VLOOKUP: Write a formula that retrieves the value from the table in range A1:D10 that corresponds to the value "John Doe" in cell A12.
• IF: Write a formula that returns the value "Yes" if the value in cell A1 is greater than 100, and the value "No" otherwise
• COUNTA: Write a formula that counts the number of cells in range A2:A10 that are not empty.
• MAX: Write a formula that returns the maximum value in range B2:B10.
• MIN: Write a formula that returns the minimum value in range C2:C10.
• ROUND: Write a formula that rounds the value in cell A1 to the nearest integer.
• CONCATENATE: Write a formula that combines the values in cells A1 and B1 into a single cell.
• NOW: Write a formula that returns the current date and time.
• RAND: Write a formula that returns a random number between 0 and 1.
• TEXT: Write a formula that converts a number to text.
• IFERROR: Write a formula that returns a value if the formula in the cell is not an error, and another value if it is an error.
• CHOOSE: Write a formula that returns one of a number of values, depending on the value of a variable.
• Create an excel formula to extract the text separated by commas form cell A2 to B2, C2, D2 and E2.
• Create an excel formula to compare two sheets, sheet 1 and sheet 2 and get the duplicate entries in sheet 3.

Macros and VBA ChatGPT Prompts Excel

• How do I create a macro to automate a repetitive task in Excel?
• Can you help me write a VBA function to calculate a complex formula?
• Write a VBA macro to create a new folder and save a copy of the current worksheet as a PDF.
• What is the difference between a macro and a VBA function?
• How do I debug a VBA code that is not working properly?
• Can you help me create a userform to make my Excel spreadsheet more user-friendly?

• Create an excel macro to make an "EMI calculator". 
• I need vba code for creating multiple sheets in excel form the names given in excel cell range.
• Can you help me write a macro to automatically sort my data?
• Write a VBA macro to copy data from one worksheet to another.
• Write a VBA macro to protect a specific worksheet with a password.
• Write a VBA macro to automatically sort a worksheet based on a column.
• Create a macro to insert a new row and populate it with predefined data.
• Use VBA to loop through all worksheets in a workbook and apply formatting.
• Write a macro to filter and copy data from one sheet to another based on criteria.
• Create a custom function in VBA to calculate the factorial of a number.

ChatGPT All Excel Prompt

• Use the PMT function to calculate the monthly payment for a loan.
• Use the DATEDIF function to calculate the difference between two dates in years, months, or days.
• Create a formula to convert a number into words (e.g., "123" to "One Hundred Twenty-Three").
• Create a formula to extract the middle portion of a text string.
• Use the CONCATENATE function to combine text from multiple cells.
• Write a formula to extract the domain from a URL.
• Use the IFERROR function to handle errors in a formula.
• Write a formula to calculate the total cost of items including tax.
• Calculate the average of the top 5 values in a range using the LARGE and AVERAGE functions.
• Write a formula to calculate the total duration of a list of time intervals.
• Create a formula to round a number to the nearest multiple of 5.
• Calculate the future date based on a given number of days using the TODAY and DATE functions.
• Use the CHOOSE function to select a value from a list based on an index.

Data Analysis and Visualization ChatGpt Prompt Excel

• Generate a pivot table to summarize sales data by product and region.
• Create a line chart to visualize the trend in monthly sales.
• Use conditional formatting to highlight cells containing duplicate values.
• Generate a histogram to analyze the distribution of exam scores.
• Create a scatter plot to display the relationship between two variables.

Automate repetitive tasks, like data entry and formatting

• Can you help me create conditional formatting that changes the font color of all cells in my spreadsheet that contain the value "John Doe"?
• Can you help me create conditional formatting that adds a border around all cells in my spreadsheet that are equal to zero?
• Can you help me automate the task of formatting my spreadsheet? I need to change the font, size, and color of hundreds of cells, and I'm looking for a way to do it faster.
• Can you help me automate the task of calculating the totals for each column in my spreadsheet? I need to calculate the totals for hundreds of columns, and I'm looking for a way to do it faster.
• Can you help me automate the task of creating a chart from my spreadsheet data? I need to create charts from hundreds of spreadsheets, and I'm looking for a way to do it faster.