8 Tiny Excel Symbols That Replace Messy Formulas

Kenji Explains ยท Beginner ยท๐Ÿ“Š Data Analytics & Business Intelligence ยท3mo ago

About this lesson

8 Essential symbols you should know in Excel! ๐Ÿš€ Find all our courses here: https://www.careerprinciples.com/all-courses ๐Ÿ†“ DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/mocgk3vmts Most Excel users focus on formulas, but it's actually signs and symbols like a space, a tilde or even a dot that can completely change your results. These can prevent mistakes, simplify formulas, and even make them more flexible. So in this video, I'll show you 8 Essential symbols or signs to level up your Excel game! First is the dot operator which is used to remove zeros at the end of a formula. Second, the apostrophe so you can type in any type of data. Third, the space. Forth and fifth are the asterisk and the question mark, which allow you to look for specific types of values. Sixth is the tilde sign, also known as the approximate sign. In seventh, we have the dollar sign, which is used to fix references. And finally, in number eight, we have the ampersand. LEARN: ๐Ÿ‘‰ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance ๐Ÿ“ˆ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course ๐Ÿ”ฅ Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics ๐Ÿš€ All our courses: https://www.careerprinciples.com/all-courses โ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌ Chapters: 0:00โ€‹ -โ€‹ 1st Symbol 2:10โ€‹ - 2nd Symbol 3:35โ€‹ - 3rd Symbol (Very Unknown) 4:34โ€‹ - 4th Symbol (My Favorite) 6:07โ€‹ - 5th Symbol 7:51โ€‹ - 6th Symbol (Funny Scenario) 9:51โ€‹ - 7th Symbol (Most Important) 12:20โ€‹ - 8th Symbol (Most Versatile)

Original Description

8 Essential symbols you should know in Excel! ๐Ÿš€ Find all our courses here: https://www.careerprinciples.com/all-courses ๐Ÿ†“ DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/mocgk3vmts Most Excel users focus on formulas, but it's actually signs and symbols like a space, a tilde or even a dot that can completely change your results. These can prevent mistakes, simplify formulas, and even make them more flexible. So in this video, I'll show you 8 Essential symbols or signs to level up your Excel game! First is the dot operator which is used to remove zeros at the end of a formula. Second, the apostrophe so you can type in any type of data. Third, the space. Forth and fifth are the asterisk and the question mark, which allow you to look for specific types of values. Sixth is the tilde sign, also known as the approximate sign. In seventh, we have the dollar sign, which is used to fix references. And finally, in number eight, we have the ampersand. LEARN: ๐Ÿ‘‰ Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance ๐Ÿ“ˆ The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course ๐Ÿ”ฅ Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics ๐Ÿš€ All our courses: https://www.careerprinciples.com/all-courses โ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌ Chapters: 0:00โ€‹ -โ€‹ 1st Symbol 2:10โ€‹ - 2nd Symbol 3:35โ€‹ - 3rd Symbol (Very Unknown) 4:34โ€‹ - 4th Symbol (My Favorite) 6:07โ€‹ - 5th Symbol 7:51โ€‹ - 6th Symbol (Funny Scenario) 9:51โ€‹ - 7th Symbol (Most Important) 12:20โ€‹ - 8th Symbol (Most Versatile)
Watch on YouTube โ†— (saves to browser)
Sign in to unlock AI tutor explanation ยท โšก30

Related Reads

Up next
This could be the most perfect data frontend
Matt Williams
Watch โ†’