Automate Copy-Pasting in Excel With This Simple Trick

Stop Manually Copy Pasting in Excel. Try this Power Query feature instead. 🚀 FREE 50 Excel Hacks Template from Hubspot: https://clickhubspot.com/093k 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/courses Are you often copy pasting data in Excel? Whether that's from one sheet to another like consolidating monthly data into annual data, or copying website data to an excel file, there's actually a better, automated solution with Power Query, I teach you with 5 practical examples. First, I'll show you how to automate copy pasting in Excel with Power Query's "Get Data" button. With this, you can automatically consolidate all the Excel files in one folder. For example, if you have 3 Excel files for January, February, and March in one folder, these can get copied automatically into one "total year" excel file. Additionally, if you add new files to the folder, those will also get included in the "total year" excel file. Same thing goes for any updates to the Excel files inside the folder. That's just one example, we'll also have some for creating a live connection with data from the internet, like a sports team table, or with stock prices. We'll also show how to import PDF files, images, and much more! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Copying Several Excel Files 4:23​ - Importing Live Web Data 5:59​ - Market Data 8:02​ - PDF to Excel 9:21​ - Image to Excel