Lesson 4 · Premium

Write and fix a spreadsheet formula

Get AI to write a lookup or SUMIFS from a plain-English brief, then diagnose and fix a broken formula in a month-end workbook.

What you'll practice

Test the AI's fix before you trust it.

What gets checked

• Formulas return the right results on the test data
• Blank and zero rows are handled

What you need

Nothing to prepare. The source files come with the lesson.