## Excel Blog

Excel tips and tricks by Timothy R. Mayes, Ph.D. I am the author of Financial Analysis with Microsoft Excel (2013), 7th ed. and am a faculty member in the Finance Department at Metropolitan State University of Denver.

## Update to Variance/Covariance Matrix Builder for Excel 2010 and 2013

Sunday, October 26, 2014

Five years ago (wow, it has been a long time) I wrote an add-in to create a variance/covariance matrix in Excel. The purpose of that add-in was to do something that Excel should do, but doesn't: create a "live" variance/covariance matrix.

For some reason, Excel only places formulas along the diagonal. So, I wrote an add-in that used the matrix algebra functions to create a covariance matrix that would change if you changed the data. At that time, I used the matrix functions to do this because I wanted to be able to create a probability-weighted covariance matrix, and...

## Variance/Covariance Matrix Add-in for Excel 2003 and Earlier

Tuesday, January 20, 2009

I recently created an add-in to create a variance/covariance matrix for Excel 2007. If you follow that link, you will be able to read about the add-in and how to use it. The purpose of this post is to announce that I have created the same add-in for prior versions of Excel.

Note that both versions of the add-in are now updated so that they will calculate either a population or sample variance/covariance matrix. They also now allow for the covariance matrix to be output to a worksheet that is different from the input range.

This version of the add-in works in Excel...

## Variance/Covariance Matrix Add-in for Excel 2007

Wednesday, January 7, 2009

Update 2: New features added on February 7, 2009. Please see end of post.

Update 3 (October 24, 2014): New features are coming very soon in version 2.0. It is complete, except for testing. Watch this blog for details and download. The new version will require Excel 2010 or later. I should have it posted within a few days. Because of the coming update, I have renamed the previous versions and updated the links in the posts.

Excel doesn’t always do everything that you might want, or it doesn’t...

## High Quality Screenshots for Print

Monday, November 10, 2008

I’m knee-deep into work on the 5th edition of Financial Analysis with Microsoft Excel, but I feel the need to make this post while I’m thinking about this stuff. I have finally figured out how to create high quality screenshots of various Excel dialog boxes and other components. This is something that I’ve been trying to get to work for a long time, but I had to rely on the artists at my publisher to spruce up screenshots in the past. I’m no artist, so I didn’t figure this out on my own. I got the instructions from the graphicPUSH blog, and I did some experimenting of my...

## Division, the Hard Way

Monday, October 6, 2008

John Walkenbach recently posted Spreadsheet in a Phone, where he mentioned a new spreadsheet for the iPhone/iPod Touch. Well, I thought that this is the coolest thing ever, particularly as I just bought an iPod Touch (2nd generation) for my trip to the Financial Education Association meeting in Hilton Head. So, even though it isn’t free (\$7.99) I headed straight to the App Store to buy a copy.

When I got there I saw that there were a few comments, and they weren’t too flattering. It seems that the Spreadsheet for the iPhone was released before it was ready for the...