Excel Statistical Analysis - Comprehensive Worksheet Formula & Model Building

) Introduction.
) Topics in video.
) Worksheet Formula Elements: what can go into a formula.
) Excel Formula Order of Operations.
) Guidelines for building Excel Worksheet Formula Models.
) Number Formatting as a Façade and how it can lead to misleading models if it is not understood.
) The power of General Number Formatting as an eraser, including keyboard shortcut.
) When you must use the ROUND function rather than Number Formatting.
) Excel’s Golden Rule.
) Building an Excel Worksheet Formula Model.
) ISNA and FORMULATEXT functions to document model..
) Summary of Formula Types.
) Example of Number, Text and Logical Formulas.
) Example of Aggregate Formula and Single Input-Output Formula. Using AVERAGE, COUNT, COUNTA and ROWS functions..
) 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..
) Example of Relative and Absolute Cell References. This is the Old School way to make formulas.
) Dynamic Spilled Array Formula. This new school method is MUCH easier than the older methods.
) Three reasons Dynamic Spilled Array Formula are more efficient than the old methods.
) Second example of Dynamic Spilled Array Formula, including Spilled Range Operator #.
) Example of Scalar Array Formula.
) How Excel Table Column Formulas are different than Single Input-Output Formulas and Dynamic Spilled Array Formulas..
) % of Total and % Change Formulas. Dynamic Spilled Array Formula and Old School Methods..
) Video Summary.
) Conclusion and Video Links.