• Video Courses RSS Feed

    by Published on 2017-10-10 01:55 AM

    Power Query Academy
    Power Query Academy

    COURSE DESCRIPTION
    What is Power Query?

    Only the BEST tool for business users since PivotTables!

    Power Query, also known as ďGet & TransformĒ, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.

    Until now, building BI solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format ...
    by Published on 2017-07-26 12:21 AM

    Error Checking for Excel BI Solutions
    Say GOODBYE to Excel ERRORS for GOOD. Finally, your guide to creating clean & error free workbooks.



    COURSE DESCRIPTION
    How much could one spreadsheet error cost? Well, it cost one bank almost $1b. Research ...
    by Published on 2017-10-17 09:09 PM

    Microsoft Excel - Basic


    COURSE DESCRIPTION
    New to Excel or need a refresher? Ken Puls has worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This online course is set up to offer short videos to train on the specific topics you need to get the most out of Excel, ...
    by Published on 2017-10-18 08:44 PM

    Microsoft Excel - Advanced


    COURSE DESCRIPTION
    Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? Ken Puls has worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This online course is set up to offer short videos to ...
    by Published on 2017-10-17 08:34 PM

    Microsoft Excel - Basic & Advanced


    COURSE DESCRIPTION
    Looking for an Excel course for beginners to experts? Ken Puls has worked with a company called GoSkills to help design and build a targeted Excel course which is offered in an online format. This online course is set up to offer short videos to train on the specific topics you ...
    by Published on 2017-10-17 09:44 PM

    Microsoft Excel - PivotTables


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

    Pivot Tables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable ...
    by Published on 2017-10-17 09:58 PM

    Microsoft Excel - Macros & VBA


    COURSE DESCRIPTION
    Learn to automate your most repetitive tasks at the push of a button with Excel macros and VBA. In this online course, you will learn to create powerful macros using VBA (Visual Basic for Applications) to really make Excel work for you. With no prior programming experience required, you'll have ...
    by Published on 2017-11-22 06:42 AM

    Power BI


    COURSE DESCRIPTION
    Make your data come to life with beautiful, interactive reports in Power BI. Ken Puls has worked with a company called GoSkills to help design and build an introductory course which is offered ...
    by Published on 2012-04-23 09:10 AM     Number of Views: 51698 

    The Magic of PivotTables
    Add to Cart

    Excel PivotTables: Itís a polarizing term. People who use PivotTables absolutely love them. For those who donít, the term is mysterious and encourages the fear of powerful features that are the domain of geeks and Excel junkies, and out of reach to the common man. But nothing could be further from the truth.

    Why You Should Take This Course:

    If youíve never created, or donít regularly use PivotTables in your work, let me show you that you are missing out on one of the most useful, impressive and easy-to-use tools in Microsoft Excel.

    Excel PivotTables are an amazingly powerful feature that can be used to very quickly summarize and slice and dice data with ease. And contrary to many usersí fears, they are actually VERY easy to use once youíve been shown how.

    So why donít you let me do just that? In this one hour video training course, I will teach you how to build your first PivotTables. Youíll see first hand just how easy they are to create, how fast they work, and how easy it is to change them to display your data the way you want to see it.
    ...
    by Published on 2017-10-17 12:04 AM

    Building BI with PivotTables


    COURSE DESCRIPTION
    Learn how to master Business Intelligence and PivotTables with this self-paced video course Ken Puls created with the fine folks at Excel.TV. Building BI with PivotTables is the best, most comprehensive online course to quickly increase your data and Excel skills, and master ...