Excel formula explanation prompt

A safe and editable data learning prompt that explains Excel formulas step by step based on your level, learning goal, and anonymous sample table context.

April 27, 2026

Ready prompt

You are a data learning assistant who explains Excel formulas in a simple, safe, and step-by-step way. Using the details below, explain what the selected Excel formula does, how it works, and how it can be used with anonymous examples.

Excel level: 
Formula I want to learn: 
Formula goal: 
Anonymous sample table context: 
Explanation style: 
Output language: 
Extra notes: 

Rules:
- Work within a general, anonymous, and safe Excel learning context.
- Do not ask for personal data, internal company tables, customer information, salary lists, financial reports, or confidential files.
- Use anonymous and simple sample table structures instead of real business data.
- Do not present the formula result as confirmed business data or a final analysis result.
- If the table structure is unclear, separate required columns as notes to review.
- Mention that the formula should be checked against the user’s Excel version, language settings, and table structure.
- Prepare the output as an Excel learning draft the user can review and adapt.

Output format:
1. Short formula summary
2. What is this formula used for?
3. Simple explanation
4. Anonymous sample table
5. Example formula
6. Explanation of formula parts
7. Step-by-step logic
8. Turkish / English function name note
9. Alternative formulas or methods
10. Common mistakes
11. Mini exercise
12. Final checklist

ChatGPT Claude Gemini

How to use this prompt

This section helps you understand when and how to use this prompt more clearly.

What is this prompt used for?

This prompt helps make Excel formulas easier to understand. It explains what the selected formula is used for, how it works, what parts it contains, and how it can be used with an anonymous sample table.

Who is it for?

It is useful for people learning Excel formulas, users working with spreadsheets, students, reporting users, people working with sales or operations data, and anyone who wants to understand formula logic in a simple way.

When should you use it?

Use it when you want to understand what an Excel formula means, learn its parts, see Turkish and English function name differences, practice with an anonymous sample table, or learn common mistakes.

Example use case

A user may want to learn the IF formula. By entering their Excel level, formula name, formula goal, and anonymous table context, they can get a formula summary, sample table, example formula, and mini exercise.

Tips for better results

Without sharing real files or sensitive data, describe the sample table context in a general way. For example, 'a sample table with product, category, quantity, and amount' is enough.

Additional usage questions

Does this prompt analyze my real business data?

No. It does not ask for real or confidential business data; it explains formula logic through an anonymous sample table.

Can this prompt explain formulas for different Excel language settings?

Yes. It can add notes for Turkish and English Excel function names; the user should still review the formula name in their own Excel version.

Preview

Example output

This example shows how the prompt can explain an Excel formula in a simple, step-by-step way using an anonymous table.

Example variables

Excel level: Beginner
Formula you want to learn: IF
Formula goal: Return a status if the sales amount is above a certain value
Anonymous sample table context: Simple sample table with product name, category, sales amount, and status columns
Explanation style: Very simple and step-by-step
Output language: English
Extra notes: Also show Turkish function name, add a mini exercise

Short formula summary

The IF formula is used to show one result if a condition is true and another result if the condition is false. In Turkish Excel, this formula is EĞER.

What is this formula used for?

For example, if a sales amount is greater than 1000, you can return 'High'; otherwise, you can return 'Normal'. This helps classify table rows automatically based on a condition.

Anonymous sample table

| Product | Category | Sales Amount | Status | |---|---|---:|---| | Product A | Accessory | 850 | | | Product B | Electronics | 1250 | | | Product C | Home | 600 | |

Example formula

=IF(C2>1000,"High","Normal") Turkish Excel equivalent: =EĞER(C2>1000;"Yüksek";"Normal")

Explanation of formula parts

C2>1000: This is the condition being checked. "High": This is the result if the condition is true. "Normal": This is the result if the condition is false.

Step-by-step logic

1. Excel checks the value in cell C2. 2. If the value is greater than 1000, it returns 'High'. 3. If the value is 1000 or lower, it returns 'Normal'. 4. If the formula is copied down, it can work for C3, C4, and the following rows.

Common mistakes

- Using semicolons or commas incorrectly depending on Excel language settings. - Forgetting quotation marks around text results. - Selecting the wrong cell reference. - Not noticing numbers stored as text.

Mini exercise

Turn this logic into a formula: If Sales Amount is greater than 500, return 'Review'; otherwise, return 'Wait'. Hint: The condition can start with C2>500.

Final checklist

- Is my Excel language setting English or Turkish? - Should I use commas or semicolons? - Is the cell reference correct? - Are text results inside quotation marks? - Does the formula update correctly when copied down?

This example is a learning draft using an anonymous table. Before applying the formula to a real file, the user should review Excel language settings, cell ranges, column structure, and data types.

Usage tips

1
Writing the formula goal clearly helps create a more accurate and understandable example.
2
Using anonymous table context instead of real business data supports a safer learning experience.
3
Because Excel function names may differ by language settings, review the formula names in your own version.
4
Before applying an example formula to your file, check column names, cell ranges, and data types.