• Microsoft Excel - PivotTables

    Microsoft Excel - PivotTables



    COURSE DESCRIPTION

    New to PivotTables or want to get more out of them? This online course is designed to give you a solid understanding of PivotTables, taking you from novice to ninja!

    PivotTables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable way.

    In 36 engaging lessons you will learn best practices for preparing source data, using database data, how to preserve formats and create custom styles, sorting and filtering techniques, and much more.

    Whether you use Excel for work or study, these tutorials will start you on your journey to becoming a Pivot Tables Ninja! Learn more about how a GoSkills Excel certification can boost your career.

    REGISTRATION

    For full course details and to register, visit the GoSkills website.


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

     

    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!

  • MVP Logo
  • Recent Forum Posts

    p45cal

    Complex counting help

    The table in the latest file needs refreshing - I should have done that myself - sorry....

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

    Complex counting help

    Hi p45cal - I think there is still some error in the logic but your suggestion of using Power Query has been invaluable. I have been researching that...

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

    Complex counting help

    Attached adjusted accordingly....

    p45cal Yesterday, 11:31 PM Go to last post
    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 Yesterday, 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 Yesterday, 03:05 PM Go to last post