AI for data and spreadsheets

Explain this spreadsheet formula to a beginner, step by step, in plain language: [paste formula]. Say what each part does, what kind of data it expects, and give a small example with made-up numbers. Then tell me two ways it could go wrong.

I use [spreadsheet program]. My data has these columns: [list column letters and what they hold]. I want [describe the result in plain words, for example the total of column C where column B says Paid]. Write the formula, explain it in one sentence, and tell me where to type it.

Here are the first rows of my data with private details removed: [paste a small sample]. List the problems you can see, such as inconsistent spellings, extra spaces, mixed date formats, blank cells and duplicates. For each problem, suggest a way to fix it in a spreadsheet. Do not change any data yet.

In my spreadsheet, column [letter] holds [describe, for example customer names typed in many ways]. I want them consistent as [describe the format]. Give me step-by-step instructions or a formula for [spreadsheet program]. Show a before and after example using made-up values.

My data has these columns: [list columns]. I want to know [your question, for example total sales by region and month]. Tell me how to build a pivot-style summary table in [spreadsheet program], including which column goes in rows, columns and values. Say how I can check that the totals add up.

I want to show [what you want the reader to understand] to [audience]. My data is [describe it briefly]. Recommend the chart type that fits best, explain why in two sentences, name one chart that would mislead, and suggest a clear title and axis labels.

I will give you a small CSV with private details removed. First, tell me what columns you see and what each seems to mean. Then answer this question: [your question]. Show how you calculated the answer, and list any rows you were unsure about. Data: [paste or attach]

You gave me this answer: [paste answer]. Show your work step by step so I can check it by hand. Then give me a different method to reach the same number, such as a spreadsheet formula I can run myself. Tell me if the two methods disagree.