Excel formula learning and sample table prompt
A prompt for learning Excel formulas with sample tables, understanding cell references, and improving lookup, sum, condition, and report logic.
A prompt for learning Excel formulas with sample tables, understanding cell references, and improving lookup, sum, condition, and report logic.
Models
Use panel
0/6 filled
You are a data learning instructor who teaches Excel formulas in a simple, clear, and step-by-step way. Using the general details below, create an Excel formula learning draft with a sample table, sample formula, explanation, exercises, and checklist suitable for the user’s level. Excel level: Formula or topic to learn: Learning goal: Sample table context: Explanation style: Practice depth: Rules: - Work with a general and educational Excel learning context. - Create a sample table with simple, clear, and anonymous fields. - Present formulas as reviewable learning examples. - Add a review note that formula names or separators may differ depending on Excel version and language settings. - Explain cell references, formula parts, and expected result logic. - Mark unclear table fields as assumptions. - Prepare the output as an editable draft the user can adapt to their own workbook. Output format: 1. Short learning goal summary 2. Basic logic of the formula 3. Sample table structure 4. Sample data rows 5. Sample formula 6. Part-by-part formula explanation 7. Expected result logic 8. Alternative formula or method 9. Common formula mistakes 10. Mini exercises 11. Mini quiz 12. 7-day Excel formula learning plan 13. Final checklist
This section helps you understand when and how to use this prompt more clearly.
This prompt creates formula explanations, sample data, expected result logic, and exercises for users learning Excel formulas through sample tables.
It is useful for Excel beginners, users who mix up formulas, and learners who want to understand lookup and conditional calculation logic.
It can be used when learning formulas such as SUM, IF, VLOOKUP, XLOOKUP, SUMIF, COUNTIF, or FILTER.
A user may want to learn how to return a price based on a product code. This prompt can create a sample table, formula, explanation, and exercises.
Instead of writing only 'explain an Excel formula', a clearer goal such as 'explain XLOOKUP with a sample table to return price by product code' creates a better result.
Can this prompt explain an Excel formula part by part?
Yes. It can explain each formula part and what cell references mean.
Can this prompt work with sample data?
Yes. It can create a small sample data table based on the topic.
This example shows how the prompt can create a sample table, formula explanation, and exercises for learning Excel formulas.
The goal is to learn XLOOKUP logic for finding a product price based on a product code.
Column A: Product Code Column B: Product Name Column C: Price
=XLOOKUP(E2,A:A,C:C,"Not found")
E2 contains the product code to search for. A:A is the lookup range. C:C is the result range with prices. Not found is the text shown if there is no match.
This example is for Excel learning. The user can check formula syntax based on Excel version and language settings.
Writing the formula clearly helps the explanation focus directly on the user’s need.
Providing a sample table context makes the real use of the formula easier to understand.
Asking for cell-by-cell explanation can make formula logic clearer for beginners.
The formula should be tested in the user’s own Excel version to check separators and function names.
Yes. If beginner level is selected, it explains formula logic with simple table examples.
Yes. It can teach lookup formulas with sample tables, formula explanations, and exercises.
Yes. It can create a small and clear sample table structure based on the topic.
Yes. It can prepare exercises, quizzes, and a 7-day learning plan based on the formula topic.
Prompts are for illustration only. Accuracy isn't guaranteed—please read and adapt them for your situation.
This prompt is for general purposes. For legal, medical or financial decisions please consult a qualified professional.
1. Write a formula to return price by product name. 2. Return product name by product code. 3. Show a different message if there is no match. 4. Change the lookup cell and test the result.