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

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) Continue reading “MS 365 Excel Basics 07: Comprehensive Excel Formula Lesson To Become The Go-To Excel Guru!”

Highline College Excel Corporate Finance ACCTG 455 Class 2025 Winter by Mike “excelisfun” Girvin

This class is for matriculating students at Highline College, but videos and files are free at YouTube in this playlist: https://www.youtube.com/watch?v=cSs9jYudZBQ&list=PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4

Videos (both old from 2010 and new ones for MS 365 Excel) to be posted over next three months.

Topics:
Chapter 1: Introduction
Chapter 2: Financial Statements
Chapter 3: Working with Financial Statements
Chapter 4: Time Value of Money and Valuation
Chapter 5: Discounted Cash Flow Valuation
Chapter 6: Interest Rates & Bond Valuation
Chapter 7: Equity Markets & Stock Valuation
Chapter 8: NPV & Other Investment Criteria
Chapter 9: Capital Investment
Chapter 10: Some Lessons from Capital Market History
Chapter 11: Risk & Return

Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868

Download Excel File: https://excelisfun.net/files/EMT1868.xlsx
Learn how to detect what hidden characters are causing N/A! Errors In XLOOKUP And VLOOKUP And Fix It!
Many functions in this video: CODE, CHAR, RIGHT, TRIM, LOOKUP, XLOOKUP, ARRAYTOTEXT, REDUCE, LAMBDA, SUBSTITUTE, REGEXREPLACE, REGEXTEST, UNICODE, and more!
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction.
2. (00:27) Using XLOOKUP and getting an #N/A Error.
3. (01:12) What cause #N/A? Hidden characters that are unknown.
4. (01:40) Check for hidden characters at end of lookup value with RIGHT & CODE function to check.
5. (02:29) Lookup Ascii codes to figure out what it is? LOOKUP function.
6. (03:42) TRIM to Continue reading “Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868”

Determine What Causes N/A! Errors In XLOOKUP &VLOOKUP & Fix It! Hidden Characters Problem. EMT 1868

Download Excel File: https://excelisfun.net/files/EMT1868.xlsx
Learn how to detect what hidden characters are causing N/A! Errors In XLOOKUP And VLOOKUP And Fix It! I answer the question: Can you use SUBSTITUTE for many values without nesting? The answer is yes!
Learn how to get the SUBSTITUTE function to replace more than one value! Other ways to phrase this issue:
Multiple Replacements with Excel
Substitute multiple values
SUBSTITUTE function with dynamic array
Excel substitute function array of substitute values
Excel: find and replace multiple values at once
Excel substitute multiple sub text strings with one formula
Excel – Can you use SUBSTITUTE for many values without nesting?
Many functions Continue reading “Determine What Causes N/A! Errors In XLOOKUP &VLOOKUP & Fix It! Hidden Characters Problem. EMT 1868”

Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter by Mike “excelisfun” Girvin

For matriculating students at Highline College, but videos and files free at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo

Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter taught by Mike “excelisfun” Girvin