Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Books
    • 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.

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

    1. It takes admin rights to install.
    2. You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match
    ...
    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 08: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 08: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
  • MVP Logo
  • Recent Forum Posts

    nangys

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

    Much appreciated Thank you!...

    nangys Today, 09:17 PM Go to last post
    Instigator

    Edit ActiveX textbox from VBA Userform

    Cross-thread...

    Instigator Today, 05:43 PM Go to last post
    AliGW

    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 Go to last post
    AliGW

    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 Go to last post
    AliGW

    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 Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 11:47 PM.
Powered by vBulletin® Version 4.2.5
Copyright © 2019 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it