Monday, March 27, 2017

How to Do a Cross Product in Excel

  I found a screen recording tool in PowerPoint 2016 today and decided to test it with a video showing how to do a cross product in Excel 2016. One first enters two vectors in adjacent columns. If one copies the first two rows underneath the original two vectors one can use drag and fill to copy the formula for the first component of the cross product in the third column. Setting the two rows at the bottom equal to the first two rows at the top allows the procedure to work even if the numbers are changed.

Hiding the 4th and 5th rows makes it easier to view the results.

No comments: