Introduction to Power Query (Get & Transform Data) in Microsoft Excel! Want to understand what Power Query is all about? You can easily use Power Query (Get & Transform Data) in Microsoft Excel with this tutorial.

Excel Power Query is one of the most powerful new features within Microsoft Excel and the easiest to learn.

It was first introduced as an Excel add-in in 2013 and was then made available in Excel 2010. In Excel 2016 it was renamed to Get & Transform and was available (without using an add-in) under the DATA tab in the ribbon menu. In Excel 2019, it will be renamed to Power Query once again!

You can use Power Query to clean & transform your data that you download from your ERP or accounting system and display it in a report for Excel to work with.

The best thing is that you can reapply the same transformation steps in just ONE single click, saving you HOURS! So next week when you get the same report with updated data, a simple REFRESH will transform your data once again!
------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 Microsoft Excel video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...
Join Now ► [ Ссылка ]

📚 Download Our Free 101 Excel Tips & Tricks E-Book: [ Ссылка ]

💻 [Free Excel Masterclass] Advance Your Excel Level Within 30 Days: [ Ссылка ]

🔥 OUR BEST EXCEL RESOURCES 🔥
101 Most Popular Formulas E-Book: [ Ссылка ]
101 Ready To Use Macros E-Book: [ Ссылка ]
101 Most Popular Formulas Paperback on Amazon: [ Ссылка ]
101 Ready To Use Macros Paperback on Amazon: [ Ссылка ]
101 Best Excel Tips & Tricks Paperback on Amazon: [ Ссылка ]

👷 Excel Consulting Services: [ Ссылка ]

💻 Looking for more Microsoft Excel tutorials for beginner videos? Check out this playlist: [ Ссылка ]
------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)


Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
[ Ссылка ]

❤️ Let’s connect on social ❤️
LinkedIn: [ Ссылка ]
Instagram: [ Ссылка ]
Pinterest: [ Ссылка ]
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]

#MyExcelOnline

свернуть