Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know

) Introduction.
) List of Formula Elements.
) Discuss Different Formula Types.
) Examples of Modes of Formula Editing.
) Examples of the five Calculation Formula Types.
) Type #1: Relative and Absolute Cell References in Single Input-Output Formula.
) When you must use ROUND function.
) Use General Number Format as eraser to remove Number Formatting.
) Type #2: Dynamic Spilled Array Formulas.
) Spilled Range Operator for Dynamic Spilled Array Formulas.
) Type #3: Excel Table Formulas.
) Summary about SIOF, DSAF and TF formulas..
) Type #5: Aggregate Formulas.
) Type #4: Scalar Array Formulas.
) Style Formatting for Models.
) Compare Number Formats: Accounting, Currency and Number.
) Build Model #1: Sales & Expenses Budget.
) Build Model #2: Markup On Cost Pricing Formulas.
) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project.
) Build Model #4: Largest Profit for Each Product. Learn about functions: UNIQUE, SORT and MAXIFS.
) Look at Finance Cashflow Model to help pick investment.
) Look at Analytics Simulation Model to product risk of new project.
) Homework or practice problems.
) Conclusion.
) Closing and Video Links.