This article is made for those who regularly export data from some database to Excel in order to analyze them or process some kind of automated report (using formulas...
Right from the beginning let’s be clear. Even though this process is possible, don’t use it as your standard process. Instead use How to Execute SQL Query in Excel...
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...