Excel Reporting and Financial Topics
Excel reports, analyses,
forecasts, budgets, and other
displays that don't emphasize charts or dashboards. Also, topics
about using Excel for financial analysis.
For help about worksheet
functions that summarize data for your reports, and also
financial functions, see
All Excel Worksheet
Functions, with Links to Help Topics. And for help with
formulas that use these functions, see
Excel Formulas, Data, Tables, &
Here, all invoices are paid in 45 days. But when sales grow quickly, longer averaging periods produce
larger DSOs. Excel can fix this problem.
A simple change to your
Excel balance sheet can provide key cash
This simple invoicing system allows you to keep a list of products and prices, then populate an invoice with the item and quantity you choose.
Does your company need to
make scheduled payments to companies that don't send invoices? This Excel worksheet
will help to plan those cash requirements.
A manager needs to assign employee color codes to tasks they perform for customers. Here's one way to do it with conditional formatting.
Each issue of Business Week magazine
used to include several figures titled "The Stat". These figures emphasize key data related to the article on the page where
the figure appeared.
Here's how to display miscellaneous facts and figures in your Excel management reports, and update them automatically.
Many Excel reports include tables
with sorted results. You don't need to
perform these sorts manually or with macros.
Your formulas can do it for you.
An experienced financial consultant and Board member describes the problems typical with many Board Reports.
Here's how Excel users can fix many of those problems.
Is your largest customer heading for bankruptcy? Your most important vendors? Your own employer?
The best-known analytical tool for predicting the likelihood of business bankruptcy is the Z-Score.
Here's how to calculate Z-Scores with Excel.
Managers and staff can waste significant time and money trying
to control insignificant, uncontrollable, and random variances.
Instead, Excel users can filter variances to find those that matter.
A manager needs to assign employee color codes to various tasks they perform for customers. Here's one way to do it with conditional formatting.
to see more testimonials
"Your Swipe Files have been an amazing help.
Here are quotes from emails I received from my boss..."
"Your charts have gotten a lot of positive feedback
by our Executive Team" Greg Sutton
book is FANTASTIC!!!" Manoj Kapashi
"I love your plug-and-play dashboard!"
dashboard like this is an eye-catcher. It allows my reports to
look incredibly slick..."Mark Johnson
Click to see more