Completed
) Example of Relative and Absolute Cell References. This is the Old School way to make formulas
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - Comprehensive Worksheet Formula & Model Building
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Topics in video
- 3 ) Worksheet Formula Elements: what can go into a formula
- 4 ) Excel Formula Order of Operations
- 5 ) Guidelines for building Excel Worksheet Formula Models
- 6 ) Number Formatting as a Façade and how it can lead to misleading models if it is not understood
- 7 ) The power of General Number Formatting as an eraser, including keyboard shortcut
- 8 ) When you must use the ROUND function rather than Number Formatting
- 9 ) Excel’s Golden Rule
- 10 ) Building an Excel Worksheet Formula Model
- 11 ) ISNA and FORMULATEXT functions to document model.
- 12 ) Summary of Formula Types
- 13 ) Example of Number, Text and Logical Formulas
- 14 ) Example of Aggregate Formula and Single Input-Output Formula. Using AVERAGE, COUNT, COUNTA and ROWS functions.
- 15 ) Examples of Dynamic Spilled Array Formulas (only available in Microsoft 365 Excel). Compare and contrast this new school way of making formulas with the old school way.
- 16 ) Example of Relative and Absolute Cell References. This is the Old School way to make formulas
- 17 ) Dynamic Spilled Array Formula. This new school method is MUCH easier than the older methods
- 18 ) Three reasons Dynamic Spilled Array Formula are more efficient than the old methods
- 19 ) Second example of Dynamic Spilled Array Formula, including Spilled Range Operator #
- 20 ) Example of Scalar Array Formula
- 21 ) How Excel Table Column Formulas are different than Single Input-Output Formulas and Dynamic Spilled Array Formulas.
- 22 ) % of Total and % Change Formulas. Dynamic Spilled Array Formula and Old School Methods.
- 23 ) Video Summary
- 24 ) Conclusion and Video Links
