breakCorporateYou’re not Good at Excel and you don’t even Know itV-Lookups and Pivot tables dont make you an expert.Jul 18, 2016Jul 18, 2016
breakCorporateVBA — String ParsingString parsing involves looking through each character in a string. Typically it is best to split the string on spaces or another indicator…Jul 10, 2016Jul 10, 2016
breakCorporateVBA — Functions vs. SubsThere are two methods in VBA — functions and subs. A sub does not return any value while a function must return a value. Functions and subs…Jul 10, 2016Jul 10, 2016
breakCorporateVBA — Bubble SortA bubble sort is a technique to order items in an array. They can be set in either ascending or descending order. It is possible to output…Jul 10, 2016Jul 10, 2016
breakCorporateVBA — Add Items to an ArrayArrays in VBA are a little finicky and require a different procedure than programming langauges like C or Python. In VBA you cannot append…Jul 10, 20161Jul 10, 20161
breakCorporateAutomate Excel MonotonyAh, end of the month again and I need to setup those fucking reports. Every month it’s the same thing with one little change. Fuck it, it’s…Jul 9, 2016Jul 9, 2016