Metric of the Month: Total Cost of the Finance Function
Judged according to the cost of their finance functions, some companies may be wasting millions of revenue dollars on inefficient processes.
Beyond ERP and Excel
Here is a look at decision points for whether and how to use stand-alone financial analytics solutions.
Spreadsheets: Filtering a Pivot Table with a Formula
There is really no good way to change the filter with a formula. However, there is a quick fix to remedy the situation.
Spreadsheets: Suppressing Cells in a Pivot Table
The trick in this week's article is using a Microsoft loophole for cells that add up to zero.
Spreadsheets: Forecasting Seasonal Data with Excel
Production forecasting with Excel usually entails using straight-line regression. But you'll need to tweak your formulas if you want to incorporate seasonal sales data into the mix. Here's an easy way to run the numbers.
Spreadsheets: Eliminate the Pivot Table Blank Row Snag
Blank rows in Excel pivot tables cause the program to default to the counting, rather than sum, function. Here are three quick ways to avoid manually changing functions every time a pivot tables runs into a blank.
Spreadsheets: Rank Items in a Pivot Table
Maybe your Final Four college basketball ranking was scrambled this year, but here's how to fix ranked items in a pivot table when you are using Excel 2010, as well as prior versions.
Spreadsheets: Open to Today’s Date
Cut and paste this simple macro into your workbook to make it open on the current date. Then add just a few more lines of code to customize the macro to your liking.