You'd think that PivotTables are the easiest and least stressful way to summarize data in Excel. For a long time, I believed that, too. That changed once I got comfortable enough using GROUPBY and PIVOTBY. These functions let me build summaries that behave like living parts of my worksheet rather than isolated report islands that need to be refreshed, rebuilt, or tweaked every time the underlying data changes.
via MakeUseOf https://ift.tt/Rmyh6xt
Comments
Post a Comment