• 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

    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

    Hercules1946

    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
    jcsc83ph

    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
    thk12205

    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
    p45cal

    data anlysis

    In row 2, say column W, this formula array-entered (that's Shift+Ctrl+Enter, not just Enter):
    =DATEDIF(INDEX($A2:$K2,MAX(($L2:$U2="LARC")*(COLUMN(L2:U2)))-10),V2,"M")...

    p45cal Yesterday, 08:34 PM Go to last post
    NoS

    Help with Sorting Data Please

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

    NoS Yesterday, 07:51 PM Go to last post