This page provides a linked list to each post on the site:

• Building the Formula Trace Tool Post 1

• Building the Formula Trace Tool Post 2

• Building the Formula Trace Tool Post 3

• Formula Trace Tool Update

• Compounded Change

• Conditional Formatting Seasonal Volumes

• Forecast Monthly Spreads with Partial Year Results

• Salary Forecasting and Spread Model

• Two-Way Variance Analysis Post 1

• Variance Analysis - Four Components

• Variance Analysis - Three Components

• Variance Analysis - Two Components

• A Study of Pie Chart Rounding

• Actual vs. Plan Dynamic Charts

• Add Labels to Chart Data Points

• Align Charts to Worksheet Grid Post 1

• Align Charts to Worksheet Grid Post 2

• Align Charts to Worksheet Grid Via Chart Names

• Auto-Color Chart Bars Version 1

• Auto-Color Chart Bars Version 2

• Auto-Sort Chart

• Bar Chart - Exclude Zero Values

• Breakeven Chart with Dynamic Label

• Combining Chart Types, Adding a Second Axis

• Comparing Revenue Growth - Gross vs. Net

• Conditional Format XY Points

• Data Labels - Even Top Alignment

• Declaring Embedded Line Chart Variables

• Dynamic Chart - Show Range Between Values

• Extract Data from an Excel Chart

• Flag XY Duplicates with Different Formatting

• Format Chart Based on Point Values

• Get Chart Data Points With VBA

• GET.CHART.ITEM XLM Function

• Healthcare Waterfall

• In-Cell Charting

• Name, Hide, and Show Embedded Charts

• Non-Contiguous Named Ranges as Chart Sources

• Pie Chart - Exclude Zero Values

• Print Only Embedded Charts Showing Data

• Proportional Axes Calculations

• Proportional Axis Calculations - Unit Conversions

• Secondary Axes in Charts Discussion

• Sort Charts by Name

• Why Use Pie Charts?

• XY Scatter Chart - Flag Duplicates

• XY-Bar Combination Chart

• Index-Match Formula

• Index-Match-Match Formula

• Interpretation of Percent Change

• Linear Regression

• Percent Change

• Percent Change Error Trap

• SUMPRODUCT Function to Drive Financial Statements

• VLOOKUP Array

• Automatically Set Min and Max Scale for Y-Axis

• Compound Annual Growth Rate Formula

• Contest - Excel Models for Science and Engineering

• Excel 2007 Changes

• Formatting of Reports Before Excel File Distribution

• Two-Way Variance Analysis Post 2

• Calculating Healthcare Payer Mix Changes

• Components of Healthcare Revenue Variances

• Components of Healthcare Revenue Variances Part 2

• Counting New vs. Established Patients

• Simple Discounts Variance Analysis

• Pivot Table Difference Between Columns

• Pivot Table Fill

• Charting Add-Ins Updated

• Microsoft Knowledge Base

• Technical Articles and Reports by David A. Heiser

• The Spreadsheet Page Revisited

• Auditing Similar Column Data for Errors

• Extract Unique Values in a Range

• Fill a Blank Range with Zeros

• Load Array From Worksheet Range

• Lookups and VBA Loops for Reporting

• Returning Non-Integer Values from Scrollbars

• Reverse Items in an Array

• Simple Goal Seek Procedure

• Size and Export Embedded Charts as .GIF Images

• Square Cells with VBA

• Trigger Macro on Range and Sheet Changes

• Around the Web 1

• Around the Web 2

• Healthcare Analysis

• Welcome to cellMatrix