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 ...

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

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 ...

February 18, 2014 Add as a preferred source on Google Add as a preferred source on Google Spreadsheets are one of the most mystifying pieces of software you'll encounter in your adult life. As scary ...

Excel spreadsheets are one of the most useful tools to create documents with calculations and data and organize the accounting or VAT tax, among other tasks. Luckily, while working on Excel you can ...

You run the engineering arm of an organization and requests come in hourly. There are only so many people on your team and while priorities are clear, resources still need to be divided. In a perfect ...

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 ...

Audit hidden data, filters, and hard-coded values to ensure your Excel spreadsheets are professional and precise.

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

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 ...