David's Daily Bread
News and Scripture each morning. Practical tools each evening. Loved by God.
Start here tonight
try Goal Seek first Trending workflowHow-To Geek front, Sep 30

Six LibreOffice Calc features handle the spreadsheet work most people think they need Excel for, and it is free

The free spreadsheet quietly grew the tools most people assume sit behind a Microsoft subscription.

How-To Geek's Tony Phillips walks six LibreOffice Calc features that cover work most people associate with Excel. Goal Seek solves backward from a target to the input that reaches it, such as the price per cup needed to hit a profit goal; pivot tables reorganize a long list into summaries by region or product; Data, Statistics, Regression produces a full report with R-squared, ANOVA, coefficients and p-values; XLOOKUP, FILTER, UNIQUE and SORT work with spill, the same as the modern Excel formulas; macros can be recorded; and regular expressions run directly inside Find and Replace at Ctrl+H, cleaning text without helper columns. Phillips does not oversell any of it, noting that Excel offers more options for customizing and interacting with pivot tables and that Excel's VBA ecosystem is much deeper for complicated automation.

✎
The tool shelf new tonight

Every shelf item is available today; no waitlists, no vaporware.

✎
The workflows follow along at home
Mary of Nazareth

Keep and Ponder

The useful work is finished. Keep what is true, ponder what matters, and entrust the rest to God.

Keep

Casting all your care upon him; for he careth for you.
1 Peter 5:7, KJV

Ponder

Put one worry into words, then entrust it to God.

Entrust

Father, receive what troubles me and remind me that I am held in your care. Amen.

A practice shaped by Luke 2:19Guided by the biblical witness of Mary of Nazareth.
Page notes
✎