|
 Do you monitor
the health of your receivables using the "accounts-receivable collection period," also
called the "Days Sales Outstanding in Receivables" (DSO)?
If so, you know a lot less about the health of your receivables than you think you do.
Learn why DSO fails and how Excel can give you more accurate results, results that also can
improve your cash flow forecast .
|
 |
|
Excel 2007 is significantly different from earlier versions of Excel. So we wondered how
widely used it is among its business users. That is, what's the Excel 2007 market share?
Six months ago, we started to ask which version of Excel you use. You now can see
the
results of our poll here.
If you haven't taken the poll, you can take it several places on this site, including
at the right above. Also, please take the other poll at the right, which asks what you
think about Excel 2007's most significant change: The Ribbon.
|
|
|
|
 Suppose you
plan to increase profits by raising or lowering your prices. Your unit sales probably
will increase if you cut prices and decrease if you raise prices. A little-known
formula can help you decide whether your change in price, combined with the likely
change in unit sales, will help your gross profits or hurt them.
By using this formula in a calc-plot chart, you can get a better picture
of all your pricing options. This will help you to brainstorm your pricing strategy
more easily.
|
|
|
|
 This chart displays eleven years of seasonal data in new way.
It's called a Cycle Plot.
Here, the chart shows the trend for all sales in each of the twelve months. The
horizontal line shows the average sales for each month.
Learn to create Cycle Plots here.
|
|
|
|
 You can print your own Excel reports like these today with our new
Plug-N-Play Excel Dashboard Kit #1.
Our new low-cost package provides ten dashboard report designs and fifteen
color themes, for a total of 150 different reports. Just enter your
data and print your reports.
Learn more about this quick and
easy way to create Excel dashboard reports.
|
|
|
This figure shows two graphs from the first
spreadsheet dashboard report, created using Lotus 1-2-3 in 1984. Each line of the
charts consists of text in cells. We offer more examples of this report and offer a
brief description of how it was created.
|
|
|
|
When you're analyzing data that can have multiple values, it's often useful to know
how often various ranges of values have occurred. For example, how many
products have you sold at different prices? How many employees are in each pay
grade? How many expense accounts rose or fell by certain amounts? Although Excel's FREQUENCY function was designed to calculate
frequency distributions like this, you also can use SUM-IF, SUMPRODUCT,
and Excel 2007's COUNTIFS function. We offer a summary of your
options.
|
|
|
|
To be
honest, this item has no direct connection with Excel. But it certainly describes an
issue that many Excel users will recognize. As far as that goes, the style will be
familiar if you've ever read Kipling.
You might find it worth your time.
|
|
|
|
It's a common problem. Each day or week or month you import data into a spreadsheet,
and then you update your reports to display the new information. However, unless
you've designed your Excel reports carefully, you'll have to change your Excel
formulas to include that new information. Instead, we show an easy way to let
Excel formulas do all the work.
|
|
|
 One easy way to return an item from an Excel
database is to add a dropdown list box to your spreadsheet. But suppose you want to
return additional information about that item, how do you do it?You can use Excel's Data Validation feature to return the
item, and INDEX-MATCH to return other items. We show you how.
|
|
|
Is debt your enemy or your friend? It's your friend if you're making money
on the cash you borrow. The EOA ratio compares directly to the interest rate on your debt. When your
EOA exceeds your interest rate, you're making money from your debt.
|
|
Is your company growing faster than it can afford? The Sustainable Growth Rate can
help you manage your company's financial ability to grow.
|
|
|
|
Is your company spending thousands of dollars for
business dashboards that serve up your performance measures like pablum?
|
|
Here are some products and services we use on our own computers. Our first recommendation:
Remote Data Backup for Businesses
|
|
|
|
Unless you're a public accountant, you probably haven't experimented with Benford's
Law. Auditors sometimes use this fascinating statistical insight to uncover
fraudulent accounting data. But it might reveal a useful strategy for
investing in the stock market. And it might help you to improve the
accuracy of your budgets and forecasts.
|
|
SUMPRODUCT offers great power to summarize lists of data in Excel worksheets.
It works somewhat like array formulas, but without the complications. Unfortunately,
Excel's help topic ignores the real power of this function.
|
|
|
|
Excel array formulas can summarize Excel data quickly and easily.
We explain the most powerful and flexible approaches. The most powerful method
is to use Excel arrays, which can give you summaries using any number of criteria.
|
|
A reader asks how to calculate Future Values from cash flows that aren't necessarily
periodic.
We show how to calculate both Future and Present non-periodic values.
|
|
|
|
In Don't Discard
Those Spreadsheets: The Power of Excel-Friendly OLAP, Charley Kyd offers
a practical response to the anti-Excel attitude that is common these days among
people who promote expensive BI and BPM systems for large companies.
The article offers an agile and low-cost alternative to those systems.
|
|
Okay, so "art" might not be the correct word. But these cartoons were
created in Excel
Check them out!
|
|
|
Pablum
Dashboards
