For novices, functions are one of the most intimidating features of OpenOffice.org's Calc. Newcomers quickly learn that functions are a main feature of spreadsheets, but there are almost four hundred, ...

To some reporters, data journalism might sound daunting – but it needn't be. Just a handful of basic spreadsheet methods can help you start finding stories in data, whether that is crime stats, ...

Microsoft Excel gives users the flexibility to configure data and perform very basic operations, such as addition, subtraction, multiplication, or division by using shortcuts or custom formulas. This ...

I love productivity systems and apps and lately I’ve developed my own, which requires only a regular spreadsheet–Excel or Google docs will do–and it’s easier and more effective than any I’ve tried. It ...

It creates a reusable function that takes three inputs: actual sales, sales quota, and a weighting factor. It returns a ...

In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data. Using a quick equation, you can convert an existing set of time data ...

FILTER works well with other Excel functions like SORT and UNIQUE to create powerful data management combinations. You can ...

It almost goes without saying that some sort of office productivity suite is required for a new Mac system, and while some might gravitate to Microsoft Office there are others available that can ...

Create an Excel function to highlight formula cells in a worksheet Your email has been sent With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort.

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. Apples iWork 08 boasts improvements to the software suites ...