Skip to content
Lavastro

Articles

Notes on data and products

Practical writing about product work and the numbers behind it.

Candlestick chart on a screen

10 essential Excel functions for data analysis and reporting

The ten Excel functions worth knowing first for analysis and reporting, from SUM and IF to XLOOKUP, INDEX and MATCH, with an example for each.

More on Excel

Excel automation articles on NonStopExcel →

Power Query, dashboards, macros and report automation, written for small businesses.

Have a product that needs direction?

Tell me about your product and where it's stuck. I'll reply within one business day with how I can help.