Completed
22. Types of Formulas: Calculation Type: Single Input-Output, Dynamic Spilled Array, Excel Table Formulas, Scalar Array. WHEN AND WHY TO USE EACH TYPE!!
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Comprehensive Excel Formula Guide - MS 365 Excel Basics - Lesson 7
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Topics
- 3 3. Starting a worksheet formula
- 4 4. What formula do
- 5 5. Keyboard shortcuts are fast
- 6 6. How default alignment helps
- 7 7. Number Formatting
- 8 8. Formulas & Number Formatting
- 9 9. Excel's Golden Rule
- 10 10. Formula elements
- 11 11. Cell References
- 12 12. Formula to “List products that each employee sold last week” Relative and Absolute Cell References
- 13 13. TEXTJOIN function
- 14 14. Conditionally format a row with a logical formula with Mixed Cell References
- 15 15. What is a Mixed Cell Reference?
- 16 16. Operators and order of operations & Formulas to Illustrate!
- 17 17. Evaluate Formula Tool
- 18 18. Types of Formulas: Data Type: Text, Number, Logical
- 19 19. TEXTAFTER and TEXTBEFORE functions
- 20 20. What happens to XLOOKUP when it uses a Text Number to lookup a Number? And how to fix it.
- 21 21. Convert text numbers to numbers with Math Operator
- 22 22. Types of Formulas: Calculation Type: Single Input-Output, Dynamic Spilled Array, Excel Table Formulas, Scalar Array. WHEN AND WHY TO USE EACH TYPE!!
- 23 23. Excel Tables and Excel Table Formulas
- 24 24. Build a Budget with Dynamic Spilled Array Formulas
- 25 25. Rounding numbers with ROUND, MROUND. CEILING.MATH, and FLOOR.MATH
- 26 26. Date and Time Number Formatting and Formulas
- 27 27. Modes Of Cell Editing
- 28 28. Logical Tests in Formulas: SUMIFS, COUNTIFS, IF, AND, OR, ISNUMBER functions and many more logical formulas, including the three types of formulas where comparative operators are used.
- 29 29. Lookup Functions
- 30 30. Errors
- 31 31. Summary
- 32 32. Homework – Practice Problems for you!
- 33 33. Closing
