Completed
) Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Spreadsheet Formulas - Old School or Dynamic Arrays?
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Excel Spreadsheet Formulas Uses in Data Analysis
- 3 ) Change Default Settings for Table Formula Nomenclature (Structured References).
- 4 ) Cell References in Formulas.
- 5 ) Excel Functions to Make Calculations Based on one Condition, four examples:
- 6 ) SUMIFS Function with One Condition shown on next page in cell H13
- 7 ) SUMIFS Function with One Condition & Dynamic Array shown on next page in cell K13
- 8 ) COUNTIFS Function with One Condition shown on next page in cell H24
- 9 ) COUNTIFS Function with One Condition & Dynamic Array shown on next page in cell K24
- 10 ) Excel Functions to Make Calculations Based on an AND Logical Text.
- 11 ) SUMIFS for Summary Report Based on Adding, Old School Cell References and Dynamic Arrays.
- 12 )AVERAGEIFS for Summary Report Based on Averaging, Old School Cell References and Dynamic Arrays.
- 13 ) COUNTIFS for Summary Report Based on Counting, Old School Cell References and Dynamic Arrays.
- 14 ) Homework sheets.
- 15 ) Summary