Completed
min) AGGREGATE and ROWS functions and 'expandable range' to extract bottom 3.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics
Automatically move to the next video in the Classroom when playback concludes
- 1 min) Excel's Golden Rule.
- 2 min) Formula Elements.
- 3 min) Math Operators.
- 4 min) Comparative Operators.
- 5 min) Types of Formulas.
- 6 min) How Formulas Calculate: Order of Precedence in Excel.
- 7 min)Number Formatting is a Façade.
- 8 min) Default Alignment in Excel.
- 9 min)16 formula examples of formula elements and formula types.
- 10 min) LARGE and ROWS functions and 'expandable range' to extract Top .
- 11 min) SMALL and COLUMNS functions and 'expandable range' to extract bottom 3.
- 12 min) AGGREGATE and ROWS functions and 'expandable range' to extract bottom 3.
- 13 min) 10 Examples of INDEX and MATCH functions.
- 14 min) SUMIFS to add with two criteria.
- 15 min) Advantage of formulas over other Excel features such as Filter and PivotTables.
