Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Training
    • Monkey Tools Add-in
    • Monkey Tools Account
    • Books & Other Products
    • Private Courses
    • 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
  • 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)
    Word - VBA Programming (8)
  • Power BI

    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

    Using Power BI Templates 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2018-02-09 11:19 PM  Number of Views: 9403 
    Article Preview

    One of the big issues when distributing Power BI files locally is that the file paths get hard coded, and there is no way to make the path dynamic. This is very frustrating as any user who has a different data path to the source file from the author must edit the query and update the file path. One strategy to avoid this issue is to using Power BI Templates to prompt the user for the source data path when the template ...
    Read More Read More 1 Comment

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

    caabyyc

    Help with time duration calculation

    it will be better for others to understand your question with sample data including original data and expected result....

    caabyyc Yesterday, 04:38 PM Go to last post
    p45cal

    Help with time duration calculation

    See the first formula here: https://exceljet.net/formula/get-wor...ates-and-times with explanations.
    You'll probably need a bit more...

    p45cal 2022-05-13, 02:48 PM Go to last post
    TN0410

    Help with time duration calculation

    Hello All,

    Please I need some assistance with a formula to calculate the time duration between 2 dates with the following conditions:...

    TN0410 2022-05-13, 10:05 AM Go to last post
    NWVR

    Add data to and existing table using named ranges.

    Thanks for coming back to me.

    After receiving your reply I did a bit of playing around to see if I could get it right and figured it out....

    NWVR 2022-05-11, 12:58 PM Go to last post
    JoePublic

    Dependant drop list data validation Indirect formula

    The data validation is not calculated until you press the dropdown, which is why I asked when exactly you see the message. If you see it after entering...

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