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

Dive into an extensive 71-minute video tutorial on Excel worksheet formulas and models. Explore various formula types, including relative and absolute cell references, dynamic spilled array formulas, and Excel table formulas. Learn essential functions like ROUND, UNIQUE, SORT, and MAXIFS. Practice building practical models for sales budgets, markup pricing, project time calculations, and profit analysis. Gain insights into style formatting, number formats, and advanced financial and analytical models. Download accompanying Excel and PDF files for hands-on practice and reinforce your learning with provided homework problems.

) 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.