Automate reporting tasks with a mapping table
Course Objectives
- Store data in tables so that new rows are automatically included in related formulas
- Perform conditional summing with the SUMIFS function
- Create an intermediate mapping table so that Excel has the information needed to translate labels and aggregate data rows
Take course on 