Data Tab has your sort and filter options Learning how to sort and filter in Excel is pretty important. Here’s how to find the commands you need. Remember clean nice data behaves best. If you have a clean data set … Continued
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
You do realize that you can learn a lot from quality video content in ten days? You may be practicing a new method of learning that you can use for the rest of your work life. There is so much training content online. I wouldn’t … Continued
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 years ago because … 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!
VBA Code to add Excel worksheet in Excel 2007 This code adds a new worksheet. If you leave it as is it will just add the next sheet in the count… if you run in and you have three sheets, … 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