Learn 8 hidden Excel features you probably didn't know.
Take our Excel course: https://www.careerprinciples.com/cour...
DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.co...
Microsoft Excel has released hundreds of new features over the years, so it's easy to miss their best ones. That's why, in this video, I've put together 8 of their best features you probably didn't know. First, we've got the live web data feature to import live data from the internet. Then we have the search feature to find anything on Excel. Third, we have the textsplit and textbefore/textafter formulas. Fourth, we have dynamic charts in Excel. Fifth, we have sparklines. Sixth, we have the image to text feature to convert any image into data inside Excel. Seventh, we have the go to special feature detect specific types of cells such as blanks or those with notes. Finally, we have the navigation pane, which is a table of contents inside Excel.
LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/cour...
The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
All our courses: https://www.careerprinciples.com/courses
SOCIALS:
Instagram https://www.instagram.com/careerprinc...
TikTok / career_principles
LinkedIn / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 Live Web Data
1:20 Search Feature
2:03 TextSplit Formula
3:33 Dynamic Charts
6:26 Trendlines
7:45 Image to Text
8:42 Go to Special
9:50 Table of Contents in Excel