In the current article I proudly present a simple application, which creates a simple Excel file from XAML. In the example I present I am using Excel 2010 as this is my current version. In order to be able to …
In this article I present a good possibility to customize your Active Window from Excel itself and not from the ribbon. By inserting some form controls, we receive a decent-looking customization dashboard like the one below: The idea of the …
Changing formulas to values is something really easy in MS Excel – what the majority of people (including me) would do the following – simply record a macro, where you select all cells and paste them as values. The result …
Probably, if you are programming with Excel as much as me, one day you have the following question – all the pictures in Excel are generated by my code and I really do not care to give them names. I …
VBA – How to delete quickly all pictures from Excel? Read more →
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 …
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, …
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 …