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!
- C# – Reading from Excel Spreadsheets with Asynchronous Programming (Async)Reading from Excel in C# is actally not at tough as many VBA developers would assume. The simple reading is actually quite straightforward – there is only small little trick, requiring the adding of the Microsoft.Office.Interop.Excel reference to the Visual…Read more ›
- C# – How to get the last filled cell of a given row in ExcelGetting the last row of a given column in Excel with a formula or with VBA is quite a trivial task. It is explained here quite well 🙂 However, when we come to C#, the only “trick” that is provided…Read more ›
- C# – Find the Biggest Square in a Matrix – What can Excel and VBA add to it?Finding the biggest square of specific units in a given matrix of these units is a standard dynamic programming problem. The examples in Google for it are above 18 million, thus I would simply show how it is done with…Read more ›
- C# – Refactoring a ProblemSome days ago I have decided to take a look at one of the homeworks problem of the OOP course at SoftUni. Then, I have decided to solve it with my VBA OOP knowledge, implementing it in C#. Whether VBA…Read more ›
- C# – Quick Reference for Abstract ClassesAbstract Classes in C# are classes, intended only to be a base class of other classes. Members marked as abstract, or included in an abstract class, must be implemented by classes that derive from the abstract class. Reference With other…Read more ›
- Python – Customizing PyLab using StyleLearn how to customize PyLab using style in this article by Benjamin Walter Keller, a PhD candidate at McMaster University with BSc in physics with a minor in computer science from the University of Calgary in 2011. This article will delve…Read more ›
- Visual Studio – How to create a custom shortcutIf you want to create a custom shortcut to a command in Visual Studio, these are the steps to be taken: Ribbon>Tools>Options Environment>Keyboard Show commands containing (write the command) Press shortcut keys Assign and OK
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 🙂
