Looking into some programming task is sometimes challenging. You may think that the answer is quite simple, but actually someone has decided to make you sweat. In this task  you should read one line from the console and print the sum …

C# – Taking only numbers from array and working with them – (The Horror) Read more →

After writing some articles for linear regression here and here, I have decided to get a little deeper into the Excel Data Analysis Tool. Pretty much, what it does is providing a lot of statistical information for a set of data. …

Excel Data Analysis Tool – Descriptive Statistics – Simple Explanation Read more →

Some time ago I wrote an article explaining linear regression. If you have no understanding about the method, I recommend that you read it. Now I am going to build upon this article, using the same example as from it and …

MS Excel – Linear Regression (2) Read more →

After showing some tricks for VBA MS Access, I have decided to go back to the field again to find a way to export a table in HTML format. Actually, VBA and Microsoft have taken care of the issue (no …

VBA – Access – Export a table in HTML and other tricks Read more →

In this article, I present 5 useful Excel worksheet based tricks: Set a date and time for the beginning of the latest update on the sheet; Color the changed cells in red; Change the sheet name based on the value …

VBA – 5 Excel Worksheet Based Tricks Read more →

In this article I present a code from the book “Pro WPF 4.5. in C#“, which I consider useful and interesting. This example has impressed me with its structure – it simply gives good practises for creation of 23 different …

C# – WPF – 23 Well Written WPF Control Examples Read more →