This week, I have been watching educational videos on YouTube about Excel Power Query. My wife thinks it is insanely boring, but I am learning things that are going to be very useful at work.
Power Query is a feature of Excel I have used sporadically for the last five years to pull data in from SQL Server. I recently discovered that I barely scratched the surface of what it can do. It could probably save me a ton of time on some of my data analysis projects.
What’s funny to me is that I didn’t even know these functionalities were where, hiding in the Data tab behind some boring-looking buttons.