• 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


    UPCOMING COURSE

    Wednesday, April 11, 2019 - New York, NY

    Transform the way you work with data forever! If you need to learn one skill in Excel today, it is how to work with Power Query. Not only will it change the way you "Get & Transform" data in Excel, but it's also the system used to collect data for Power BI Desktop, meaning these skills are transferable to other programs. Let us show you how to master your data in this small group hands-on session! Click here for details and registration.


    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

    AliGW

    Reverse Colums

    Yes, it will work with lots of rows - try it!

    Alan - the more I use PQ, the more I realise that there are, inevitably, pitfalls. Anything...

    AliGW Today, 06:54 AM Go to last post
    Heyjoe

    Reverse Colums

    Thank you both so much. I am not familiar with power queries. Would it work if the spreadsheet has a lot of rows in it?...

    Heyjoe Today, 01:46 AM Go to last post
    alansidman

    List.Dates until a certain time (e.g. end of year)

    I know that you posted in Power Query, but here is an alternative solution using VBA that lets you pick a start date and how many days you wish to fill...

    alansidman Today, 12:38 AM Go to last post
    alansidman

    Reverse Colums

    Ali

    Nice Solution. Never thought of doing it that way.

    Alan...

    alansidman Today, 12:35 AM Go to last post
    Jason Wurmser

    Pivot Table\Chart

    Problem,

    I have information I put into a pivot table. The pivot is "Filtered" by Line.
    I want to be able to create combo...

    Jason Wurmser Yesterday, 11:34 PM Go to last post