This category groups all articles that are in some way related to Excel. For more detailed filtering, direct your attention to one of the thematically focused categories below
Don’t miss out from category:
Weighted arithmetic mean is a statistical value of broad use not only in mathematics or statistics. If you need to calculate weighted arithmetic mean in Excel, here is a guide How Works Function SUMPRODUCT and Weighted Arithmetic Mean in Excel Example: Lets have few loans where every loan has different principal and interest rate. The… 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 »
In Excel, we work mostly with numbers (aggregation via SUM, AVERAGE, etc.) or with dates. However, it is true that very often we need to adjust, combine or clean text columns. There are many situations where we want to edit the text in some way (it cannot be generalized). It depends on a case-by-case, but… Read More »
The VLOOKUP function is one of the most commonly used Excel functions in general. This function returns a value we are looking for from a particular column of a table containing many rows and columns. The function supports 2 modes – full and approximate match. In addition to the VLOOKUP function, there is a similar… Read More »
Let’s start with what the average means. In terms of descriptive statistics, the average is a certain reference (typical) value. It is a property of the data set that we are investigating. It belongs to the so-called measures of central tendency. If we have a large amount of data, we can describe the data with… Read More »