MS 365 Excel Basics 07: Comprehensive Excel Formula Lesson To Become The Go-To Excel Guru!

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics07.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics07.pdf
In this video learn about.
Topics:
1. (00:00) Introduction
2. (00:39) Topics
3. (02:05) Starting a worksheet formula
4. (02:17) What formula do
5. (02:37) Keyboard shortcuts are fast
6. (03:21) How default alignment helps
7. (05:12) Number Formatting
8. (05:28) Formulas & Number Formatting
9. (07:11) Excel’s Golden Rule
10. (12:09) Formula elements
11. (12:37) Cell References
12. (12:52) Formula to “List products that each employee sold last week” (Relative and Absolute Cell References)
13. (15:15) TEXTJOIN function
14. (16:09) Conditionally format a row with a logical formula with Mixed Cell References
15. (16:48) What is a Mixed Cell Reference?
16. (23:00) Operators and order of operations & Formulas to Illustrate!
17. (26:15) Evaluate Formula Tool
18. (29:58) Types of Formulas: Data Type: Text, Number, Logical
19. (31:00) TEXTAFTER and TEXTBEFORE functions
20. (31:30) What happens to XLOOKUP when it uses a Text Number to lookup a Number? And how to fix it.
21. (31:55) Convert text numbers to numbers with Math Operator
22. (34:56) Types of Formulas: Calculation Type: Single Input-Output, Dynamic Spilled Array, Excel Table Formulas, Scalar Array. WHEN AND WHY TO USE EACH TYPE!!
23. (40:14) Excel Tables and Excel Table Formulas
24. (47:16) Build a Budget with Dynamic Spilled Array Formulas
25. (53:00) Rounding numbers with ROUND, MROUND. CEILING.MATH, and FLOOR.MATH
26. (58:44) Date and Time Number Formatting and Formulas
27. (01:03:46) Modes Of Cell Editing
28. (01:05:46) 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. (01:18:41) Lookup Functions
30. (01:23:16) Errors
31. (01:25:15) Summary
32. (01:25:58) Homework – Practice Problems for you!
33. (01:26:04) Closing

excelisfunMon, January 6, 2025 2:11pm