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)

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 12: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 07: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 07: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 doing some calculations within pivot table

p45cal

How did you get to what's visible in your DAX.jpg?
I summarize by tabulate Calculation type and Formula in detail and highlight
...
ricklinty Yesterday, 01:51 PM
Formula help

Pictures don't really help us to help you. Please attach a workbook and ideally indicate what result you are expecting as it's not clear to me at all...
JoePublic Yesterday, 08:13 AM

Help doing some calculations within pivot table

Wow this is awesome, thank you all for your help!...
accountingguy Yesterday, 02:40 AM
Help doing some calculations within pivot table

ricklinty,

a nice tutorial for adding measures in the Data Model!
the only thing I might have done differently is use your prior created measures
...
p45cal 2022-07-04, 01:20 PM
Help doing some calculations within pivot table

https://www.contextures.com/excel-pi...ted-field.html...
alansidman 2022-07-04, 07:56 AM

Knowledge Base Articles By Category

Excel - Power Query

Recent Forum Posts