how to get power query in excel 2016 mac

It’s not that it can connect to almost any data source, even data sitting on a webpage.Because do you want to know the best part of Power Query? Need to send a dashboard to your boss or colleague?Īh, we finally return to that magic refresh button.

In that spirit, it’s time for you to trade in your horse & buggy and enter the Excel fast lane. I swear, using Power Query must be the same feeling people had 100 years ago when they drove a car for the first time. Today, these students and thousands more are saving hours each day thanks to Power Query. What if the data is in a text file which has more data rows than Excel can handle?.Each time you receive new data you must repeat the copy/paste over and over and over and over….It’s too easy to make a mistake and leave data behind (Repeat after me: “No data left behind!”).It’s frustrating, especially if you’re dealing with multiple sheets and workbooks.Is copying and pasting your method of choice? It makes sense.Īfter all, a quick Ctrl-c and Ctrl-v and voilà! Everything is perfect, right?Ĭopying and pasting is fraught with problems: “My gosh, it’s even worse than I thought.”

You stare at the file the same way you stare at that closet you haven’t cleaned in seven years. “Thanks! Will have you those reports asap!” You reply to your colleague through gritted teeth: Is there anything that spikes your blood pressure more than being sent a massive data file you’ll need hours to clean?

How to get power query in excel 2016 mac