Small businesses need to ensure data integrity in spreadsheets. Microsoft groups objects such as drop-down lists in a category called data validation. These objects help spreadsheet creators control ...

Whole-column references in Excel are silent performance killers, often forcing the program to manage a range of over a ...

I’ve started recreating many of my numerical model tutorials for introductory physics. In the beginning, I had students use spreadsheets to create models. Of course, spreadsheets aren’t very good for ...

Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn ...