• Training RSS Feed

    Training Courses 

    by
    Ken Puls
    Published on 2011-08-28 06:44 AM     Number of Views: 5364 
    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
    I offer hands-on instructor led training sessions tailored to your needs.

    My goal with every course is to ensure that all of my students learn skills that can be applied in the real world. I prefer to lead 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.) 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, I 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)
    • 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 several independant companies, as well as led multiple sessions for two of Canada's three major accounting societies. The feedback I have received has been resoundingly positive due to my knowledge, passion for the product and engaging presenting style.

    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.

    Online Training Courses
    If you are looking for an online training course, fellow Microsoft Excel MVP Chandoo offers an online Excel School!

    Per Chandoo's website:
    Excel School is structured and comprehensive online training program for learning Microsoft Excel. It is full of real world examples.

    The aim of Excel School is to make beginners become productive and awesome in Excel. It has an optional module on Dashboards, which can teach you how to design awesome Excel Dashboards.

    Excel School Online Training Program

  • Recent Knowledge Base Articles

    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

    Categories:

    Excel - General Tips  Excel - Charts and Data Visualization 
    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

    Categories:

    Excel - Formulas  Excel - General Tips 
    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

    Categories:

    Excel - Formulas  Excel - General Tips 
    Ken Puls

    Using HASONEVALUE in a DAX IF statement

    As an accountant, I build financial reports, and one of the issues that we have to deal with is getting the numbers to display in a friendly format. Because of the way that debits and credits are stored in databases though, this can be a little challenging.

    In this article, I’m going to walk through the process of building a simple profit and loss statement with PowerPivot, showing how to make all values show correctly. There are some certain key issues that we’ve got to work through though, and we’ll do that using a conditional DAX measure.
    ... read more
    Ken Puls 2012-12-17, 03:50 AM

    Categories:

    Excel - PowerPivot  Excel - PivotTables 
Gravatar by 1e2.it