• Resources RSS Feed

    by Published on 2014-11-21 03:20 AM     Number of Views: 17384 

    This page is dedicated to listing out Excel courses that are available online. I am VERY selective about the courses that I include on this page, and will only publish listings from those who I trust to deliver a great online training experience that will add value to you.

    In the interests of full disclosure here, each of these images contains an affiliate link, so I do make a (small) amount of money if you click through and purchase. If you find that offensive, you can always go directly to the site in question and purchase direct.

    Courses By Ken Puls (of this very site)
    I maintain a list of all of all of my online courses here in one place:





    Chandoo's Excel School
    Chandoo is a fellow Excel MVP who has been at the online training game a long time. He offers a full Excel School online, as well as a dashboarding course and a variety of others. I can guarantee that you'll learn some useful tricks by working through his material.

    To learn more or sign up, just click here.





    Excel Campus
    Jon Acampora is another fellow Excel MVP and blogger. His site has a great variety of online Excel courses, including ones on VBA, Looikup Formulas, Filters, PivotTables and Dashboards. He also has a number of helpful Excel add-ins.

    To check out his site, just click here.



    Excel.TV
    This online community created by Rick Grantham and Jordan Goldmeier offer webinars, tutorials, articles, and even full Excel courses to help you improve your skills regardless of your current level of expertise. Jordan is a dashboarding phemon and I highly recommend his Excel Dashboard Pro course, as well as the Building BI with Pivot Tables and Error Checking for Excel BI Solutions courses I created with them.

    Check out the Excel.TV site for more information.



    My Excel Online
    My friend John Michaloudis has a popular Excel blog and podcast, as well couple of great online courses and a variety of free webinars. His Xtreme PivotTables course is worth checking out.

    380x230




    My Online Training Hub
    Mynda Treacy is another fellow Excel MVP who has an extensive catalogue of online Excel courses, including ones on Excel skills for finance, customer service and decision making, as well as dashboarding, Power Pivot, PivotTables, Power Query and Power BI.

    To learn more or sign up, just click here.
    If you want to get a sense of Mynda's teaching style, you can also check out her series of three free dashboarding webinars:

    Free Excel Dashboard Webinar



    PowerPivotPro
    Learn PowerPivot from the guy who not only wrote the books on it, but actually worked on the development of the initial product. Rob's work is fantastic, and the course is comprehensive.

    You can find out more about it by visiting the PowerPivotPro website.

    And when you're ready to sign up, this link will take you directly to the page to do so.
    by Published on 2012-04-17 06:00 AM     Number of Views: 22781 

    Excelguru Affiliate Program

    If you have a website or blog, or distribute newsletters by email, you can earn up to 30% in commissions by selling Excelguru products!

    All commissions are tracked by e-Junkie, the same vendor I use to sell all my products, and commissions are paid out on the 15th of the month following sale via PayPal. So what are you waiting for? Join ...
    by Published on 2011-11-04 04:04 AM     Number of Views: 14666 

    Reference Sites
    • Anne Troy's Office Articles
      • Anne has over 230 articles and tutorials available for the MS Office suite! Well worth the read!

    • Andy Pope's "AJP Excel Information"
      • Andy's site is very heavy on Charts, with lots of great pictures and examples. He's also got a collection of Excel based games as well.

    • Bob Phillips xlDynamic
      • Bob's site contains very comprehensive papers on Excel formulas and VBA. My personal favourite is his explanation of Multiple Condition tests using Sumproduct.

    • Chip Pearson's Excel Information
      • Chip has an incredible amount of information on his site, including using the Windows API to get at things not accessible through VBA alone.

    • Colo's Junk Room
      • Colo has all kinds of neat things at his site, including a Class Module tutorial, and tips for teaching VBA programmers how to program in javascript. (This site went offline back in 2011, but the link above accesses the most recent copy via the Wayback Machine.)

    • Deskbright
    ...
    by Published on 2011-11-03 07:37 AM     Number of Views: 10119 

    The following are some of the forums and usergroups that I've been know to frequent:
    ...
    by Published on 2011-11-01 07:40 AM     Number of Views: 22958 

    Excel Blogs
    • The Ken Puls Blog
      • Okay, it's a shameless plug, but this is my own blog, which serves as my testing ground for Excel related material, among other things.




    • Bacon Bits
      • Mike Alexander's Excel Blog. Excel during the week and bacon recipes on the weekend




    • Contextures
      • Debra Dalgleish's Blog focussing on Office and productivity






    ...
    by Published on 2011-10-24 03:21 AM     Number of Views: 14089 

    This page lists many of the books I recommend.

    In the interests of full disclosure here, each of these images contains an affiliate link, so I do make a (small) amount of money if you click through and purchase. If you find that offensive, you can always go directly to the site in question and purchase direct.

    RibbonX - Customizing the Office 2007 Ribbon

    Naturally, I get to plug this one first, since it's mine! This is the definitive guide for customizing the Ribbon in Office 2007 (and higher):
    by Published on 2011-10-17 04:12 AM     Number of Views: 32908 

    I try all of the add-ins I recommend, and won't recommend them unless I believe they are worthwhile (particularly if there is a charge!) Each of those listed below are helpful tools that I have no problem recommending.

    In the interests of full disclosure here, any images below contains an affiliate link, so I do make a (small) amount of money if you click through and purchase. If you find that offensive, you can always go directly to the site in question and purchase direct.

    Chandoo's Excel Templates
    Chandoo is a fellow Excel MVP with a passion for dashboarding and Excel. He has Excel Templates for sale, as well as runs an online Excel School which includes Dashboard Training.



    Peltier Tech Charting Utilities for Excel
    Jon Peltier ...