• Training RSS Feed


    COACHED: Excel Fundamentals Boot Camp

    Excel Fundamentals Boot Camp

    Course Description

    In the Fundamentals Boot Camp, you will begin with a review core skills for the Excel analyst. This section is geared to teach critical skills to less experienced users and review those skills for intermediate users. We’ll start with basic formulas, reviewing absolute ...

    COACHED: Self Service BI Boot Camp

    Self Service BI Boot Camp

    Course Description

    Prepare to change your company’s reporting game forever! We know that data is not usually stored in nicely curated databases and often – even when it is – the data analyst doesn’t have access to it. Instead, we must piece together data provided in text files, Excel files, ...

    ON-DEMAND: Power Query Academy

    Power Query Academy

    Course Description

    What is Power Query?
    Power Query is the most important data analysis tool since PivotTables. It allows you to clean, reshape, and combine your data with ease, no matter where it comes from.

    Introducing Power Query Academy

    Until now, building Business Intelligence solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format data before it can even be used. And updates have been tedious and error prone.

    Learning to use Power Query means less ...

    ON-DEMAND: Dimensional Modeling for the Excel and Power BI Pro

    Dimensional Modeling for the Excel and Power BI Pro

    COURSE DESCRIPTION

    What is Dimensional Modeling and why should you care?
    The classic Excel PivotTable did a great job of letting us quickly pivot and slice data for years. There was a ton of logic built into the tool in order to make it easy for end users, but that ease of use had a cost: it didn’t scale to multiple data source tables. And worse, it actually kept you from learning the terms to scale your own knowledge. ...

    ON-DEMAND: Microsoft Excel - Basic & Advanced


    COURSE DESCRIPTION

    Looking for an Excel course online to improve your skills and save you time? Ken Puls has worked with a company called GoSkills to help design and build Basic and Advanced Excel, an online training course that can quickly get you up to speed ...

    ON-DEMAND: Microsoft Excel - Basic


    COURSE DESCRIPTION

    New to Excel or need a refresher? Ken Puls has worked with a company called GoSkills to design and build a targeted Excel course which is offered in an online format.

    This online course is designed to give you a solid foundation in the basics of Excel.

    Supports Excel for Windows 2010, 2013, 2016, 2019, Microsoft 365. Also available: Excel ...

    ON-DEMAND: Microsoft Excel - Advanced


    COURSE DESCRIPTION

    Have some experience with Excel and want to improve your skills, or taken our Basic Excel course? This online course Ken Puls has built with GoSkills will help you learn intermediate and advanced Excel techniques.

    Supports Excel for Windows 2010, 2013, 2016, 2019, Microsoft 365. Also available: Excel Advanced for Mac.

    In 28 engaging lessons ...

    ON-DEMAND: Microsoft Excel - PivotTables


    COURSE DESCRIPTION

    New to Pivot Tables or want to get more out of them? Ken Puls worked with a company called GoSkills to design and build this online course 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 way. ...

    ON-DEMAND: 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 that Ken Puls designed and built with a company called GoSkills, ...

    ON-DEMAND: Excel Dashboards


    COURSE DESCRIPTION

    Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. Ken Puls has worked with a company called GoSkills to help design and build and online course that will teach you the data visualization skills ...
    Private Courses
    The tools within Microsoft Office are extremely powerful, and already exist on your systems... but do your staff know how to use them?

    The biggest issue facing corporate efficiency today is not the inability to afford powerful systems, but rather the lack of recognition of what you already have and how to leverage it. Does a knowledge gap exist in your staff's Office skill-set? Would you like to fix it?