Download Excel File: https://excelisfun.net/files/03-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/03-M365ExcelClass.pdf
Topics in video:
1. (00:00) Introduction
2. (01:12) List of Formula Elements
3. (01:54) Discuss Different Formula Types
4. (05:16) Examples of Modes of Formula Editing
5. (07:35) Examples of the five Calculation Formula Types
6. (08:43) Type #1: Relative and Absolute Cell References in Single Input-Output Formula
7. (12:40) When you must use ROUND function
8. (15:34) Use General Number Format as eraser to remove Number Formatting
9. (16:56) Type #2: Dynamic Spilled Array Formulas
10. (19:35) Spilled Range Operator for Dynamic Spilled Array Formulas
11. (20:07) Type #3: Excel Table Formulas
12. (25:47) Summary about SIOF, DSAF and TF formulas.
13. (26:34) Type #5: Aggregate Formulas
14. (26:43) Type #4: Scalar Array Formulas
15. (28:40) Style Formatting for Models
16. (33:13) Compare Number Formats: Accounting, Currency and Number
17. (38:00) Build Model #1: Sales & Expenses Budget
18. (49:40) Build Model #2: Markup On Cost Pricing Formulas
19. (54:32) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project
20. (01:02:24) Build Model #4: Largest Profit for Each Product. Learn about functions: UNIQUE, SORT and MAXIFS
21. (01:09:12) Look at Finance Cashflow Model to help pick investment
22. (01:09:42) Look at Analytics Simulation Model to product risk of new project
23. (01:10:05) Homework or practice problems
24. (01:10:21) Conclusion
25. (01:10:50) Closing and Video Links