Learn how accounting spreadsheets work with real examples of journals plus when to switch to accounting software.

Many people have trouble keeping their checkbooks balanced. Now that debit cards have made it easy to have money electronically transferred out of your bank account without even having to write a ...

When I started my career as an engineer, personal computers were a luxury. When our department finally got one, we had to share, and coordinated our schedules so we could each use it for a few hours a ...

Freeze results, hide sensitive logic, and boost performance by converting dynamic formulas into static values.

Microsoft Office's Excel application allows users to store, model and manipulate data sets. Excel spreadsheets organize this data into worksheets, each with a number of rows and columns. Each row or ...

There was a time when spreadsheets ruled the world. It seemed as if there was nothing a sharp Excel spreadsheet and some targeted functions couldn’t accomplish. Those days are gone now. Excel may ...

I learned, belatedly, that last October 17 was Spreadsheet Day, marking the 35th anniversary of VisiCalc, the Apple II program that started it all. This moved me to republish a long piece I wrote 30 ...

Spreadsheets are super powerful, but they have limits. This article examines four big challenges of working in spreadsheets, and shows how data science tools such as notebooks can cleverly address ...

A reader asked what program I’d recommend for creating a “database” of her CD collection that could be broken down by song title, artist, genre, performance date, etc. A “database” is a “table” of ...