This article is made especially for those who regularly export large data volumes to Excel in order to analyze them or process some kind of regular report. Usually, we...
I must say right from the beginning that even though this process is possible, I do not recommend it (but I will show it to you anyway) :). Launching...
Import of Excel sheet or csv file into SQL Server is a quite common task. You can find a guide on how to do it below. Let’s have an...
Did you ever need to compare 2 lists and test it for duplicities? The easiest way to do it in Excel is to use standard functions as VLOOKUP. Sometimes...
Powerpivot in excel is an add-in automatically pre-installed in MS Office 2013 + (all you need to do is add it to the ribbon). It is not present in...
Powerpivot is an excel add-in enabling data modeling and analysis in familiar Excel environment which is certainly an advantage. Import big amounts of data through Power Query and connect...