Skip to content
Close portrait of Suriani in her mustard cardigan

@suriani.sheetsA new lesson every Tuesday

Suriani Yusof

I explain spreadsheet formulas the way a carousel reads: one idea per slide, four or five slides a lesson, nothing you have to scroll back for.

Lesson 1 · Lookups in four slides4 slides

  1. Slide 1 of 4LookupsFind it, don't scroll.
  2. Slide 2 of 4LookupsName the table first.
  3. Slide 3 of 4LookupsMatch the exact value.=XLOOKUP(A2, Item, Cost)
  4. Slide 4 of 4Save thisWrap it in a check.IFERROR shows a blank instead of #N/A.

Swipe the lesson

Lessons

One idea per slide, every Tuesday

Each lesson is a short carousel. Read it here, then swipe the full one on Instagram or LinkedIn, where you can save it.

Lesson 2

Why your SUM is off by one

The three most common range mistakes and how to spot them.

5 slidesSwipe the lesson
  1. Slide 1 of 5Why your SUM is off.Ranges →
  2. Slide 2 of 5Count the cells.
  3. Slide 3 of 5Hidden rows still count.
  4. Slide 4 of 5Text is not a number.
  5. Slide 5 of 5Lock the range.$B$2:$B$9
Lesson 3

IF, then AND, then OR

Build a decision in a cell, one condition at a time.

4 slidesSwipe the lesson
  1. Slide 1 of 4One question, two answers.=IF(test, yes, no)
  2. Slide 2 of 4Add a second condition.AND(a, b)
  3. Slide 3 of 4Both, or either.
  4. Slide 4 of 4Nest only twice.After two IFs, reach for IFS instead.
Printed template pack fanned out on a wooden desk

Free, for your email

The Formula Starter Sheet

My free one-page sheet of the twelve formulas I use every week, sent when you sign up. Print it and keep it beside the keyboard.

  • Sums and counts

  • Lookups

  • If and logic

  • Dates and text

You'll also get the Tuesday lesson. Leave whenever you like.

Downloads and merch

Shop

Downloads arrive by email. Merch is printed to order and shipped to you.

Suriani standing by a desk holding a printed sheet

About

Hello, I’m Suriani

I spent twelve years as a finance analyst in Singapore, and most of that time I was the person people came to when a spreadsheet stopped adding up. The fix was almost always one small idea, explained at the right moment.

So now I explain one idea per slide. A new lesson goes up every Tuesday, I make template packs for the sheets people ask me for most, and I run small workshops for adult teams who want to stop copying numbers by hand.

Workshops

A workshop for your team

Small hands-on sessions for adult teams and groups of up to twelve, in Singapore or online. We work on your own kind of sheets, one idea at a time. Tell me what your team does and I'll reply within a week.

  • A workshop for your team

    Groups of up to twelve, in Singapore or online, on your own kind of sheets.