Stop Copy Pasting Into Excel! Try the NEW Import Functions Instead

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

About this lesson

๐Ÿ‘‰ Try EasyMorph for FREE here: https://easymorph.com/download.html In this video, we go over the new IMPORTCSV and IMPORTTEXT functions in Excel. 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 Excel recently released 2 brand new import functions, IMPORTCSV and IMPORTTEXT, making it way easier to bring data into Excel. In this video we'll go over how each function works, how we can combine them with other formulas, and real world use cases you can start using today. First, Import CSV lets you import any CSV file into Excel just using the file path. Second, import text allows you to import not just CSV files but also TXT or TSV with further customization like delimiters to separate columns. Once we understand these two functions, we can learn how to combine multiple CSV files with IMPORTCSV and VSTACK. We can also use the CHOOSECOLS function to filter by column. Finally, you learn how to create a mini dashboard where we only see the transactions over the past five days. For this, we'll combine the filter function with IMPORTCSV, CHOOSECOLS, and the TODAY function. โ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌ Chapters: 0:00โ€‹ -โ€‹ IMPORTCSV 2:15โ€‹ - IMPORTTEXT 4:09โ€‹ - Alternative to Formulas 5:22โ€‹ - Combine Multiple CSV Files 7:11โ€‹ - Column Filter 7:45โ€‹ - Mini-Dashboard

Original Description

๐Ÿ‘‰ Try EasyMorph for FREE here: https://easymorph.com/download.html In this video, we go over the new IMPORTCSV and IMPORTTEXT functions in Excel. 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 Excel recently released 2 brand new import functions, IMPORTCSV and IMPORTTEXT, making it way easier to bring data into Excel. In this video we'll go over how each function works, how we can combine them with other formulas, and real world use cases you can start using today. First, Import CSV lets you import any CSV file into Excel just using the file path. Second, import text allows you to import not just CSV files but also TXT or TSV with further customization like delimiters to separate columns. Once we understand these two functions, we can learn how to combine multiple CSV files with IMPORTCSV and VSTACK. We can also use the CHOOSECOLS function to filter by column. Finally, you learn how to create a mini dashboard where we only see the transactions over the past five days. For this, we'll combine the filter function with IMPORTCSV, CHOOSECOLS, and the TODAY function. โ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌโ–ฌ Chapters: 0:00โ€‹ -โ€‹ IMPORTCSV 2:15โ€‹ - IMPORTTEXT 4:09โ€‹ - Alternative to Formulas 5:22โ€‹ - Combine Multiple CSV Files 7:11โ€‹ - Column Filter 7:45โ€‹ - Mini-Dashboard
Watch on YouTube โ†— (saves to browser)
Sign in to unlock AI tutor explanation ยท โšก30

Related Reads

๐Ÿ“ฐ
Por quรฉ el "precio de lista" de una tienda no vale nada (y cรณmo construimos un tracker honesto)
Learn why list prices in stores are often misleading and how to build a tracker to monitor honest prices, applying data analysis and programming skills to make informed purchasing decisions.
Dev.to ยท Edu Tor
 ๐Ÿ“ฐ
FDA Recall API: A Working Guide to openFDA Enforcement
Learn to navigate the openFDA Enforcement API to retrieve drug, device, and food recall data, overcoming common issues like the 26,000-record skip wall and silent OR bug
Dev.to ยท Mayd-It
 ๐Ÿ“ฐ
Common Mistakes New Data Engineers Make (And How to Avoid Them)
Learn to avoid common mistakes new data engineers make to improve data pipeline efficiency and reliability
Dev.to ยท Abhishek Konagalla
 ๐Ÿ“ฐ
DuckDB vs PostgreSQL: I Ran the Same Query on Both. One Finished in 12ms. The Other Timed Out.
Compare DuckDB and PostgreSQL performance by running the same query on both to determine when to use each database system
Medium ยท Programming
Up next
How to Prompt Your LLM Directly from SQL
Ian Wootten
Watch โ†’