XXLFormula AI
Blog

Spreadsheet ideas, tutorials & updates

The XLFormula AI blog is where we go deeper than a reference guide. Expect long-form tutorials that walk through real spreadsheet problems from start to finish, deep dives on how functions like LAMBDA, LET, and QUERY actually work under the hood, honest product updates as we ship new features, and case studies from teams using XLFormula AI to save real hours every week.

Our editorial focus is practical over theoretical. Posts are written for people who open a spreadsheet every day and want to leave a little faster than they arrived — analysts, operators, finance leads, founders, students. We publish opinions when we hold them (VLOOKUP is legacy; dynamic arrays are the default; most macros should be formulas) and back them with worked examples you can paste into your own sheet. If you'd rather learn in a structured order, start with the Formula Library; if you like reading around a topic before you touch a cell, the blog is for you.

What you'll learn

Core concepts covered across guides in this section.

Learning Hub

Featured Learning Guides

Master Excel, Google Sheets, VBA and business automation through practical tutorials, real-world examples and downloadable resources.

Guides
250+
Cadence
Updated Weekly
Skill range
Beginner → Advanced
Access
Free + Pro
  • HOWXLO

    How XLOOKUP quietly replaced VLOOKUP

    Coming Next

    Why modern Excel workbooks no longer need VLOOKUP — and what to migrate first.

    6 min read
    8 Examples
    Updated Recently
  • THERIG

    The right way to use FILTER and dynamic arrays

    Coming Next

    Replacing helper columns with spillable formulas your team can actually read.

    6 min read
    8 Examples
    Updated Recently
  • QUERYS

    QUERY: SQL for Google Sheets

    Coming Next

    A gentle introduction to the most powerful function in Sheets.

    6 min read
    8 Examples
    Updated Recently
  • AIANDT

    AI and the future of spreadsheets

    Coming Next

    Where AI-assisted formula generation fits alongside Excel, Sheets, and Power Query.

    6 min read
    8 Examples
    Updated Recently
  • CLEANI

    Cleaning messy data without macros

    Coming Next

    TEXTSPLIT, REGEXEXTRACT, and Power Query patterns for real-world data.

    6 min read
    8 Examples
    Updated Recently
  • BUILDI

    Building a dashboard people trust

    Coming Next

    Layout, colour, and formula patterns that make a report feel dependable.

    6 min read
    8 Examples
    Updated Recently
  • CASEST

    Case study: closing the books 3 days faster

    Coming Next

    How a finance team used FILTER and QUERY to eliminate a manual reconciliation.

    6 min read
    8 Examples
    Updated Recently
  • PRODUC

    Product update: history & favourites

    Coming Next

    Track every formula you generate and save the ones you'll reuse.

    6 min read
    8 Examples
    Updated Recently
  • 10FORM

    10 formulas every analyst should memorise

    Coming Next

    The short list that covers 80% of everyday spreadsheet work.

    6 min read
    8 Examples
    Updated Recently

Need a custom formula instead?

Generate Excel, Google Sheets or VBA code instantly using XLFormula AI.

Generate with AI

Who is this for?

  • Analysts and operators who want sharper spreadsheet skills
  • Finance and RevOps teams standardising on modern patterns
  • Founders comparing spreadsheets, BI tools, and AI helpers
  • Existing XLFormula AI users following product updates

Why it matters

Spreadsheets sit at the centre of most companies' decision-making, but the language people use to reason about them hasn't kept up with the tools. Dynamic arrays, AI generation, and modern functions have quietly changed what "good" looks like.

The blog is where we work through those shifts out loud so you don't have to figure them out alone — and so your workbooks stay on the current side of best practice.

Frequently asked questions

How often do you publish new posts?
We aim for at least one long-form article per week, plus shorter tips and product updates as features ship.
Can I subscribe by email?
Yes — the newsletter signup on the Formula Library page delivers new posts and formula guides straight to your inbox, no spam.
Do you accept guest posts?
Occasionally, from practitioners with a specific real-world story. Email us via the contact page with a short pitch.
Are the articles Excel-only or Sheets too?
Both. Every post notes which platform it applies to, and cross-platform techniques are called out explicitly.
Where do product updates live?
Bigger updates get a full post here; smaller changes appear in the changelog inside the app.

Explore related sections

XLFormula AI

Need a custom formula right now?

Describe what you need in plain English and get a ready-to-paste formula or script in seconds.

Generate a formula with XLFormula AI