Have you ever stared at a PivotTable, wondering how to extract deeper insights without endlessly tweaking your source data? PivotTables are incredibly powerful tools, but sometimes the default options ...

Excel is a spreadsheet with a lot of power. The software can be used to track inventory, track and calculate payroll and a myriad of other calculations. An Excel formula is generally composed of ...

Array formulas let you perform calculations across entire ranges of data in a single formula. Hence, you can handle lightning-fast lookups, filtering, and sorting with just one po ...

Monitoring sales revenue allows you to track your business' profit, but equally important is understanding where those revenues are derived. If you sell multiply products, or categories of products, ...

I don't usually cover random software bugs on Hardware 2.0 but since a few of you sent me links to this story I thought I'd post it for others. The Problem This issue was introduced when we were ...

Harness the power of Subtotal in Excel to count grouped items Your email has been sent Excel's Subtotal feature can render quick results when you need simple grouping calculations. Susan Harkins shows ...

Q: I found an anomaly with a rather simple Excel computation; specifically, Excel calculates 111,111,111 times 111,111,111 to equal 12,345,678,987,654,300, which is ...

The UMass study found other potential flaws in the 2010 report including unconventional statistical weighting and selective data omission, but thus far Reinhart and ...