Using Matrices in Excel

When you multply two matrices in excel, you

- drag over the region for the product matrix
- in the command bar type = (
- then drag over the 1st matrix,
- type a comma,
- then drag over the 2nd matrix, then type )
- then press Ctrl-Shift-Enter

This document talks about a 1-D rotation matrix, and how to build a spreadsheet which plots the appearance of a constant vector (1,0) in the x,y frame as it is seen in a rotated coordinate system.[ It does assume you know how to insert a scroll bar to adjust the rotation angle.]

This spreadsheet is one way of doing 1D rotation of a vector.