Analyzing a specific subset of the dataset - Illustrating Excel TABLES
Channel: Dr. Baker SDSU Marketing
Date: 2020-07-28

Sometimes the dataset we are provides is TOO much... our analysis may only require us to focus on a subset of the whole.  In this video, we show how to use Excel TABLES to select just a subset of the data.  We also explain why Excel TABLES can possibly cause unexpected issues later, so we demonstrate a workaround to that problem.Conceptual reasons for needing only a subset of data (minute 0:01)Excel Example: An overview of our gameplan  (minute 1:08)Excel example (minute 2:27)... illustrating Excel TABLES