• Testimonials

    by
    Ken Puls
    Rate this article
    Published on 2011-11-03 07:31 AM      Number of Views: 946  
    0 Comments Comments
    I am quite grateful for all the great feedback I've received from my many years in the community working on projects and training. Below are a few excerpts/quotes from some of my particular favourites.

    NASA - International Space Station Power Systems
    • The team has created a tool that takes their analysis info and puts it all into excel. This has allowed them to chart their information, making it much more readable when reported to the entire team of flight controllers. The tool is essentially a one touch button that completely automates the process from start to finish. One stumbling block for them, however, was that they had no way to easily put it into a static report, so the PROs had been exporting the excel charts to GIF files. Needless to say, these didn’t scale well and could become difficult to read.They are now using a modified version of my Printing Worksheets To A PDF File to automate the process of printing all of their chart sheets to PDF files, getting their reports out in better detail, and little hassle.
    • To read a more complete description, see my blog post on this feedback.
    Quote Originally Posted by J. Yimin, ISS Power Systems, Power Resource Office
    There was definitely no way that I would have been able to do this without your code, so thanks a million, we appreciate it. The guy who usually writes our macros is going to integrate this into our existing tools so that you can input your own path for file saving and this routine should become an integral part of our group’s (Electrical Power Systems for the International Space Station) existing tools. So, you’re a part of NASA now!!! Again, thanks a million for the code.

    3 Point Motors, Nanaimo, BC, Canada
    • Built a custom utility for the Controller of the Nanaimo Mercedes Benz dealership, to delete duplicate records in a file exported from their customer database.
    Quote Originally Posted by Doreen Gatt, CMA, Controller, Three Point Motors Nanaimo Ltd.
    WOW! WOW! WOW!!!! I just used that tool you built for me, and am I impressed or what!!! That worked like a charm. Thanks a bunch Ken, that saved us a bunch of time for sure.
    My Experts Online
    • The projects here are varied, and have encompassed automation within Excel alone to those which tie Word and Powerpoint together as well.
    Quote Originally Posted by Anne Troy, Project Manager, My Experts Online
    Ken Puls has provided my clients and I with some incredible applications in Excel, Word and Powerpoint. It seems that nothing I put before him is beyond him; he gets me what I need without fail. Ken has been gracious in the face of numerous change requests and his prices are great, whether you're the end user or the seller of his services. Whether a quickie macro or an extensive application, I can count on Ken to give me a fast turnaround on any project. Not only does Ken contract for me, but in getting to know him, I find him a great guy, too, which makes it very easy to work with him.
    CGA Canada
    • Provided Excel video webcasts for CGA Canada to provide to their membership
    Quote Originally Posted by Justin Norris (via LinkedIn)
    Ken is a true Excel guru, an excellent speaker, and an all-around great guy. In my collaborations with Ken, all three of these attributes have been tested repeatedly, and he's shown himself to be a true professional in every sense of the word. I appreciate Ken's extraordinary mastery of the Excel software as well as his ability to come up with creative and powerful applications for real-world problems. I'm always revved up by Ken's passion and enthusiasm for Excel, which makes learning from him exceptionally easy (the feedback he receives as a presenter is overwhelmingly positive). And I'm deeply grateful for the patience, integrity, and commitment to quality he demonstrates in every project, no matter the challenges that appear. If you're looking for Excel training or consulting in any area that Ken happens to be working in -- hire him. You won't go wrong.
    Metia Corp
    • Provided a webcast to Metia employees to help them get started with PowerPivot in Excel 2010
    Quote Originally Posted by Sandi LiSanti (via LinkedIn)
    Ken provided virtual training for employees at Metia which was on point and customized to their needs and skill level. His knowledge is remarkable and impressed those in attendance.

    I have attended sessions where Ken entertained participants, answered a barrage of random questions, filled the allotted time with relevant examples, and provided lists of other relevant resources. When Ken presented at an annual conference, his session was completely full and well attended. Ken is an excellent Microsoft Excel Resource. He has deep knowledge of his subject matter and can customize the content of a session to a variety of levels of understanding. Ken is passionate about Excel and he passes on that enthusiasm to others. He is adept at answering questions and is a earnest, dynamic presenter
    Other References
    I also maintain a LinkedIn profile, where I have more endorsements of my work. (Although you'll need to become part of my network to see those.)

    I am always looking to build up my list of references, so if you'd like to add your own feedback to this list, please leave a comment below!

  • Recent Knowledge Base Articles

    Ken Puls

    Easy Outlook Email Integration

    Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I ended up heading off to a site to copy an example (usually from my colleague Ron de Bruin's excellent site), then customizing to make it work.

    The goal of this article is to provide an even easier way to add email functionality to your Excel (or any other Office) project... something easy enough for beginner coders to use as effectively as master coders. I wanted a re-usuable chunk that I could just drop into my project with ease, and I believe I've accomplished that here.
    ... read more
    Ken Puls 2012-01-23, 05:52 AM

    Categories:

    Access - VBA Programming  Outlook - General Tips  Outlook - VBA Programming  PowerPoint - VBA Programming  Publisher - VBA Programming  Word - VBA Programming  Excel - VBA Programming 
    Ken Puls

    Prevent Printing In A Workbook

    If you'd like to prevent anyone from printing your workbook, this code will do the trick (subject to the caveat below).
    ... read more
    Ken Puls 2011-12-06, 05:36 AM

    Categories:

    Excel - VBA Programming 
    Ken Puls

    Trigger Conditional Formats Before Printing

    My staff and spreadsheet users will tell you that any time I build a spreadsheet, there are always shaded cells on the grid. I preach that "Green means go", and make sure that any cell they enter data in has a green background. I also use blue backgrounds for "update these sometimes" cells, like tax rates. If cells are left with no colouring, though: everyone here knows that they should be left alone.

    Often, I have a few data entry cells or blocks on multiple worksheets. While this follows good spreadsheet design principles, it does have a bit... read more
    Ken Puls 2011-11-11, 07:56 AM

    Categories:

    Excel - General Tips  Excel - VBA Programming 
    Ken Puls

    Security In Microsoft Office

    Please Note: This text is the complete reproduction of Chapter 17 - Security if Microsoft Office from my book RibbonX: Customizing the Office 2007 Ribbon, and is reproduced with permission of Wiley Publishing who retains the copyright of this work.


    This chapter was obviously written for Excel 2007, and still holds true for Office 2010.

    In addition, this chapter also discusses macro security applicable to Office 97 through Office 2003. Key portions to read for these verions are Security Prior to Office 2007 and Digital Certificates. While some of the screens may look a little different, they should be close enough to help you understand how to set up a SelfCert digital certificate and add it to your projects. These steps will allow you to avoid macro warnigns in your programming environment, without having to sacrifice security by setting your security levels to low.... read more
    Ken Puls 2011-05-06, 06:13 AM

    Categories:

    Downloads - Learning Aids  Access - VBA Programming  Outlook - VBA Programming  PowerPoint - VBA Programming  Publisher - VBA Programming  Word - VBA Programming  Excel - VBA Programming  Excel - User Interface Customization  Works Published/Syndicated/Contributed 
  • MVP Logo

  •  Donations

    If you like our website and would like to give something in return, you can make a donation. All donations are gratefully received and go to support the site.


    Select your preferred currency and donation amount, then click the donate button.

  • Recent Forum Posts

    Colo

    How to Rename a File from English to Other Language?

    Yeah, some massive HTML conversion is my line. In other words, most of difficult things can be done with Excel alone like this time. Well done, Excel!...

    Colo Today, 07:36 AM Go to last post
    Ken Puls

    Link a series name to a cell using Excel 2010 VBA

    Hi there,

    I recorded linking the title to a cell and it came back with the following. Does this help?

    Code:
        ActiveChart.SetElement
    ...

    Ken Puls Today, 04:06 AM Go to last post
    Ken Puls

    How to Rename a File from English to Other Language?

    Colo, that was way too easy... I was expecting some massive HTML conversion, or a huge engine to compare each character against a library of Chr codes!...

    Ken Puls Today, 04:02 AM Go to last post
    Ken Puls

    Shared file\macro & IP address

    Oh, and as for the max number of users who can access the file in the shared folder at once...

    • For reading, I believe it's unlimited. (The second and
    ...

    Ken Puls Today, 03:59 AM Go to last post
    Ken Puls

    Shared file\macro & IP address

    ibrahimaa,

    There is no one-line way to get your IP address the way you are getting the username. So you're going to need more code than...

    Ken Puls Today, 03:56 AM Go to last post
Gravatar by 1e2.it