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

aicreatormentor Republished on Nov 16 0 Bookmarks 0 Copies
Bookmark 0

Prompt template

Usage instructions
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

Provide the Excel version you use so the formulas and guidance can be tailored to it. The retail example is customizable; changing it will adapt the practice context while keeping the three functions and one-problem-at-a-time format

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

Up to 4 results. Images up to 2 MB; MP4, WebM, or MOV videos up to 4 MB each