Calculating the median in Excel PivotTables
Go to Master Data Analysis Yes, you read the title of this post correctly, you can calculate the median and lots of other functions in Excel PivotTables besides the regular options. If you’re a regular user of Excel PivotTables you might know you can change the summary function: Just right-click inside of the PivotTable → […]
Analyzing 50 million records in Excel
Go to Master Data Analysis A common myth I hear very frequently is that you can’t work with more than 1 million records in Excel. Actually, the right myth should be that you can’t use more than 1,048,576 rows, since this is the number of rows on each sheet; but even this one is false. […]