Programming and Analysis
What can one do with some knowledge of these two?
The idea is to show my knowledge about programming and business analysis.
I present any code, that I find interesting (usually C#, VBA, Python or JavaScript) and I comment it. Reviews of IT books can be found as well. I hope you find something interesting here!
- Excel – Get Top Row of a Multi Row / Mult Column Range=VLOOKUP and =INDEX(MATCH(),MATCH()) are well known formulas, if you need to get some value corresponding to another value from a specific column. The problem comes, when you are having more than one column or row, and you need to locate the…Read more ›
- VBA – Read different levels of XMLAfter the article here for VBA – Select a Single Node XML now I am writing an update from it, which shows how to loop through all the nodes that we are interested in and get data from them. The XML is…Read more ›
- Python – Write Values in all Worksheets of existing Excel FileWorking with VBA is usually not considered high level of programming. Still, when it comes to Excel, this is probably the best solution. However, Python has some libraries which can help a bit, if you are willing to “mimic” the…Read more ›
- VBA – Fill Numbers in a Given RangeSo, the idea is the following – imagine that you have an NxN range, which should be filled out with consecutive numbers. Thus, if the range is 6×6, you start filling the numbers normally and once you reach the 6.…Read more ›
- Format and Color Text in Excel Cell with VBAFormatting a substring of a string in an Excel Cell is actually quite a challenging task. There are two ways to do it – select part of the substring that you wish to format and change its color. Then make…Read more ›
- How to Change Tab Color in Excel with VBAChanging tab color of Excel is somehow useful. With VBA, it is easily programmed, as far as one can use the macro recorder to see the correct way to do it. However, if you need to change the color of…Read more ›
- VBA – Using Parameters in a VBA SQL Query To a DatabaseIn this article I will simply use the code from my first guest author Mathieu, to build up some small working solution, that uses parameters: So, the two classes, provided by Mathieu are here as well GitHub, named AdoValueConventer.cls and SqlCommand.cls.…Read more ›
Python Summit in Berlin is coming! With talks mainly in German and some in English! And if you want to explore Machine Learning, you can always change the room and go to the ML Summit, which is literally next door.
Absolutely NOTHING! Open a simple Excel file and start building your own magic there! It is THAT easy! Really, if you become even quite a little aware of VBA in Excel you will be among the best Excel-Table makers in your company 🙂
