• Welcome to the Excelguru Knowledge Base

    Welcome to the new and improved Excelguru Knowledgebase!

    My favourite definition of the word Guru is "Remover of darkness"; A guide. A teacher. It is in this spirit that the Excelguru website was created: to help remove the mysteries of Excel, help you find solutions, help you to be more proficient or accomplish certain tasks. Over time, we've also expanded to include Power BI as well.

    I am a firm believer that properly set up, a computer can process numbers and data far more efficiently and accurately than any human, and that human brainpower should be devoted to solving problems, not data input. Did you know that the only thing that can't be automated in Excel is the input of raw data... and that even that can sometimes be done? If you perform repetitive tasks in your Excel spreadsheets, you may be wasting both your time and business resources performing unnecessary work. Let us show you how to save both your time and money by helping you automate your tasks today!

    The Excelguru Knowledgebase is packed with numerous articles on how to accomplish specific tasks in Microsoft Excel, Microsoft Access, Power BI and other programs included in the Microsoft Office suite. It also includes examples on a select few non-Microsoft Office programs, and many general tips as well.

    If you notice errors in any of the articles, or have suggestions for improvements, please feel free to leave a comment on the article's page. And if you need any help modifying the articles to suit your needs, then please, post in my free help forums!

    UPCOMING EVENT

    SQL Saturday Vancouver Pre-Con Event - Friday, August 25, 2017

    EXCELGURU NEWSLETTER

    Keep up-to-date with Excelguru by signing up to receive our monthly(ish) Excelguru email newsletter. It features 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 our mailing list

    * indicates required
  • MVP Logo
  • Recent Forum Posts

    AliGW

    Need an "IF" formula

    Try this:

    Excel 2016 (Windows) 32 bit

    J
    K
    L
    M
    N
    O
    ...

    AliGW Today, 05:24 PM Go to last post
    JoinColorado

    Need an "IF" formula

    I need a formula that once column D is subtracted from column F, "IF" the outcome is negative it will put a "0" in either column E...

    JoinColorado Today, 05:18 PM Go to last post
    Tadder

    Look up

    Didn't know the O365 part, good advice... in that case, use this instead.

    Enter some text on a new sheet for index like this:
    ...

    Tadder Today, 04:50 PM Go to last post
    Pecoflyer

    Lookup and populate new worksheet

    Hi and welcome
    please attach a sample sheet ( go adavnced - Manage attachments) with some data and expected results. Also show what you have already...

    Pecoflyer Today, 04:41 PM Go to last post
    AliGW

    Look up

    With regard to the SWITCH function, it is only available to you if your are an Office 365 subscriber....

    AliGW Today, 04:35 PM Go to last post