Download Excel File: https://excelisfun.net/files/EMT1683.xlsx
Learn how to create a multiplication table without the traditional Mixed Cell References, but instead use the new Microsoft 365 Excel Spilled Dynamic Array Formulas. Learn about Conditional Formatting a table, where Mixed Cell References are still required.
See formula fundamentals that ate used in many Excel Solutions such as Budgets and FV Financial Calculations.

Topics:
1. (00:00) Introduction to formula tables with column and row variables. Our Example is a multiplication Table that automatically expands and contracts.
2. (00:28) Look back to old method for building dynamic multiplication table.
3. (00:41) High Speed formula creation set to music.
4. (01:06) New Level of Easy.
5. (01:30) Examples of business tables with row and column variables.
6. (01:49) SEQUENCE Array Function.
7. (02:27) Spilled Range Operator: # Symbol
8. (03:02) Conditional formatting for row and column variables.
9. (04:28) Use Format Painter to apply Conditional Formatting. ISNUMBER function.
10. (05:00) Conditional formatting for inside for table.
11. (05:26) AND Logical Test to conditional format the perfect squares. Mixed Cell References Required.
12. (07:22) Summary and Video Links.

Excel Array Formulas, SEQUENCE Array Function, Spilled Range Operator, Pound Symbol. Expanding & Contracting Excel Multiplication Table with Conditional Formatting.