Welcome to ๐๐ฅ๐ข๐๐ค ๐๐ง๐ ๐๐ง๐๐ฅ๐ฒ๐ฌ๐ โ ๐๐ฑ๐๐๐ฅ ๐๐๐๐ซ๐ง๐ข๐ง๐ ๐๐๐ซ๐ข๐๐ฌ! ๐ In this lesson, we will cover two powerful topics in Excel that every one must know: โ ๐๐๐ฑ๐ญ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง๐ฌ ๐ข๐ง ๐๐ฑ๐๐๐ฅ UPPER() โ Convert text to ALL CAPS LOWER() โ Convert text to lowercase PROPER() โ Capitalize the first letter of each word โ ๐๐๐ฅ๐ฅ ๐๐๐๐๐ซ๐๐ง๐๐๐ฌ ๐ข๐ง ๐๐ฑ๐๐๐ฅ ๐๐๐ฅ๐๐ญ๐ข๐ฏ๐ ๐๐๐๐๐ซ๐๐ง๐๐ (changes when copied) ๐๐๐ฌ๐จ๐ฅ๐ฎ๐ญ๐ ๐๐๐๐๐ซ๐๐ง๐๐ (fixed with $) ๐๐ข๐ฑ๐๐ ๐๐๐๐๐ซ๐๐ง๐๐ (partially fixed) These concepts are the foundation for creating accurate and flexible formulas in Excel. By the end of this lesson, you will clearly understand how to use these functions and references in real examples. ๐ Donโt forget to๐๐ข๐ค๐, ๐๐ก๐๐ซ๐ & ๐๐ฎ๐๐ฌ๐๐ซ๐ข๐๐ for more Excel tutorials from scratch! ๐ Click the bell icon to get notified about the upcoming lessons. #๐๐ฑ๐๐๐ฅ #๐๐ฑ๐๐๐ฅ๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ #๐๐ฅ๐ข๐๐ค๐๐ง๐๐๐ง๐๐ฅ๐ฒ๐ฌ๐ #๐๐ฑ๐๐๐ฅ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง๐ฌ #๐๐ฑ๐๐๐ฅ๐ ๐จ๐ซ๐๐๐ ๐ข๐ง๐ง๐๐ซ๐ฌ