Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Monkey Tools Add-in
    • Books & Other Products
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Articles

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • 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 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:

    1. It takes admin rights to install.
    2. You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match your
    ...
    Read More 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
    Article Preview

    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 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
    Article Preview

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

    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 05:36 AM     Number of Views: 21037 
    Article Preview

    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 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 08:09 PM     Number of Views: 22512 

    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 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 05:14 AM     Number of Views: 52121 

    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 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 08:52 PM     Number of Views: 17328 

    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 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 08:41 PM     Number of Views: 23424 

    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 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 06:56 AM     Number of Views: 13254 

    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 Read More
  • MVP Logo
  • Recent Forum Posts

    ajyexcel

    Not able to figure out how to fetch a column value present in a different excel sheet

    Hello Everyone ,

    Need your help in resolving one issue, I'm trying trying to fetch the information on Sheet 1 ( date for Specific Phase)...

    ajyexcel Today, 02:50 AM Go to last post
    Polignac

    Specification Comparison Table from Different Worksheets

    Hi Ali, I'm trying to retrofit the codes to my existing data, which contains more rows of data than before, i.e. from 25 rows of data to 59 rows, in addition,...

    Polignac Today, 01:23 AM Go to last post
    AliGW

    can a pivot table show my data in the way i need it?

    Welcome to the Pandora's Box that is PowerQuery!...

    AliGW Yesterday, 03:23 PM Go to last post
    rantanwang

    can a pivot table show my data in the way i need it?

    Thank you so much, figured out how to load into editor and added extra columns to calculate consumption and am now creating a dashboard with slicers....

    rantanwang Yesterday, 02:42 PM Go to last post
    AliGW

    can a pivot table show my data in the way i need it?

    Well, of course it depends, but as your master workbook must contain TBLREADINGS, it should be as easy as creating a blank query and copying in my code....

    AliGW Yesterday, 01:38 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 04:03 AM.
Powered by vBulletin® Version 4.2.5
Copyright © 2021 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it