For business users of Microsoft Excel Free guides and templates
Home > 

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, & VBA.

Interactive Reporting

How to Set Up a Data-Validation List Box in Excel

Excel's Validation ListThe 'List' Feature of Excel's Data Validation command offers a quick and easy way to set up a dropdown list box. Here, for example, you can choose either North or South.

Interactive Reporting

How to Use Advanced Filters to Create a Unique List of Items from an Excel Table

Advanced filterExcel's Advanced Filter command provides a quick way to generate a unique list of items found in an Excel table. Here's how to generate the list.

Dynamic Reporting

Create Dynamic Variable-Length 'Accordion' Reports Linked to Tables

When you change a criteria value in a cell, Excel can use formulas and conditional formatting to expand or contract your report automatically, without macros. Here's how.


How to Foot and Cross-Foot Excel Reports in a Floating-Point World

 An Excel table that's footed and cross-footed correctly.

To reduce errors in Excel reports, you should foot and cross-foot them. But Excel's floating-point arithmetic gets in the way. Here's how to get around this problem.

Excel Databases

A Use this Excel 'Cash Flow Balance Sheet' to See Sources & Uses of Funds

A comparative balance sheet report from Excel, with sources and uses of funds.

Use Excel to get a clearer picture of how changes in your Balance Sheet affect your cash flow.

Use Excel to Fix Your Broken Accounts Receivable Measure

This is why DSO is a terrible measure.

Here, all invoices are paid in 45 days. But when sales grow quickly, longer averaging periods produce larger DSOs. Excel can fix this problem.

Add Cash Flow Information to Your Excel Balance Sheets

A balance sheet that includes sources and uses of funds.

A simple change to your Excel balance sheet can provide key cash flow information.

Use INDEX-MATCH or VLOOKUP to Populate Invoices and POs

A simple invoice that relies on Excel lookup formulas to populate it.

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.

Manage Periodic Payments with an Excel Cash Calendar

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.

Use Conditional Formatting to Manage Customer Tasks

The lower table specifies the code and color to use for each employee. The upper the assignments in use.

A manager needs to assign employee color codes to tasks they perform for customers. Here's one way to do it with conditional formatting.

Show Key Stats Automatically in Periodic Excel Reports

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.

Automatically Sort Data in Reports Using Excel Formulas

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.

Thirteen Ways to Improve Your Monthly Board Reports with the Help of Excel

This feather chart illustrates how each new plan promises near-term success, while actual performance lags.

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.

Financial Management

Predict Business Bankruptcy Using Z Scores with Excel

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.

Management Reporting

Use Excel to Find the Variances That Matter

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.

Getting Organized

Use Conditional Formatting to Manage Employee Tasks

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.

Free Excel Dashboards

Charley's SwipeFile charts