| Title | Description | Posted | File |
| The Formula Trace Tool | The Formula Trace Tool is a free utility designed to make the process of auditing an Excel spreadsheet, workbook, or series of linked workbooks much easier. The tool allows the auditor to click on precedent or dependent cell references in a listbox as opposed to clicking on audit arrows or performing a manual search. This functionality allows the auditor to move through formulas much more quickly and efficiently. |
09/05/09 |
|
| Title | Description | Posted | File |
| VBA to Load Named Ranges for Dynamic Charts | Shows how VBA can be used to create named ranges that serve as dynamic chart sources. |
08/02/09 |
|
| Chart in Userform with Listbox Control | Illustrates how to use a listbox to control the order of how charts appear in an image control. |
01/20/09 |
|
| Healthcare Waterfall | A variation on the waterfall charting techniques as illustrated at the PeltierTech site - applied to Healthcare. |
02/06/08 |
|
| Breakeven Chart with Dynamic Label | A dynamic chart that shows a breakeven point. |
12/01/07 |
|
| In-Cell Charting | A VBA technique for creating very small in-cell charts. |
11/03/07 |
|
| Bar Chart - Exclude Zero Values | 05/19/07 |
|
|
| Proportional Axes Calculations | 05/11/07 |
|
|
| Non-Contiguous Named Ranges as Chart Sources | 05/05/07 |
|
|
| Pie Chart - Exclude Zero Values | 04/29/07 |
|
|
| Auto-Sort Chart | 04/21/07 |
|
|
| Salary Forecasting and Spread Model | 04/18/07 |
|
|
| Variance Analysis - Four Components | Illustrates the mathematical components of compounding for two, three, and four component variances. |
04/08/07 |
|
