Many people change direction in their careers. Some of us would call that growth. When something grows, it usually builds a healthy base from the ground up before it blossoms. The positions for people that participate in data science are … Continued
I have loved teaching this content in Crystal Reports over the years. The concepts presented in training in this course are critical for successful reports. The “letter writing” is an additional bonus for people because it causes us to stretch … Continued
I started my formal training career in August 2000 in Birmingham, Alabama. It wasn’t long after that I was teaching the basics of HTML 4 coding…We used notepad in those days. It’s important to start there because that is where … Continued
UPDATE VIDEO: https://youtu.be/JzrwsPdFeIg I decided to write this blog post because in doing my analytic research on my blog from a hundred years ago - http://www.knowledgeworkerblog.com that this has been my most popular post - http://www.knowledgeworkerblog.com/2008/10/make-cells-grow-when-you-type-in.html. I posted it in Excel 2007 version … Continued
I thought it would be fun to show you how to not display ugly valid errors, like DIV/0, when it’s there because there is a 0, but doesn’t need to show, because everyone knows that it’s zero. Also love to get … Continued
We are working on our newest guides. We thought it might be fun to share with you one of our current mockups. If you learn something from it – please like and it and share it!
The STEM field does not exist in a vacuum. Rather, studies have shown that many STEM jobs will stimulate employment in other sectors, some of which are non-STEM related. Mark Mills and Anthony Mills of The Pacific Standard argue that … Continued
In 2011, Liana Christin Landivar found that “there were 7.2 million STEM workers aged 25 to 64, accounting for 6% of the workforce.” This may not seem like a lot, but this appears to account for strictly STEM related fields. … Continued
Perhaps this statement is a tad too obvious. The Brookings Institute, in their on-going studies of STEM jobs and the US economy, have determined that metropolitan areas with higher STEM knowledge (i.e. individuals with BA’s or MA’s in STEM, STEM-related … Continued
Our latest project? Building data warehouses or marts. How we do this is by training the end users how to use the tools that IT has diligently put in place. We meet great end users all the time. They aren’t … Continued
Excel VBA Loops Here are some great places for code on loops in Excel, no two scenarios are exactly the same…but you can use this to get started… http://support.microsoft.com/kb/299036 http://stackoverflow.com/questions/1128841/how-to-loop-through-rows-columns-in-excel-vba-macro http://stackoverflow.com/questions/17001631/excel-vba-looping-through-rows-and-copy-cell-values-to-another-worksheet http://www.ozgrid.com/forum/showthread.php?t=64445 Remember, if you’re not frustrated – then you’re … Continued