• Training RSS Feed

    by Published on 2016-12-01 01:00 PM

    Course Description

    For years, Excel has been the business intelligence tool of choice for accountants and business analysts around the world. In July 2015, however, Microsoft released a free software package that has become the hottest software commodity in the business intelligence landscape: Power BI Desktop.



    Join us for an intensive three-day, hands-on boot camp that will allow you to hit the ground running with Power BI. Geared specifically towards Excel ...
    by

    Course Description

    How many times have you begun building a spreadsheet, only to have it evolve on you based on requests from users and managers? While this is a great compliment to your work and skills, these changes can cause our spreadsheets to grow ...
    by

    Course Description

    In this hands on course we are going to look at the most important Excel features that will turn you into a quick and efficient data master in Excel.

    Most users missed the implementation of the Excel Tables feature that happened in Excel 2007. It stealthily slid its way into the product with very little fanfare, yet ...
    by Published on 2014-12-10 04:20 AM     Number of Views: 11041 

    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 his 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.
    by Published on 2011-08-28 06:44 AM     Number of Views: 25187 
    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?

    Personalized Instructor Led Training
    As a business professional and employer I understand that the value of a training session is in making sure the participants learn skills that they can apply in their daily jobs. For this reason, I customize each and every one of my courses to tailor to your specific needs.

    My goal with every course is to ensure that all of my students learn real skills that can be applied in the real world. To maximize learning, I prefer to lead on-site, hands on courses where each person has a laptop and can follow along with the examples files I provide (each of which is built from real life scenarios that I've experienced.)

    Image produced by Jay Shaw Photography, copyright CMABC
    Ken Puls, CPA, CMA, MS MVP (Excel) presenting at the 2013 CMABC Strategic Leadership Conference.

    Every course I teach ends with a section on how to get help and find answers as well, as you won't always have an Excel Guru standing next to you. In addition, if requested, I can also provide documentation on all the topics covered so that the participants can review the techniques I've taught at a later date.

    Just some of the courses I've taught in the past include:
    • Spreadsheets That Last (a course focused on designing spreadsheets that will last over time)
    • Introduction to Excel
    • Intermediate Excel
    • Intro-Mediate Excel (introductory review in the morning followed by intermediate topics in the afternoon)
    • Data Cleanup, Analysis and Display (from importing text files and cleaning up the data, to working with Pivot Tables)
    • Charting and Dashboarding (a course focused on creating effective charts and data visualizations that help make your data tell a story)
    • Introduction to PowerPivot (the best new feature to be added to Excel since PivotTables, this course will blow your mind and take you into a business intelligence realm that was never before possible in Excel!)
    • Introduction to VBA (from recording to editing macros. All the things I wish I was told when I started my VBA journey!)
    To date I've led training at many independant companies, as well as led multiple sessions for all three of Canada's major accounting societies. The feedback I have received has been resoundingly positive due to my knowledge, passion for the product and engaging presentation style.

    Image produced by Jay Shaw Photography, copyright CMABC
    Ken Puls, CPA, CMA, MS MVP (Excel) presenting at the 2013 CMABC Strategic Leadership Conference.

    Whether you are interested in a presenter for a conference, professional development session or corporate training, you need look no further. From basic Windows and Excel training, to designing efficient spreadsheets to Visual Basic for Applications, (the macro language within Microsoft Office,) I can build a course for you.

    If you'd like more information, please contact me.

    Personalized Webcasts
    One of the issues with live training sessions is, of course, travel costs. The great news here is that I can also provide live webcasts tailored to your organizations needs.

    Every webcast I host is led using professional web conferencing software to ensure the best experience for attendees. While it's not as interactive as a hands-on session, this can be a great compromise for cost-conscious businesses that still want to get high-end training to their staff.

    Again, if you'd like more information, please contact me.

    Online Training Courses
    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: