I. A Text Box is useful when youre creating a report and dont want typed words to behave like cells. It makes it easy to move your text around, rather than cutting and pasting cells (which could potentially mess up the formatting of real data). The next area is for Headers & Footers, which will take you to the page layout view _ here you can add headers and footers for the entire page. WordArt, on the other hand, lets you embellish text. Insert Object lets you place entire files (Word documents, PDFs, etc.) into the worksheet.
F. Slicers are big lists of buttons that make your data more interactive. You can select a PivotTable youve created, and then create a slicer from it _ this allows a viewer to click on buttons that correlate to the data they want to filter.
Note that data from different sheets in the same workbook can be referenced for formulas. For example, if you have two sheets, Sheet1 and Sheet2, you could bring Sheet2 data into Sheet1. If you wanted cell A1 in Sheet1 to equal the A1 in Sheet2, youd enter this formula into A1: “=Sheet2!A1”. The exclamation mark calls on the previous sheet referenced before locating the data.
H. Miscellaneous Tools: Starting at the top left, theres AutoSum, which allows you to select a swath of cells and place the sum in the cell located right below or directly to the right of the last selected data point. You can use the drop_down to change the function to calculate the average, display the maximum, minimum, or the count of numbers selected.