• Online Excel Training Courses

    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.

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

    I've also worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This course is set up to offer short videos to train on the specific topics you need to get the most out of Excel. You can learn more about it in the video below (and yes, the Expert they talk about is... me!)

    Even better, there's even a discount available to you if you're ready to sign up. Just enter the code XLGURU66 at checkout any you end up getting the course at 1/3 the regular price. (A savings of almost $200!) Click the banner below to get started, or to check out the sample videos available:

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

    To learn more or sign up, just click here.
    Rob Collie's Power Pivot Pro University
    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 downloading his brochure here: PowerPivotProOnlineUniversity.pdf.

    And when you're ready to sign up, this link will take you directly to the page to do so.


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

    Comments 1 Comment
    1. samtaurus's Avatar
      samtaurus -
      Quote Originally Posted by Ken Puls View Post
      You can view the page at
      If you want to learn Microsoft Excel, there are several places on the net that offer online courses. The one I personally like is online excel course by Trainedge .They have videos and pdf course packs like most online course. But they also have lots of assignments you can use to practice the concepts. There are simulated exercises also which are basically guided practice sessions and very helpful.

      Good luck..!
  • Recent Knowledge Base Articles

    Ken Puls

    Making Pivot Table Hyperlinks Clickable

    If youíve ever built a PivotTable that contains hyperlinks, youíll notice that clicking the hyperlinks doesnít do anything. This can be a bit frustrating as the reason you put that field on the Pivot in the first place is that itís valuable information you want to use. When you click the hyperlink,... read more
    Ken Puls 2013-10-31, 01:58 AM
    Ken Puls

    Temperature Forecast Chart

    Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, weíll build one of those; a temperature chart that not only shows the forecasted high and low temperatures, but also the season highs and lows. The beauty of this chart is that it provides a lot of information, some of which essentially fades into the background until you really need it.
    ... read more
    Ken Puls 2013-03-21, 05:04 AM
    Ken Puls

    VLOOKUP for Pictures

    Something that can be very handy when youíre building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different column, but unfortunately we canít do that with pictures... or can we?

    This example shows how to accomplish the equivlanet of a picture VLOOKUP, and is based on looking up a picture to display the appropriate... read more
    Ken Puls 2013-03-14, 05:47 AM
    Ken Puls

    Understanding How Conditional Formatting Rules Are Applied

    Conditional formatting in Excel is a powerful tool that allows you to dynamically format cells depending on the values of that or other cellsí data. In Excel 2007 the conditional formatting engine was re-written, opening things up to allow more than 3 conditional formats on any cell, as well as conditional formats that could overlap ranges. All in all, these were fantastic improvements that can lead to some very versatile and useful worksheets.

    Unfortunately, the user interface to control conditional formatting is not the most intuitive. The purpose of this article is to help you understand the way Excel applies rule precedence so that you can build powerful formatting rules of your own, without getting frustrated along the way.
    ... read more
    Ken Puls 2013-01-22, 06:30 AM