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!
- VBA – Add Shape to Range in ExcelAdding shapes to a range in VBA with Excel is actually a trivial task, if you are aware of the Shapes.AddShape method. It has 5 parameters, 4 of which could be pretty easily remapped to the parameters of the range:…Read more ›
- VBA – Animation with ExcelAnimation consists of some pictures. In general, there are about 24 pictures per second, in order to do the “magic”. This could be easily automated with Excel, using [crayon-5c19d0355e585134352749-i/], if we agree to make it a bit old-fashioned, with 1 picture…Read more ›
- VBA – Extracting text from string between two identical characters using VBAAutomation of Excel is actually pretty interesting task. VBA is indeed the best built-in tool for this and although there is a lot of “hate” towards it it really deserves to be taken into account seriously, at least for small daily…Read more ›
- Python – Balancing CartPole with Machine LearningThis article will show you how to solve the CartPole balancing problem. The CartPole is an inverted pendulum, where the pole is balanced against gravity. Traditionally, this problem is solved by control theory, using analytical equations. However, in this article, you’lllearn to solve the…Read more ›
- VBA – RegEx Used to Take the Valuable Data OutWriting for RegEx in VBA is sometimes a good idea and sometimes a bad idea. Anyway, if you need to write one, you better be careful. These are the RegEx articles in VBA in VitoshAcademy so far: http://www.vitoshacademy.com/vba-regex-in-excel-part-2/ http://www.vitoshacademy.com/vba-regex-in-excel/ So,…Read more ›
- VBA – AutoMacro AddIn – VBA Software ReviewVBA is extremely underestimated programming language. I have always been thinking that there are almost no real #VBA developers, because the “real” developers do not want to do some meaningless “macro” stuff and the people who work with #VBA are…Read more ›
- NumPy Fast Operation and ComputationsLearnNumPy fast operation and computations in this article by Alberto Boschetti, a data scientist with expertise in signal processing and statistics and Luca Massaron, a data scientist and marketing research director specialized in multivariate statistical analysis, machine learning, and customer…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 🙂
