Consolidating data and investigating macros

In this section, you will learn how to build a summary sheet to consolidate workbook data and become an expert at creating macros to perform common tasks in workbooks. You will also master how to create macros and make them globally accessible within Excel, as well as how to display macros on the QAT or as a new tab on the Excel ribbon. Finally, you will learn how to remove macros from a personal macro workbook.

Creating a summary sheet

If you are a business analyst, you receive worksheets that calculate the same data each month, such as product sales for different areas and/or parts of the company. Once you receive these worksheets, you need to combine (consolidate) them by collecting...