• Welcome to Excelguru

    What is Excelguru?

    Our favourite definition of the word Guru is, "Remover of darkness." A guide. A teacher. It is in this spirit that the Excelguru site was created by Ken Puls (also known as the Excel Guru). Our goal is to help remove the mysteries of Excel and Power BI, help you find solutions, and help you to be more proficient or accomplish certain tasks. Our 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. We specialize in both live and video training, as well as mentoring and consulting services, in:

    • Excel
    • VBA
    • Charting & 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 the Excelguru Newsletter

    * indicates required

    View previous campaigns.

  • MVP Logo
  • Recent Forum Posts

    NBVC

    Search string query

    Try:

    =ISNUMBER(FIND(" 1 "," "&A2&" "))...

    NBVC Yesterday, 07:16 PM Go to last post
    Xephon12

    Search string query

    Sorry, to clarify the free text box has letters as well as numbers in it. I can appreciate that method if I could isolate the number in it, it's usually...

    Xephon12 Yesterday, 06:44 PM Go to last post
    NBVC

    Search string query

    Maybe something like this?

    =IFERROR(B2+0=1,FALSE)


    where B2 contains the string to check....

    NBVC Yesterday, 02:18 PM Go to last post
    Xephon12

    Search string query

    Hi,

    I'd be really grateful for any help on this. I've scratched my head for quite awhile on it...

    I've got like 10000 entries...

    Xephon12 Yesterday, 01:36 PM Go to last post
    Pecoflyer

    Unable to run macro

    Hi and welcome
    Please,do not crosspost your question on multiple forums without including links here to the other threads on other forums. ...

    Pecoflyer Yesterday, 09:34 AM Go to last post