6/29/2023 0 Comments Excel power query tutorial pdfI thought to myself “ I don’t work in a world of dirty data, I don’t spend hours cleaning and fixing data problems. Ken Puls, Mynda Treacy, Oz du Soliel were all talking about how amazing Power Query is. I noticed that more and more Excel experts were talking about it. The irony being that had I looked into PowerQuery at that moment it would have saved me so much time. I’ve got VBA I can do everything I need in VBA. My first thought was “ Sounds like too much effort it’ll probably be rubbish anyway. Then I heard it was an additional add-in I had to install. I can’t remember the first time I heard about Power Query, but I do remember it was in the same breath as Power Pivot. The party I’m referring to is the group of people who already know and love Power Query (or Get & Transform as it’s known in Excel 2016 and later). Sounds like a nice party, right? You’re starting to wish you were there too, aren’t you? The good news is… you’ve been invited. They were just pleased that I was there and excited to tell me about everything that was going to happen. When I finally arrived, rather than the usual “ What time do you call this?“, I received the “ Hey you made it, that’s amazing. The party would already be in full swing I was going to be late.
0 Comments
Leave a Reply. |