Not all variances are created equal. Use Excel’s `FILTER` function to display only employees with significant variances: =FILTER (VarianceTable, ABS (VarianceTable [Variance]) > ThresholdValue) ...

This article presents several refinements of previously published Excel-based models for determining mean-variance efficient portfolios. The refined model does not use matrix algebra, it allows in ...