• Welcome to Excelguru

    Welcome to Excelguru!

    Our 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 by Ken Puls (the Excel Guru): to help remove the mysteries of Excel and Power BI, help you find solutions, help you to be more proficient or accomplish certain tasks.Ken's passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.

    The team at Excelguru is dedicated to helping you get the most from your data by leveraging tools you already own through On-site and Online Training,Consulting and Mentoring Services, Technology Blog, and a freeOnline Help Forum and Knowledge Base. We specialize in:

    - Excel

    - VBA

    - Charting and Dashboarding

    - Power Pivot

    - PivotTables

    - Power Query

    - Power BI


    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


    Delete Specific Text from Column of Cells

    It would appear that your data is uniform in layout, but might you have a line with 2 characters to remove (e.g. RM), and also a ZZ+number to remain?...

    Hercules1946 Yesterday, 11:38 PM Go to last post

    Rename the pictures using excel

    Hi Guys,

    I need your help. I'm using mac. I try to figured out for this code for change the old names of picture to new name.


    jcsc83ph Yesterday, 09:53 PM Go to last post

    Setting Up Names in a Table as Row Label

    Excel Version: Microsoft Office Professional Plus 2013

    I'm trying to count the number of times a name is assigned to a group/role from a...

    thk12205 Yesterday, 09:46 PM Go to last post

    data anlysis

    In row 2, say column W, this formula array-entered (that's Shift+Ctrl+Enter, not just Enter):

    p45cal Yesterday, 08:34 PM Go to last post

    Help with Sorting Data Please

    Sub FishCount()
        With Sheets("catch-return")
            For r = 2 To .Range("A1").End(xlDown).Row

    NoS Yesterday, 07:51 PM Go to last post