Completed
) Build Model #1: Sales & Expenses Budget
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) List of Formula Elements
- 3 ) Discuss Different Formula Types
- 4 ) Examples of Modes of Formula Editing
- 5 ) Examples of the five Calculation Formula Types
- 6 ) Type #1: Relative and Absolute Cell References in Single Input-Output Formula
- 7 ) When you must use ROUND function
- 8 ) Use General Number Format as eraser to remove Number Formatting
- 9 ) Type #2: Dynamic Spilled Array Formulas
- 10 ) Spilled Range Operator for Dynamic Spilled Array Formulas
- 11 ) Type #3: Excel Table Formulas
- 12 ) Summary about SIOF, DSAF and TF formulas.
- 13 ) Type #5: Aggregate Formulas
- 14 ) Type #4: Scalar Array Formulas
- 15 ) Style Formatting for Models
- 16 ) Compare Number Formats: Accounting, Currency and Number
- 17 ) Build Model #1: Sales & Expenses Budget
- 18 ) Build Model #2: Markup On Cost Pricing Formulas
- 19 ) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project
- 20 ) Build Model #4: Largest Profit for Each Product. Learn about functions: UNIQUE, SORT and MAXIFS
- 21 ) Look at Finance Cashflow Model to help pick investment
- 22 ) Look at Analytics Simulation Model to product risk of new project
- 23 ) Homework or practice problems
- 24 ) Conclusion
- 25 ) Closing and Video Links
