The three key spreadsheet controls are macros, workbooks and pivot tables. Each spreadsheet control is very important. While it is tempting to use all three on a workbook, you need to know the differences between them. Macros are the little macros that you can add to your workbook to perform…