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

    UPCOMING EVENT

    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.

  • MVP Logo
  • Recent Forum Posts

    needexcelhelp

    Convert large dataset into 2 columns into multiple columns

    Hi. I have a large dataset from multiple experiments that are all in two columns, when in reality they should be split into 60 or so columns from 30 separate...

    needexcelhelp Yesterday, 11:20 PM Go to last post
    Hercules1946

    week num

    Excels weeknum function can result in a week 54 in some years! This is because:
    1. 1st January is always Week 1.
    2. But .... there is also...

    Hercules1946 Yesterday, 11:16 PM Go to last post
    myk2thestar23

    Highlighting Cells based on Date

    I need help trying to accomplish this to save me some manual work.

    I have an excel spreadsheet where I need to Highlight cells in Column...

    myk2thestar23 Yesterday, 11:10 PM Go to last post
    jonespandrew

    WEEKnUM AND PIVOT TABLES

    Hi Thanks

    However the forumula used in previous post is showing 31/12/17 as week 53 when it should be 52 how do i alter the formula to correct...

    jonespandrew Yesterday, 07:00 PM Go to last post
    jonespandrew

    week num

    Hi thanks for this, the only issue now is that it is shows 31/12/17 as week 53 when infact it is week 52, what do i need to do to alter this....

    jonespandrew Yesterday, 06:59 PM Go to last post