Practice Essential Excel Formulas
Learn SUMIFS, XLOOKUP, and IFERROR through guided practice using a retail example. Work through one problem at a time, get feedback on your formulas, and finish with a combined challenge
Prompt template
- Format
- Text Parameterized
- Inputs
- Excel_version (text) · Required Industry (text) · Optional · Default: retail
- Outputs
- Guided_formula_lesson (text)
Teach me SUMIFS, XLOOKUP, and IFERROR in ${excel-version} using a ${industry:retail} example. Create sample sales and pricing tables I can paste into Excel. Give me one problem at a time and wait for my formula before showing the answer. Explain mistakes, offer hints, and finish with a challenge combining all three functions.
Replace the ${…} placeholders with your values
before using this prompt. See parameters
and defaults below
Parameters
Replace each placeholder with your own value, or use its default when one is provided
${excel-version}
excel-version
Required
${industry:retail}
industry
Default: retail
What you'll create
This prompt creates a guided Excel lesson with sample sales and pricing tables and exercises on SUMIFS, XLOOKUP, and IFERROR. It ends with a challenge that combines all three functions
Usage instructions
Frequently asked questions
Can I change the example industry?
Yes. Replace the retail example with another industry that fits your practice needs
What happens if I enter an incorrect formula?
The tutor should explain the mistake, offer a hint, and wait for your next attempt
Comments
Tried this prompt? Share what you made, compare results, or ask a question