Calculating the median in Excel PivotTables

Calculating the median in Excel PivotTables

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 → Go to Summarize Values By […]

Analyzing 50 million records in Excel

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. In this post I’ll debunk […]

PivotTable Week – Learn all about PivotTables

With PivotTables you can process thousands (or millions) of rows extremely fast and show the results in dynamic charts called PivotCharts. During the week (June 13 – 19, 2016) we shared several posts that ranged from very basic knowledge (how to create PivotTables) up to more advanced topics (VBA/Power Pivot). The posts were shared through […]

12 Top Excel Tips for Data Analysts

Have you ever asked yourself any of these Excel questions: How do I fill empty spaces on a table with the content above? Is there a way to automatically expand the source for a dropdown list, formula or PivotTable? How can I quickly see the overall trend of a series of data points? It is […]