Count Files in Folder Using Excel? Power Query!!! Excel Magic Trick # Short 01

Learn how to use Power Query in Excel to cynamically count how many files are in a folder and list file names in the worksheet.
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp,

[nikoletahanakova]

I am in love, this channel never fails to amaze me and teach me something extraordinary I didn't know. You are an excellent teacher.

[PaulasPicks]

This is a pretty neat trick! I'll have to explore how to use it in my workflow. Thanks, Mike!

[rvgkrishna]

thank you for the short videos. we are loving it as usual💗💐💐

[canirmalchoudhary]

Great tip and these shorts are east to consume

[sledgehammer-productions]

I use this so much! Including a formula for getting the worksheets in Excel sheets.

[katerina]

Great Mike Thank you, it is very useful

[vlaroulette]

How can we get the properties of each file? Like size and file type, dates, duration etc?

[richardhay]

Shorts are a good thing! Welcome to the world of shorts!!

[Richard_Trap]

Dear Mike I have a discrepancy between the actual files and the files reported in Excel how can I change that?

[fatehmessikh]

How to create video like this which software do you use

[Michael_Alaska]

Hmmm... Seems like a neat trick, but even when removing several columns and only maintaining the name and location I get "Evaluation ran out of memory and can't continue" when loading; which does not seem reasonable. Using Excel 2019.