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.

If you click This Mac, you’ll see the same query performed against the entire set of locally indexed files, which will include database files and other documents used for system and app purposes that you never need to know have changed and with which you don’t interact.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! That limits the scope to document types in common locations instead of files found everywhere on your Mac. Note that above the query, the Spotlight constraint will show “Search: This Mac Shared,” where Recents is selected. Name the search query All My Files, and check the box to put it in the Sidebar.Click the Date Modified column to sort them from newest to oldest.In the field next to Raw Query, enter exactly the following: (kMDItemFSName='*.*').From the gear menu, select Show Search Criteria.In the Finder, open a new folder and click the Recents item in the Sidebar.

This language lets you specify a search parameter that’s not available through a preset popup menu selection in Smart Folders in the Finder. Spotlight has an underlying “raw query” language for which Apple With those provisos, here’s how you do it.

Outlook for mac raw query