Tracking your bills in one basic location such as a spreadsheet allows you to create a budget method that is organized and provides quick information when you need it. Using a spreadsheet, whether on ...

Today’s topic may seem like an unnecessarily basic one, but I can tell you that nine out 10 shared spreadsheets I receive from team members are unusable for analysis because they can’t be sorted. I’m ...

Spreadsheets, which are similar to databases, can help you visualize and manage data entities and values that make up your company's customer information repository. If that information doesn't reside ...

It’s January and you’ve gone and done it: You’ve resolved to keep better track of your personal finances. But deep down, you’re not sure where to start. Sure, you can buy accounting software, sign up ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

In my post today, I’m going to show you how to use GoogleDocs and Google Calendar to create a dynamic calendar for a course. This calendar can be displayed as a web page or embedded in a course web ...

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

Making and regularly updating a budget can help you live within your means and save for the future, whether that means a down ...