• 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

    Mr_E_Man

    Complex counting help

    Hi p45cal - the specific "DT" function is the only one that does not get counted for the keypad on the 2nd or 3rd reference, it is different...

    Mr_E_Man Today, 05:55 PM Go to last post
    p45cal

    Complex counting help

    The attached contains a table at cell I6, which agrees with your totals except for the keypad count of the first site (1185) where I have counted the...

    p45cal Today, 03:05 PM Go to last post
    Mr_E_Man

    Updated sheet with manual counts

    AliGW,

    Thank you for the quick response to my question! Please find attached the updated sheet with the manual count inserted for the first...

    Mr_E_Man Today, 02:46 PM Go to last post
    AliGW

    Complex counting help

    Please mock up the expected results for the first 5 sites on your list - do this manually so we can see the numbers you are expecting....

    AliGW Today, 07:53 AM Go to last post
    Mr_E_Man

    Complex counting help

    HI. I am, a new user trying to figure out how to count text items in a database of thin client peripheral device details using Excel 2016. The database...

    Mr_E_Man Today, 02:54 AM Go to last post