Tag: data-analysis

In Part I of our introduction to Microsoft Excel and Pivot Tables, we transformed raw data into a proper Excel Table and created our very first Pivot Table—only to discover that, by itself, it doesn’t do much. In Part II, we finally bring that Pivot Table to life. This is where we start slicing, grouping,…

Please find the accompanying source data here: GitHub. This article assumes a modern version of Microsoft Excel running on Microsoft Windows. Part I: Creating a New Pivot Table Microsoft Excel is a technical gateway drug. Once you understand the basics—rows, columns, cells, ranges, data input, data formatting, basic formulas—Excel over time reveals its true power.…