• Resources RSS Feed

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

    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: 21969 

    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: 14084 

    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: 9977 

    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: 22455 

    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: 13487 

    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: 32207 

    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 ...

  • MVP Logo
  • Recent Forum Posts

    tigerdel

    Copy Data from One Sheet to Another Based on Date Chosen

    In my file, I have a sheet that contains the entire roster over many months [and years] - called Full Roster
    To make it easier for the user to locate
    ...

    tigerdel Today, 10:40 AM Go to last post
    Eflats1

    Auto fill web form

    Here is a copy of what the code looks like and also a screen shot




    Warranty/Guarantee...

    Eflats1 Yesterday, 01:59 PM Go to last post
    Eflats1

    Auto fill web form

    I am close to completing the macro I need to auto fill a web form. I understand the basics of the code and how they reference the html elements but I...

    Eflats1 Yesterday, 01:25 PM Go to last post
    alansidman

    Pivot table and date groupings

    No toe stepping here. I am at the early stages also. And as we already know, there are many ways to accomplish the same result in Excel. Glad to see...

    alansidman 2019-05-18, 10:32 PM Go to last post
    p45cal

    Pivot table and date groupings

    I don't mean to stand on other's toes - I'm getting to grips with Power Query etc. and wouldn't mind some feedback.
    I experimented and ended up...

    p45cal 2019-05-18, 08:14 PM Go to last post