Download Excel File: https:\/\/excelisfun.net\/files\/03-M365ExcelClass.xlsx<\/a> Download PDF File: https:\/\/excelisfun.net\/files\/03-M365ExcelClass.pdf<\/a> 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 […]<\/p>\n","protected":false},"author":3,"featured_media":4193,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2022\/07\/AUYagm4ZA7M.jpg?fit=480%2C360&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-15C","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4192"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=4192"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4192\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/4193"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=4192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=4192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=4192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nTopics in video:
\n1. (00:00) Introduction
\n2. (01:12) List of Formula Elements
\n3. (01:54) Discuss Different Formula Types
\n4. (05:16) Examples of Modes of Formula Editing
\n5. (07:35) Examples of the five Calculation Formula Types
\n6. (08:43) Type #1: Relative and Absolute Cell References in Single Input-Output Formula
\n7. (12:40) When you must use ROUND function
\n8. (15:34) Use General Number Format as eraser to remove Number Formatting
\n9. (16:56) Type #2: Dynamic Spilled Array Formulas
\n10. (19:35) Spilled Range Operator for Dynamic Spilled Array Formulas
\n11. (20:07) Type #3: Excel Table Formulas
\n12. (25:47) Summary about SIOF, DSAF and TF formulas.
\n13. (26:34) Type #5: Aggregate Formulas
\n14. (26:43) Type #4: Scalar Array Formulas
\n15. (28:40) Style Formatting for Models
\n16. (33:13) Compare Number Formats: Accounting, Currency and Number
\n17. (38:00) Build Model #1: Sales & Expenses Budget
\n18. (49:40) Build Model #2: Markup On Cost Pricing Formulas
\n19. (54:32) Build Model #3: Date & Time Formulas & Number Formatting to calculate total days and total time for a work project
\n20. (01:02:24) Build Model #4: Largest Profit for Each Product. Learn about functions: UNIQUE, SORT and MAXIFS
\n21. (01:09:12) Look at Finance Cashflow Model to help pick investment
\n22. (01:09:42) Look at Analytics Simulation Model to product risk of new project
\n23. (01:10:05) Homework or practice problems
\n24. (01:10:21) Conclusion
\n25. (01:10:50) Closing and Video Links<\/p>\n","protected":false},"excerpt":{"rendered":"