Excelguru Help Site - Excel

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (9)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (12)

Excel - Power Query (3)

Excel - PowerPivot (7)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (49)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (1)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

Power BI (3)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Training Products (10)

Word - VBA Programming (8)

Excel - Power Query
Installing Power Query and Power BI Desktop

by
Rebekah

View Profile

View Forum Posts

View Blog Entries

View Articles

Published on 2018-07-10 01:20 AM

Installing Power Query
The Power Query add-on is installed by default in Excel 2016 and can be found in the Get & Transform section of the Data tab. However, for Excel 2010 and 2013, the add-on needs to be downloaded and installed. You can download the most recent version from the Microsoft site.

There are three things you should know about this download package:

It takes admin rights to install.
You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match your
...

Read More
Legacy Installers for Power Query and Power BI Desktop

by
Rebekah

View Profile

View Forum Posts

View Blog Entries

View Articles

Published on 2017-08-24 08:45 PM

Legacy Installers for Power Query and Power BI Desktop
Let's be honest, one of the incredibly cool things about Power Query and Power BI Desktop is that they are updated monthly. We always get new features and bug fixes, but there is a potential downside ...

Read More
Power Query Connectors

by
Rebekah

View Profile

View Forum Posts

View Blog Entries

View Articles

Published on 2017-08-23 08:51 PM

Data Connectors for Power Query in Excel
One of the things that makes Power Query so powerful is able to connect to almost any type of data source. So how come you find yourself asking, "Why is this connector not available to me?" Well, it very likely has ...

Read More

Recent Forum Posts
Excel:data validation drop-down list- Populate the matching hyperlink from another co

So, I wish Excel or Google Sheets had the option of keeping links intact when you did a drop down list in data validation, but it doesn't. I decided the...
bgiovanni1! Yesterday, 08:54 PM

Importing Data From MS Word to MS Excel

Thanks for the assist! I was thinking something similar but you got to it b 4 me ...
bobjglover@gmail.com Yesterday, 02:58 PM
VBA fill blank cells with value above

Old thread, I know; The whole submit macro can be condensed:

Code:

Private Sub submitCommandButton_Click() With ThisWorkbook.Worksheets("Sheet1")

...
p45cal Yesterday, 01:01 PM
Dropdown list of folder names/dropdown list of subfolders of selected folder/excel f

https://www.mrexcel.com/board/thread...files.1117592/
https://www.excelforum.com/excel-gen...ml#post5243287...
adokskel Yesterday, 09:51 AM

Dropdown list of folder names/dropdown list of subfolders of selected folder/excel f

Hello Dear Admin,
Sorry for my fault.
I will add the links to my first post immediately....
adokskel Yesterday, 09:40 AM

Knowledge Base Articles By Category

Excel - Power Query

Recent Forum Posts