Category Archives for Discussion
Three Common Dashboard Mistakes
I recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful business dashboard mistakes. I’ll excerpt a version of what I said below, but you should follow the link to read the whole thing. (I’ll use the original version I sent to blog so as not to compete for search keys.) I’ll […]
Continue readingHappy Holidays 2015
OK, so I know a few days ago I said I had written my last blog posted before the end of the holiday. But then I’ve released holiday cards in both 2013 and 2014, so this year should be no different. So I went with a topical Star Wars theme. The text being shown is […]
Continue readingA method for quickly importing and working with CSV files (part 2)
This is part 2 in which I explain how I solved the problem. Make sure to read the previous blog posts. Taken together, these show I though through and ultimately solved the problem. Query Tables to the Rescue! To solve this problem, I stumbled on something I rarely use, and that’s our good ol’ friend […]
Continue readingA method for quickly importing and working with CSV files (part 1)
So many folks have asked me to write more on my coding style. So here it is: I’ve developed a two-parter blog post to present my thinking style and how I ultimately solved the problem. The Problem I have a client with several CSV files that must be checked and validated for certain data specifications. […]
Continue readingA VBA Coding Manitesto (Part 2)
In the first part of my manifesto, I outlined why I think we should really change the way we code. The important takeaways of that article were: (1) the Hungarian Notation coding style is old and should no longer be preferred; (2) we cannot simply code for ourselves anymore; and (3) the implications of the […]
Continue readingA VBA Coding Manifesto (Part 1)
A little while ago, I made a blog post on why I think we no longer need Hungarian Notation. Truthfully, it’s not the first time I’ve advocated for doing something against the grain. My blog on the principles for app/game development with Excel argues you should keep most of your procedures in the sheet object […]
Continue readingIt’s time to say “Goodbye,” to Hungarian Notation
Most of us code using the Hungarian notation style when writing VBA code. Basically, that’s when you prefix an abbreviated description of a variables’ type or class in front of its name. For example, the ‘d’ below is a prefix for a variable of type double. You get the idea. 1: Dim dDouble As Double […]
Continue readingIt’s time to say “Goodbye,” to Hungarian Notation
Most of us code using the Hungarian notation style when writing VBA code. Basically, that’s when you prefix an abbreviated description of a variables’ type or class in front of its name. For example, the ‘d’ below is a prefix for a variable of type double. You get the idea. 1: Dim dDouble As Double […]
Continue readingI’m coming to San Francisco!
That’s right, if you’re in the San Francisco bay area, don’t miss an exciting Excel workshop on March 20th, 2014. I’m now a team member of Excel and Access LLC, a full-service Excel and Access training and development consultancy. We’re doing an Excel workshop at the eMetrics Summit and we’d love it if you joined […]
Continue readingI’m coming to San Francisco!
That’s right, if you’re in the San Francisco bay area, don’t miss an exciting Excel workshop on March 20th, 2014. I’m now a team member of Excel and Access LLC, a full-service Excel and Access training and development consultancy. We’re doing an Excel workshop at the eMetrics Summit and we’d love it if you joined […]
Continue readingEffective means of display in Excel
There are many great articles and tutorials on how to build interactive data displays in Excel. However, there are few articles on how best to effectively display data in Excel. I think this is an important subject that every Excel user should at least think about. On the other hand, I personally don’t like any […]
Continue readingExcel Holiday Card
Wishing everyone a happy holiday and a terrific new year! Download file: Happy Holidays.xlsm
Continue readingMiami Valley XL User Group
Based on the great reception Rob Collie has had in Cleveland, I am attempting to create an XL User Group here in the Miami Valley area. Do you live in our around Dayton, Cincinnati, or Columbus? Would you be interested in attending/hosting an Excel user group in these areas? If so, please send me your […]
Continue readingExcel MVP Award
On October 1st, I was surprised to see I had been recognized by Microsoft as a Most Valuable Professional (MVP) in Excel. When I first began my career as a developer, I looked to the MVP community for their experience, wisdom, and guidance. I had never thought I might one day join their ranks. I’m […]
Continue readingExcel 3d Maze Update!
Pedro Wave made a few updates to the 3d Maze spreadsheet that I really love. Please download the latest version to see them for yourself. Also, be sure to checkout his blog. maze-example.xlsm
Continue reading