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 Home

  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)
  • Rebekah

    Self Service BI Boot Camp (3-Day) 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2019-05-27 08:50 PM



    Prepare to change your company’s reporting game forever! We know that data is not usually stored in nicely curated databases and often - even when it is - the data analyst doesn’t have access to it. Instead, we must piece together data provided in text files, Excel files, web pages, and even ...
    Read More Read More

    Master Your Data with Power Query 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2019-02-19 09:08 PM



    Transform the way you work with data forever! If you need to learn one skill in Excel today, it is how to work with Power Query. Not only will it change the way you "Get & Transform" data in Excel, but it's also the system used to collect data for Power BI Desktop, meaning these skills are transferable to other programs. Let us show you how to master your data in this small group hands-on session!

    Course Description

    The sad reality is that not all data is stored in nicely ...
    Read More Read More

    Newsletter 


    Sign up to receive the monthly(ish) Excelguru newsletter, featuring the latest updates for Excel and Power BI, upcoming training sessions, new products, and other information.

    As a "thank you" for subscribing, we are excited to share our FREE eBook series, 'DIY BI' Tips, Tricks & Techniques. Don't miss out - sign up today!








    Subscribe to the Excelguru Newsletter


    * indicates required

















    View previous campaigns.



    ...
    Read More Read More

    Consulting & Mentoring Services 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2018-07-12 10:39 PM

    Whether you are looking to build a brand new solution, or need to fine-tune or update an existing one, the team of experts here at Excelguru has got your back! We offer both consulting and mentoring services to help you with your Excel, VBA, Power Pivot, Power Query, and Power BI needs. For smaller Excel jobs (those that will take four hours or less), we partner with Excel Rescue.

    Not sure if why you would want to hire an Excel expert, or can justify the cost? The real question to ask yourself is, "How much do you spend on repetitive tasks?" Read Ken's article on ...
    Read More Read More

    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:

    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

    Terms of Service 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2018-06-06 01:00 AM

    TERMS OF SERVICE

    General
    This site, excelguru.ca, and all its sub-areas (“Website”) is owned and operated Excelguru Consulting Inc. Excelguru makes no representation or warranty that the information displayed on the website is appropriate or available for use in other jurisdictions.


    Intellectual Property Rights ...
    Read More Read More

    Magic Tricks for Data Wizards 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-12-20 10:15 PM

    Magic Tricks for Data Wizards:
    Tips & Tricks for Power Query in Excel and Power BI



    In the online Power Query workshops that we deliver as part of our Power Query Training project, we commonly talk about how data professionals can often perform “Magic” ...
    Read More Read More

    DIY BI eBook Series 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-12-20 09:49 PM

    DIY BI eBook Series:
    Tips, Tricks and Techniques for Building Your Own BI Solutions


    This free eBook series is available to our Excelguru email newsletter subscribers. Each book contains ...
    Read More Read More

    Power BI 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-11-22 06:42 AM

    Power BI


    COURSE DESCRIPTION
    Make your data come to life with beautiful, interactive reports in Power BI. Ken Puls has worked with a company called GoSkills to help design and build an introductory course which is offered ...
    Read More Read More

    Privacy Policy 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-30 09:41 PM

    Excelguru Privacy Policy

    1. What information do we collect and what do we do with it?
    We collect the personal information you give us, including your name and email address, as part of the registration process when you subscribe to our newsletter email list, enroll as a student or subscriber to one of our courses, and/or email us directly with a question or comment.

    Email Marketing:
    If you subscribed to our email list, we may send you emails about our monthly newsletter, our site, current or new courses, or other information that we think may be of interest to you.

    If you registered for one of our courses, we may send you emails about our site and related course(s), registration, course content, your course progress, or other updates. We may also use ...
    Read More Read More

    Microsoft Excel - Advanced 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-18 08:44 PM

    Microsoft Excel - Advanced


    COURSE DESCRIPTION
    Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? Ken Puls has worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This online course is set up to offer short videos to ...
    Read More Read More

    Microsoft Excel - Macros & VBA 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-17 09:58 PM

    Microsoft Excel - Macros & VBA


    COURSE DESCRIPTION
    Learn to automate your most repetitive tasks at the push of a button with Excel macros and VBA. In this online course, you will learn to create powerful macros using VBA (Visual Basic for Applications) to really make Excel work for you. With no prior programming experience required, you'll have ...
    Read More Read More

    Microsoft Excel - PivotTables 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-17 09:44 PM

    Microsoft Excel - PivotTables


    COURSE DESCRIPTION
    New to Pivot Tables or want to get more out of them? This online course is designed to give you a solid understanding of Pivot Tables, taking you from novice to ninja!

    Pivot Tables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable ...
    Read More Read More

    Microsoft Excel - Basic 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-17 09:09 PM

    Microsoft Excel - Basic


    COURSE DESCRIPTION
    New to Excel or need a refresher? Ken Puls has worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This online course is set up to offer short videos to train on the specific topics you need to get the most out of Excel, ...
    Read More Read More

    Microsoft Excel - Basic & Advanced 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-17 08:34 PM

    Microsoft Excel - Basic & Advanced


    COURSE DESCRIPTION
    Looking for an Excel course for beginners to experts? Ken Puls has worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This online course is set up to offer short videos to train on the specific topics you ...
    Read More Read More

    Building BI with PivotTables 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-17 12:04 AM

    Building BI with PivotTables


    COURSE DESCRIPTION
    Learn how to master Business Intelligence and PivotTables with this self-paced video course Ken Puls created with the fine folks at Excel.TV. Building BI with PivotTables is the best, most comprehensive online course to quickly increase your data and Excel skills, and master ...
    Read More Read More

    Power Query Academy 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-10-16 01:55 AM

    Power Query Academy
    Power Query Academy

    COURSE DESCRIPTION
    What is Power Query?

    Only the BEST tool for business users since PivotTables!

    Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.

    Until now, building BI solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format ...
    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

    Error Checking for Excel BI Solutions 

    by
    Rebekah
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • View Articles
    Published on 2017-07-26 12:21 AM

    Error Checking for Excel BI Solutions
    Say GOODBYE to Excel ERRORS for GOOD. Finally, your guide to creating clean & error free workbooks.



    COURSE DESCRIPTION
    How much could one spreadsheet error cost? Well, it cost one bank almost $1b. Research ...
    Read More Read More
    Page 1 of 2 1 2 Next LastLast
  • MVP Logo
  • Recent Forum Posts

    macropod

    workload allocation w/ skills matrix

    Cross-posted (and answered) at: https://chandoo.org/forum/threads/wo...-matrix.43173/
    Also cross-posted at:
    https://www.excelforum.com/excel-pro...ls-matrix.html...

    macropod Yesterday, 09:40 PM Go to last post
    Bob Phillips

    Remove duplicate cell value and not the actual cell.

    If you just don't want to see the value, you could use conditional formatting over A1:A11 with a formula of =COUNTIF($A$1:$A1,$A2) and set the font colour...

    Bob Phillips Yesterday, 05:22 PM Go to last post
    joyguru

    Remove duplicate cell value and not the actual cell.

    Thanks...

    joyguru Yesterday, 02:29 PM Go to last post
    Pecoflyer

    workload allocation w/ skills matrix

    Hi and welcome
    Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums. ...

    Pecoflyer Yesterday, 09:09 AM Go to last post
    shucky000

    workload allocation w/ skills matrix

    Hi,

    I'm currently creating a macro for allocation base on worker's skills matrix set.(determined by Y or N). So if the member is Y, worker...

    shucky000 2019-12-04, 10:22 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 04:53 AM.
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