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 connected to imported dataset) like I do regularly for some of my clients. Usually, we insert the data into Excel simply by copying it from some… Read More »
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 – Tutorial with Examples. But I will show you anyway. Processing SQL queries through procedures in Excel is not optimal in general, but sometimes there is… Read More »
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 excel file containing data on companies: Steplist – Import Excel to SQL Database Example 1) Data import… Read More »
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 though, we might need to compare 2 lists where one of them contains typos. Here, Fuzzy lookup comes into play (can be downloaded here). Typical example… Read More »
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 previous Office release therefore it is needed to download it, install and then allow. Enabling Power Pivot in Excel Download add-in from following URL (Windows 7… Read More »
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 them to each other using PowerPivot One of the upsides of power pivot is possibility to connect multiple data sources into one excel. It even do… Read More »