Completed
3. Starting a worksheet formula
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
