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

Before bookkeeping software, accountants used handwritten spreadsheets to track business expenses. Now you can use programs, such as Excel to design expense spreadsheets and do the math for you, but ...

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

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

When it comes to creating spreadsheets, the software that comes to the minds of most people is Microsoft Excel. Microsoft Office is a complete suite that lets users create documents, spreadsheets, ...

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

Thanks to a suggestion from Macworld reader David Erato, I’ve spent the last couple of weeks immersed in spreadsheet applications…no, not on my Mac, but on my iPhone. David was curious how well the ...

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

You can make a bar graph in Google Sheets to make the data in your spreadsheet more digestible, useful, and visually appealing. Once you select the data in your spreadsheet needed for a graph, you can ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...

This Excel spreadsheet uses conditional formatting to highlight the resistor pairs in a design that can create a particular ratio. The target ratio is entered in cell C3, and the tolerance is entered ...