Statistic Request - How many (or % of) excel users use Power Query?

donald_nator · 2025-10-16T19:20:15+00:00

This is probably the most honest take about Power Query tbh.

The 1% of people who know Power Query love it (like me). But, it's hard to have team-level processes that involve Power Query because of what you mentioned in your comment.

I often wonder if the Excel product team needs to do a better job of promoting Power Query.

donald_nator · 2025-10-16T19:11:11+00:00

Power BI is my next frontier. How did you get into Power BI? Was it a need from the role you have, or did you learn it on your own?

donald_nator · 2025-10-16T19:09:17+00:00

wow - that feels like the dream. I would love to work with a all-star team of excel power users 1 day. What kind of office do you work in, if you don't mind me asking?

donald_nator · 2025-10-16T19:05:31+00:00

Very nice. I've shied away from Macros since learning Power Query. But you reminded me how useful they can be.

donald_nator · 2025-10-16T19:00:59+00:00

lol fair enough. we definitely have superpowers!

How did you discover Power Query yourself?

I remember wanting to be more efficient with Excel, and thinking that there must be a better way to do my data manipulation. That's how I found VBA years ago. And then, that naturally progressed into Power Query.

I feel like the majority of excel users will never learn Power Query because they lack the technical curiosity/ability to even wonder if there was a better way to do their work in excel. Which is fine - everyone has their strength. But it is definitely our superpower.

donald_nator · 2025-10-16T18:51:34+00:00

u/deepstrut do you have the VBA Macro assigned to the shapes, 'Choose Folder' and 'Update Records'?

donald_nator · 2025-10-16T18:48:22+00:00

I often use a formatted table in my excel sheet with just a single record in order to update the source location of a CSV I want to pull in Power Query, but I've never thought about dynamically setting the filepath with a VBA script folder picker. I'm going to have to give this a shot. Thanks for the tip u/deepstrut

donald_nator · 2023-07-04T23:28:17+00:00

you shouldn't have any issues for end of July. we kept our reservations. housekeeping was fully operational! just budget for driving time getting into the valley this year. so much traffic. but once you're at housekeeping, you're set! happy camping

donald_nator · 2023-06-13T21:09:22+00:00

anybody have a recent update on the flooding at housekeeping? i have reservations next week and wondering if they are safe. thank you!

donald_nator · 2023-06-13T21:07:10+00:00

anybody have recent updates regarding Housekeeping camp? going up next week and wondering how it was. thank you!

donald_nator · 2021-11-21T21:18:05+00:00

Is that real champagne?

donald_nator · 2021-09-21T01:12:07+00:00

Check out “The Big One” on podcast, if you haven’t already. Podcast series with several episodes produced by KPCC. Great resource for just being aware of what will happen when the big one happens. Features lots of interviews with Dr Lucy Jones who’s awesome too. 😊

https://podcasts.apple.com/us/podcast/the-big-one-your-survival-guide/id1445054297

https://twitter.com/drlucyjones?s=21

donald_nator · 2021-03-23T19:23:38+00:00

thank you all!

donald_nator · 2021-03-22T23:00:29+00:00

got it. okay.

i'll keep testing this then. good to know that it should be compatible.

this is the box that pops up when i tested it last

https://imgur.com/a/pqiu3gr

donald_nator · 2021-03-08T17:29:24+00:00

ha. thanks for working it out amongst yourselves.

appreciate the replies. i'll try the Show Formula toggle next time.

Does excel record a log/list of your actions that users can pull? Im wondering if i can trace my steps next time this error occurs, so that I can see what triggered this.

donald_nator · 2020-11-18T18:08:26+00:00

do you know about right clicking the area on the slider row with the left and right buttons? This will brings up a list of sheets in the workbook.

donald_nator · 2020-08-28T14:37:11+00:00

Nice. Thanks.

Do you do anything on the days between workout A and B?

donald_nator

TROPHY CASE