As analysts, the ability to summarize and aggregate data on the fly is an essential skill. Traditionally, PivotTables have been a popular method for this purpose. However, a new, function-driven approach has emerged. In this post, we’ll explore the basics of the GROUPBY() function for creating dynamic data summaries. You can follow along using the … Continue reading How to understand the GROUPBY() function in Excel