BeyondFormulas Modeling - 5. DATA ANALYSIS - 2. The best aggregation formula for analyzing data

** IN THIS LESSON: You'll use a range of aggregate, conditional summary and comparison formula to analyze a datasets ** ---------------------------------------------------------------------------------------------------------------- To take this full professional excel modeling course online: http://beyondformulas.com ---------------------------------------------------------------------------------------------------------------- The goals of this lesson are to: -- Use a range of aggregate, conditional summary and comparison formula to analyze a datasets. -- Learn how to create a list of unique values from a large dataset. -- Describe your data, to infer meaning and identify patterns that bring understanding and insight. Tools & Formulas: -- Aggregation formula (SUM, AVERAGE, MEDIAN, COUNT, COUNTA, COUNTBLANK, MAX, MIN, STD DEV) -- Conditional aggregation (SUMIF/S, AVERAGEIF/S, COUNTIF/S) -- Comparison (RANK, PERCENTILERANK, PERCENTILE, SMALL, LARGE)