Completed
) Guidelines for building Excel Worksheet Formula Models
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
