Linear regression is something rather useful for forecasting analysis. If you want to understand more about linear regression, you may go to wikipedia, there you have a wonderful article about it. Long story short, linear regression is an approach, modeling…
In this article with MS Access I will show how to create a good MS Access query, which results in best in class results. Let’s imagine, that we have the following data: In this database, we have four columns –…
In this article I will continue the subject concerning VBA and MS Access. I have thought of a rule of a thumb, presenting only 3 macros per article, thus being sure that the reader does not get bored. Here I…
With this article I am going to present just a few easy Excel Macros, which I have found useful once. The first one is a typical example of loops in VBA and it creates an excel spreadsheet with tabs for…
It is quite challenging and quite not interesting to learn SQL if you are a complete beginner – after reading a lot, about installation of servers and programs many people just quit and state that it is not their thing.…
Hello! In this article I will present a code for the easy export of selected cells into a HTML file. In general, the code functions in the following way: 1. Takes a look at the selected range and performs a…
In this video I perform a check whether a number is an integer or a double. If it is double, it fills out a List<double>(); and if it is integer, it fills out a List<int>(); Once something is entered, which…
I know a lot of people, having problems creating passwords. With the current code I will show you how to create a password using C#. The password consists of at least two capital letters, two small letters, a digit and…
Do you know that VBA can take over all the control over different MS Office applications? This is a simple example how you can open and close a Word application from Excel. In order to do this, you may use…
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…
