Excel formula learning prompt
An editable learning prompt that explains Excel formulas based on the user’s level, with sample table scenarios and practice exercises.
Prompt template
Guides
An editable learning prompt that explains Excel formulas based on the user’s level, with sample table scenarios and practice exercises.
Models
Use panel
0/6 filled
You are a spreadsheet and data tutor who explains Excel formulas in a simple, clear, and step-by-step way. Using the details below, create an editable Excel formula learning session with examples and practice tasks suitable for the user’s level. Excel level: Formula topic to learn: Learning goal: Sample table context: Explanation style: Practice depth: Rules: - Work in a general and educational Excel learning context. - Simplify the topic based on the user’s level and explain it step by step. - Keep examples small, clear, and easy for the user to adapt. - Mark any missing table headers, cell ranges, or file structure as assumptions. - Add a review note that formula names and separators may change depending on Excel language or regional settings. - Prepare the output as an editable learning draft the user can adapt to their own spreadsheet. Output format: 1. Short learning goal summary 2. Simple explanation of the formula topic 3. Sample table structure 4. Basic formula logic 5. Step-by-step usage explanation 6. 5 example formulas 7. Short explanation of what each formula does 8. Mini practice tasks 9. Common points of confusion 10. Notes for adapting the formulas to the user’s own table 11. Short review plan 12. Final checklist
This section helps you understand when and how to use this prompt more clearly.
This prompt helps users learn Excel formulas by turning a formula topic into a structured learning draft with formula logic, sample table structure, step-by-step explanations, and practice exercises.
It is useful for Excel beginners, users who want to apply basic formulas in work files, students practicing spreadsheets, employees preparing reports, and anyone who wants to understand formulas through examples.
Use it when you want to learn what an Excel formula does, create sample formulas for your own table, understand formula logic in simple language, or practice with short exercises.
A user may want to calculate total sales, count rows by category, or track stock values in a product table. This prompt can create a sample table, formula explanations, and practice questions based on the user’s level.
Instead of entering only the formula name, include the table context. For example, writing 'I want to learn COUNTIF for counting students who passed in a grade table' creates a clearer output than writing only 'COUNTIF'.
Can this prompt explain formulas using English Excel names?
Yes. If you write the formula topic using English formula names, it can prepare the explanation with those names.
Will the cell ranges match my spreadsheet exactly?
If the user provides table headers and sample ranges, the draft can be more aligned. Cell ranges should still be reviewed against the actual file structure before use.
This example shows how the prompt can create an Excel formula learning session with explanations, sample formulas, and practice tasks.
The goal of this practice is to understand basic Excel formulas for calculating total expenses and counting rows that match a selected category.
Column A: Date Column B: Category Column C: Amount Sample range: A2:C20 This range is only an example and can be adjusted based on the user’s own spreadsheet.
SUM adds the numbers in a selected cell range. COUNTIF counts cells that match a condition. These formulas are useful for creating quick summaries in simple expense tracking tables.
1. =SUM(C2:C20) → Adds all values in the Amount column. 2. =AVERAGE(C2:C20) → Calculates the average amount. 3. =COUNTIF(B2:B20,E2) → Counts rows where the category matches the value in E2. 4. =MAX(C2:C20) → Shows the highest amount. 5. =MIN(C2:C20) → Shows the lowest amount.
This example is an editable draft for learning Excel formulas. Cell ranges, table headers, and formula separators should be reviewed based on the user’s own spreadsheet.
Writing the formula topic clearly helps keep the explanation focused.
Adding a sample table context makes the formula examples closer to real use.
Stating your Excel level helps prevent the explanation from becoming too technical or too basic.
Before using the output, compare the sample cell ranges with the columns and rows in your own spreadsheet.
Yes. If the level is set to beginner or basic, it can explain formulas with simpler examples.
Yes. If you provide the table context, column names, and learning goal, it can create more relevant formula examples.
Yes. Many basic formula concepts may be similar, but formula names and separators should be reviewed based on the tool used.
No. It can also prepare formula logic, sample tables, practice tasks, adaptation notes, and a short review plan.
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 that adds all values in column C. 2. Count how many times a selected category appears in column B. 3. Find the highest expense amount. 4. Calculate the average expense amount. 5. Adapt the sample ranges to your own table.
The ranges C2:C20 and B2:B20 are examples. If your data is located in different rows or columns, update the ranges based on your table structure. Formula names and separators may vary depending on Excel language and regional settings.
Is the formula looking at the correct column? Does the cell range include all needed rows? Does the category name match the table value? Are the formula separators compatible with your Excel settings? Does the result look reasonable based on the sample values?