Data analysis is made easy when you know how to utilize excel. Multi criteria SUMIFS used in combination with the indirect formula is a clever way to query data quickly and efficiently. This excel essential can significantly increase productivity when setting up output tables and make updating them simpler. All you need is understanding of how excel works and how to use both the SUMIFS function along with the indirect formula, which together make excel usage easier than ever before. So if you want excel mastery, then get familiar with these two tools!