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

How to create video like this which software do you use

Great tip and these shorts are east to consume

Great Mike Thank you, it is very useful

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

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.

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

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

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.

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

Amazing short video 📹 👍

Great stuff Mike- shorts are Magic 👍

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

Thanks Mike!

Thanks Mike!

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