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 1 Comment

Recent Forum Posts

Help creating a VLookup to retrieve training status

In B2 =VLOOKUP(A2;Report!1:1048576;15;0), if I understand what you are trying to achieve

Sent from my SM-G965F using Tapatalk...
Docharding Yesterday, 11:26 PM

Get value form a table

Hi gents,
I am trying to find the correct syntax/formula for getting a value from a table based on a value from another cell in an other sheet....
Ignatios Yesterday, 10:02 PM

Best method to create training log?

Follow up to Ali's suggestion. Here is a link that I often refer Access Template Lookers to examine. While it does not give you an actual DB, it does...
alansidman Yesterday, 05:54 AM

Need help with total monthly hours

Enter times as follows: If it's 2:05 in the afternoon enter as 2:05 PM or 14:05.
The attached should handle times across midnight, but check....
p45cal 2021-01-15, 11:22 PM

Need help with total monthly hours

I took the 12 out and if you key in 0:30 it row 12 it still subtracts from row 16 which is what it is supposed to do. I've tried every format I could...
dcope7 2021-01-15, 07:05 PM

Knowledge Base Articles By Category

Excel - Power Query

Recent Forum Posts