Excelguru Help Site - Downloads

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)

Downloads - Utilities
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
XLG File Tools Add-in

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2012-03-31 06:36 AM Number of Views: 14849

XLG File Tools is a FREE add-in which was created to increase the functionality of Excel and address the plethora of extra clicks that were introduced begining in Excel 2007. It's current feature set is designed to make the job of opening existing files and creating new files more efficient.

XLG File Tools is easy to use, and is guaranteed to make you more efficient. In addition, it's a snap to install and requires no administrative priviledges to do so.
...

Read More
Data Validation in Excel Services

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2011-03-08 09:09 PM Number of Views: 16803

I’m a huge consumer of Data Validation in Excel. At this point, however, Excel services (the Excel webApp) is still so new that there are very few of the techniques that we normally use in Excel which are web compliant. This article looks at ways that we can implement data validation into an Excel services solution.
...

Read More
Disable the Excel Compatibility Checker

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2008-09-23 06:14 AM Number of Views: 42527

I've received several comments on my blog that people dislike Excel 2007's Compatibility Checker, and would like to turn it off globally. While it's true that you can turn it off for each workbook, the main user interface seems devoid of a way to actually tell Excel that you never want to check your workbooks for compatibility when saving to 2003 or earlier versions. ...

Read More
Text to Speech Utility - Proof Reader for Excel 2007 (and higher)

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2008-05-06 09:52 PM Number of Views: 13450

Introduction
This is a very simple add-in that adds a button to the Review tab's Proofing group, allowing the user to have Excel read the selected cells back to them aloud. ...

Read More 1 Comment
XLG Favourites Add-in

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-09-20 09:41 PM Number of Views: 17878

XLG Favourites
This add-in was created to increase the functionality of Excel and address some shortcomings in the "Most Recently Used Files" listing. While we can increase the list to hold 9 items, I frequently use more than that many files during one of our month ends. It's also well known that long file names get abbreviated and difficult to read. This add-in addresses these issues, among other things. ...

Read More
UseTemplate Add-in

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-08-29 07:56 AM Number of Views: 9379

Templates Addin
This addin was created to increase the functionality of Excel, and make it easier to use templates in the MS Office system. I use a lot of templates, and got tired of having to make up to six clicks to open one. Now, I have a menu that holds all of my MS Office templates (not just Excel), only three clicks away. ...

Read More

Recent Forum Posts
The Web Query Table data in excel not the same as displayed online at the website.

I used the DATA>NEW QUERY>FROM OTHER SOURCES>FROM WEB

URL: https://www.bursamalaysia.com/market...=1&per_page=50...
guanstan Today, 05:10 AM
Source Path from a Cell in the Active Worksheet Vs a named cell

Bob, I know how to get a value from a named range. Let me try to be more specific with an example.

I have a worksheet named VZ
The ticker
...
petraidm58 Yesterday, 03:58 PM
"Don't Move or Size with Cells" not working

I have added a column of buttons to a worksheet (in a dashboard format) each of which has a macro assigned to it. Each macro adds a row to a certain section...
johnf Yesterday, 03:37 PM

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

Consider using a small macro. In the attached, make choices in the green shaded area. To view the code, right-click on the sheet's tab and choose View...
p45cal Yesterday, 02:27 PM
Source Path from a Cell in the Active Worksheet Vs a named cell

Yes, it is simple to get the value from a named range

Code:

let name = Excel.CurrentWorkbook(){[Name=RangeName]}[Content],

...
Bob Phillips Yesterday, 01:38 PM

Knowledge Base Articles By Category

Downloads - Utilities

Recent Forum Posts