|
Are you looking for a job? Or are you concerned you
might need to look for one soon? We'd like to help.
Post samples of your Excel dashboard reports at ExcelUser.com, along with your employment and contact information…for free.
|
 |
|
Many companies find ways to thrive in recessions. These
well-run companies find ways to adapt; they change
quickly; and they grow.
But in too many companies, change crawls along at a
snail's pace. Harvard's John P. Kotter explains how to
encourage A Sense of
Urgency for changing your organization's
performance.
And Excel plays a critical role.
|
|
|
|
Seasonal sales are difficult to forecast and analyze.
It's hard to pick up on monthly trends. It's hard to
forecast future sales. It's hard to plan spending a
staffing. Seasonal sales are...messy.
Here's how to deseasonalize your sales data so you can
gain greater insight about your sales.
|
|
|
|
This is our most advanced Excel plug-n-play dashboard ever. Link
your Excel dashboard reports to an Excel database. Automatically sync your
charts' Y axes. Automatically scale your data. Use any currency.
Learn more now.
|
|
|
|
Amazon.com says their new Kindle DX is great for reading
newspapers, textbooks, and other commercial
publications. But the DX also could offer Excel users a
huge advantage.
It's possible that the Kindle DX could transform the way
that Excel users deliver
dashboard reports, standard Excel reports, textual material, and many other types of management
information.
|
|
|
|
 The
purpose of any Excel report is to give its readers the
most-useful information in the shortest-possible reading
time.
Which type of report is best?
Standard Excel reports certainly are the most widely
used. But Excel dashboards have gained a lot of
supporters. Compare two reports of the same data and decide for
yourself.
|
|
|
|
Suppose you have a Sequential List of items. And suppose you want to show the date of the first and last entry
in the list. How would you do it?
This question isn't limited to dates, by the way. Your list
could display numbers or text instead. How would you return information
about the last occurrence of each item in the list?
Use SUMPRODUCT, of course.
|
|
|
|
 Times are tough these days. Companies around the world are laying off great people.
But the good news is that Excel users have the power to take control over their
destinies in ways that many of their other co-workers can't.
|
|
|
|
 The world's economy is in recession, with no end in sight. Some companies are in desperate shape. Others
are merely hurting.
Whatever your company's condition, it's a good idea to take stock of your business to figure
out what you can do now to make your company healthy even if business gets
worse.
You'll survive the downturn more easily if you master the cost-lag loop.
|
|
|
|
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 after Excel 2007 was introduced, we started to ask which version of Excel you use.
You now can see
the results of our
poll here.
|
|
|
|
(Updated Feb-09) Excel
2007's 'Ribbon' is the most significant change that
Microsoft has ever made to Excel's user interface. We wanted
to find out what Excel users in business think of that change. You
can see the results here.
|
|
|
|
If
you prepare balance sheets in Excel, you can make them a lot more
useful to your readers. Just add Sources and Uses information to
your ordinary balance sheets.
This simple improvement tells readers how each balance sheet item has changed, and how those changes have affected cash
flow.
|
|
|
|
The
Z Score is the best-known analytical tool for predicting the likelihood of business
bankruptcy. We show you how to calculate Z-Scores with Excel.
|
|
Costs are rising. Sales are falling Credit is limited. Taxes are going
up. We offer five reasons that Excel users will find solutions, if they
exist. |
|
|
|
Do you monitor
your receivables with the AR Collection Period, also
called "Days Sales Outstanding in Receivables" (DSO)?
Learn why DSO fails and how Excel can give you more accurate results, results that also can
improve your cash flow forecast.
|
|
Use this formula to learn whether your price change will
help your gross profits or hurt them. It will help you
to brainstorm your pricing strategy more easily.
|
|
|
Charley Kyd created the first spreadsheet dashboard more
than 25 years ago using Lotus 1-2-3. Every line in every
chart consists of text in cells. See examples of the first
spreadsheet dashboard report, and read a
brief description of how it was created.
|
|
If you have seasonal sales, or other measures of performance,
Cycle Plots can offer greater insight about your performance than
traditional charting techniques.
|
|
|
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? We show you how.
|
|
Do you create periodic reports using data stored in an Excel databases? We show an easy way to let
Excel formulas do the work.
|
|
|
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.
|
|
|
Pablum
Dashboards
