I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...

You've probably heard of pivot tables and just kind of ignored them, since they sound pretty complicated and it's not even clear what they do. The reality is that you can create pivot tables from ...

Zoho continues its quest to build the most comprehensive online productivity suite, adding support for macros and pivot tables in its spreadsheet, Zoho Sheet. The new version includes support for ...

Pivot Tables are meant to simplify (and partially automate) the ways you can organize and interpret the various data points in your spreadsheets. Think of it as a way to make either Excel or Sheets ...

In Excel 2010, there is a subtle way to hook all four pivot tables up to the same set of slicers. Thus, the VP of Sales selects from the slicers and all four pivot tables update at once. Details – How ...

Zoho keeps pushing the limits of what online productivity apps can do, It was the first to use Google Gears to create an offline version of Zoho Writer last year, for instance. And now it is adding ...