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-11 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
...

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

Transpose from columns to rows. Pivot/Unpivot seems to not apply in this situation

Much appreciated Thank you!...
nangys Today, 09:17 PM

Edit ActiveX textbox from VBA Userform

Cross-thread...
Instigator Today, 05:43 PM

How to Tally and Rank Frequency of Occurrences of a Year in a Column

PS

To get all three queries into one sheet, instead of choosing Close & Load, choose Close and Load To ... and then you can specify a...
AliGW Today, 05:09 PM

How to Tally and Rank Frequency of Occurrences of a Year in a Column

I should have added that your results look about right, and yes, PQ makes some things an absolute breeze. Glad you are getting acquainted with it!...
AliGW Today, 05:06 PM

How to Tally and Rank Frequency of Occurrences of a Year in a Column

I'll have a quick look. Don't have much time, but I'll see what I can advise.

Unfortunately, because the sources cannot be found, the...
AliGW Today, 04:49 PM

Knowledge Base Articles By Category

Excel - Power Query

Recent Forum Posts