In this article I will show how to make custom MS Formulas. This is quite useful, if you want to use a formula, which is not available in the predefined Excel formulas. The inspiration for this article came, after I …
So, in this post I will show you a puzzle game in MS Excel – it is like the old one, the kids from the ’90s used to have, before we had PCs. So, the excel file is here, just …
Hello All, I have created a small video, showing how to make use of the do-while loop for creation of small console applications. The interesting part of the code is the usage of the do-while loop, which executes the code …
An hour ago I had to look for duplicate values in a spreadsheet. I looked for a minute in google and found plenty of solutions, as you can imagine. One of the best was described here, but it is quite useless, …
I have just made my first YouTube video!In it I create a matrix and I fill it up, using different directions. The size of the matrix is read from the Console. Or with other words, if the number is 5, …
Lesson 1 – VBA and Excel What is VBA? – VBA is something great, if you are working more than 1 hour with MS Excel and MS Access. It is simply said a must for everyone, who earns his money …
This is part the first C# problem, from arrays, given at Telerik C# 2 courses. Check it out. The problem itself is put as comments in the first two lines. In general, one should write a simple console application, which …