08 - Getting Data from Current Excel Workbook to Power Query

preview_player
Показать описание
In this video, I will show you how to get the data into your current workbook into Power Query.

When working with Power Query, your data needs to be in an Excel table, or at least be a named range.

#Excel #PowerQuery #ExcelTips
Рекомендации по теме
Комментарии
Автор

You really make my PQ learn so much easier, thank you for providing these amazing lectures, can't find any free lectures with quality like these series. Thank you :)

trongnghiaha
Автор

I follow a lot of PQ and Power BI courses from renowned lecturers on the web. This is the first time I have encountered such a clear, structured and, above all, LOGICAL lecture here. Congratulations and many thanks!

JarosawBorzecki
Автор

I swear, this is the most useful thing I've even found on the internet! You are amazing!!

pjkzs
Автор

Excellent presentation. Organized, to the point, well-explained. Thank you.

Swizzletwice
Автор

Sir, I can't thank you enough for the knowledge l gained from your videos...

silvestrecamposano
Автор

Absolutely wonderful! Clear, to the point and utterly useful. Subscribed!

corinesingfield
Автор

Excellent, very well explained, good demonstrations, and a nice speed. Thank you.

RaymondLowe
Автор

very informative course, you explained everything in very simple manner. Great sir love this course really

sunilkumar
Автор

Thank you sir for your free of cost training.

kamalgupta
Автор

Does Excel.Workbook work with .xls format?

siddharthjain
Автор

What is the best way to update the records in the source table/sheet directly form the Power Query ( like, adding records, deleting a record, Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?

mikelennon
Автор

How can you do power Query if you were using =Excel.Workbook to get from another workbook that is not current.

cliffclairespicyreviews
Автор

Hallo Sumit, so the conclusion is excel from other workbooks (not as range and table) would be loaded in PQ but not within the current file.

swapna_learner