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!
- Last Used Row (Last Used Column) in Excel with Formula (without VBA)Getting the last row of a given column in Excel is easily done with a User-Defined Function in VBA: [crayon-5bcd5eb0e3952699727820/] There are two other formulas, which would get the last used cell in a given row, depending on whether it…Read more ›
- C# – Split String in One Line and Get the First SubStringImagine, that you are given a string in C# with some separator in it, and you need to split it and refer to the first or the second part of the splitted string. E.g., you are having [crayon-5bcd5eb0e4470286173128-i/] and with one line,…Read more ›
- VBA – How to handle only specific errors in VBASometimes, but only sometimes, someone needs to handle specific VBA errors and to avoid them. Or to ignore them. Or anything like this. Let’s say, you want to avoid error number 91, because you think that it is a case…Read more ›
- Using NumPy for SimulationsLearn how to use NumPy for simulations in this tutorial by Alvaro Fuentes, a data scientist with an M.S. in quantitative economics and applied mathematics with more than 10 years of experience in analytical roles. NumPy, also known as Python’s vectorization solution,…Read more ›
- Add comments in Excel with VBAAdding comments with VBA is somehow quite a trivial task, if you already have the text of the comment and you are allowed to delete the comment if it is present. In general, the only difficult part is the check,…Read more ›
- Hashing Passwords in PythonLearn how passwords can be stored without a risk of leaking them in this tutorial by Alessandro Molina, a Python developer since 2001 and currently the core developer of the TurboGears2 web framework and maintainer of Beaker Caching/Session framework.While cryptography is…Read more ›
- Call Stack Dialog Box in VBACalling the stack dialog box in VBA is actually a very useful feature of the VBA Editor. This is what the Microsoft documentation says about it: Displays a list of currently active procedure calls during break mode. When executing code…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 🙂
