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

    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 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!


    Learn more about this and other upcoming courses by signing up to receive the monthly(ish) Excelguru newsletter. In it we features tips for Excel, Power Query, PowerPivot and Power BI, upcoming training sessions, new products and other information.

    Sign up for the Excelguru Newsletter

    * indicates required

    View previous campaigns.

  • MVP Logo
  • Recent Forum Posts


    What function can i use

    I am a little puzzled, as if you have access to enough detailed data that will let you construct a formula/function then you should be able to "pivot"...

    Hercules1946 Yesterday, 11:15 PM Go to last post

    Displaying dynamic photo and graph with slider


    Unfortunately it still changes same way when I use the arrows on slider. The picture change is delayed by one click.


    siadajpan Yesterday, 04:19 PM Go to last post

    What function can i use

    Thanks for your reply!

    The pivot table is arranged with client on top and then departments with the revenues against them. I cant use the...

    reesespieces Yesterday, 02:57 PM Go to last post

    What function can i use

    Without any indication of how your data is organised its difficult to say which is the best way to go. By the sound of it department is the top level...

    Hercules1946 Yesterday, 01:58 PM Go to last post

    2010 index match

    Thanks for the clarification. I was looking to deal with a more complicate situation, because I thought that you were saying that FALSE or maybe negatives...

    Hercules1946 Yesterday, 01:37 PM Go to last post