Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses
Discover how to optimize your data handling in Excel using two powerful features: Text to Columns and External Data Import. Learn to efficiently manage complex data sets, overcome common issues like varying decimal and thousand separators, and even automate data refresh from web sources.
This video is a practical guide for anyone dealing with data exports from systems like SAP or Oracle, aiming to streamline their Excel workflow.
If you'd like to learn the newest version of this feature check out Power Query: https://youtu.be/EOhSODFLqic
Excel Features Explored:
▪️ Text to Columns: A step-by-step guide to split a single column of data into multiple columns efficiently, ideal for separating names, addresses, or any combined data.
▪️ Importing External Data (CSV/TXT files): Learn how to import structured data files into Excel, controlling decimal and thousand separators, and maintaining data integrity.
▪️ Auto-Refresh and Connections: Understand how to set automatic refresh intervals for your imported data, ensuring your Excel sheets always reflect the most current data from external sources.
▪️ Web Query for Online Data: An introduction to importing data directly from web sources into Excel, with options for setting automatic updates.
00:00 How To Properly Import Data to Excel
01:16 How To Use Text to Columns in Excel
03:27 How To Import Data from CSV / TXT files to Excel
09:52 How To Import Data from The Web to Excel
️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel