pletn.blogg.se

STEP 2: You will need to click on the following link and download the Power Query add-in from Microsoft’s website: Once you know this, close out of Excel completely! To check the bit version, you need to go and open any Excel workbook and go to File > Help and on the far right-hand side, you will see the Version and the bit number in brackets, either (32-bit) or (64-bit). STEP 1: The first step is to check the Excel bit version that you have on your PC. If you do not have this then you will need to upgrade to Office 365 using this link:

So goodbye VBA coding 🙂 🙂 🙂 So how do I get your hands on this super awesome add-in…I hear you say?įirst, you need to have Microsoft Office 2010 Professional Plus with Software Assurance. You can use Power Query to perform transformations that would be very complex in VBA or SQL. You have all that functionality in Power Query at the press of a menu command! Now your life has just become a lot…well, a hell of a lot easier 🙂Īpart from cleaning data, Power Query can append or merge two separate tables together (bye-bye VLOOKUP!) as well as create extra columns in your data that can display your custom calculations! So no more formulas, text to columns, trim spaces, vlookup, find & replace, etc. The best thing is that the next time you receive the same ugly file, all you need to do is press the Refresh button and your data will automatically be cleaned up and displayed the correct way! Well, Power Query accesses, cleans, and transforms all that messy data and displays it in a way that Excel loves and can work with. Well you know when you get data from a file, a data dump/import, or an external data source and it comes into Excel in an ugly, unworkable format? I can hear you say YEEEES! You can also take a look at CNET's list of the best Windows laptops.CLICK TO SEE THE TUTORIAL ON HOW TO INSTALL POWER QUERY IN EXCEL 2013 If you're looking for basic versions of each of these apps, the free version should work well for you.įor more productivity coverage, check out what Microsoft 365 Basic offers customers, all of the best features in Windows 11 and how to take screenshots in Windows 10 or 11. There are still benefits to the free version, including the ability to share links to your work and collaborate in real time, similar to what the Google Workspace (formerly G Suite) productivity tools allow. They also have fewer features than the full Microsoft 365 versions. You might be saying, "Wait a minute, if I can get all of those apps for free, why pay for Microsoft 365 in the first place?" The functionality of the free apps is limited, so they only run in your web browser and you can only use them while you're actively connected to the internet.

Screenshot by Alison DeNisco Rayome/CNET So what's the catch for the free version? Use the browser-based version of the Microsoft Word app for free.