Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

How to Find Out Bit Version of Excel


In this post I will explain you how to find out bit version of excel.
First, open the Excel application.

Choose blank workbook.
So new workbook will be created. then click on the  file menu.



















Then click “Account”.





























Next click the “About Excel” button.



















Another window will open showing the details of your office version.
Bit version will shown at top.

How to Add Power Query to Excel Ribbon


In this post I will show you how to add  power query to Excel ribbon.

First, open the Excel application. Choose blank workbook.






















So new workbook will be created. then click on the file menu.

















Then click on the options.





























Then Excel options window will pop up. Click on Add-Ins
























Then select “Microsoft Power Query for Excel” and click OK.
























 Power Query tab will added to the Excel ribbon.














If "Microsoft Power Query for Excel" is not listed in Add-Ins list then you can download it from Microsoft website.

Search google for the Power Query



















Go to the download page. And click on the download button.

















Then select the apropriate file to download according to the bit version.




Contact Form

Name

Email *

Message *

Popular Posts