Excel · Power BI · automation

Excel formulas and models that don't break after a week

A good formula is short, readable and survives new rows. I turn nested IFs and manual fixes into models the whole team understands.

I'll review it for free and tell you how much time you can win back.

  • Excel world vice-champion, MOS 2026
  • 6 MOS certificates, incl. 4 Excel Expert
  • Szczecin and remote across Poland

When formulas are the problem

  • A formula runs to several lines and nobody dares to touch it.
  • Once rows are added, some results stop calculating.
  • The quote calculator only works when one particular person fills it in.

What I do

  1. Modern functions

    XLOOKUP, FILTER, UNIQUE and dynamic arrays instead of fragile workarounds.

  2. Readable names

    LET and named ranges, so a formula says what it calculates.

  3. Calculators and quotes

    Input fields, data validation and locked calculations.

  4. Forecasts

    Scenario models where you change an assumption and see the result.

How I price it

  1. 01

    A free review

    You send the file or describe how the report gets made today. I tell you what can be automated.

  2. 02

    A fixed price up front

    You get a quote for the whole scope and a deadline before we start. No billing every hour.

  3. 03

    You see the payback

    With the quote I work out how many hours a year you win back, so you know whether it pays off.

Where I work

I work remotely with businesses across Poland: on a shared file and short online calls, with no USB sticks in the post. On-site meetings are possible in Szczecin, Goleniów and the rest of West Pomerania, and in Warsaw.

Common questions

Will the new functions work in my Excel?

Dynamic arrays, XLOOKUP and LET are in Microsoft 365 and Excel 2021 or later. For older versions I choose compatible solutions.

Can you just fix an existing sheet?

Yes, often the fastest route is to tidy up what already works rather than rebuild it.

Will you explain how it works?

Yes, I document every larger formula in the sheet so the team can extend it themselves.

Got a spreadsheet that eats your time?

Send it over or describe what you do every month. I reply within a day.

Show me your file