{"id":1534,"date":"2025-12-23T08:49:55","date_gmt":"2025-12-23T08:49:55","guid":{"rendered":"https:\/\/hlrnet.com\/sites\/ebp\/?p=1534"},"modified":"2026-02-19T19:50:57","modified_gmt":"2026-02-19T19:50:57","slug":"these-excel-functions-just-made-pivottables-obsolete-for-me","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/sites\/ebp\/these-excel-functions-just-made-pivottables-obsolete-for-me\/","title":{"rendered":"\u00abThese Excel functions just made PivotTables obsolete for me\u00bb"},"content":{"rendered":"<p>These Excel functions just made PivotTables obsolete for me<br \/>\n<a href=\"https:\/\/www.makeuseof.com\/groupby-and-pivotby-versus-pivot-tables\/\" class=\"autohyperlink\">www.makeuseof.com\/groupby-and-pivotby-versus-pivot-tables\/<\/a><\/p>\n<section id=\"article-body\" class=\"article-body \">\n<div class=\"content-block-regular\">\n<p id=\"groupby-the-one-axis-wonder\">GROUPBY the one-axis wonder &#8211; Because who actually needs bells and whistles for basic summaries<\/p>\n<div class=\"valnet-gallery images-count-5\"><\/div>\n<p id=\"pivotby-the-two-axis-power-move\" class=\"adsninja-injected-repeatable-ad-beforebegin\">PIVOTBY the two-axis power move &#8211;\u00a0The overachiever of data summaries<\/p>\n<p>Most Excel users are still using Pivot Tables, but this new function is faster<br \/>\n<a href=\"https:\/\/www.makeuseof.com\/pivotby-instead-of-pivot-tables\/\" class=\"autohyperlink\">www.makeuseof.com\/pivotby-instead-of-pivot-tables\/<\/a><\/p>\n<\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>These Excel functions just made PivotTables obsolete for me <a href=\"http:\/\/www.makeuseof.com\/groupby-and-pivotby-versus-pivot-tables\/\" class=\"autohyperlink\">www.makeuseof.com\/groupby-and-pivotby-versus-pivot-tables\/<\/a> GROUPBY the one-axis wonder &#8211; Because who actually needs bells and whistles for basic summaries PIVOTBY the two-axis power move &#8211;\u00a0The overachiever of data summaries Most Excel users are still using Pivot Tables, but this new function is faster <a href=\"http:\/\/www.makeuseof.com\/pivotby-instead-of-pivot-tables\/\" class=\"autohyperlink\">www.makeuseof.com\/pivotby-instead-of-pivot-tables\/<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[30,33],"tags":[24],"class_list":["post-1534","post","type-post","status-publish","format-standard","hentry","category-en","category-tools","tag-excel"],"publishpress_future_action":{"enabled":false,"date":"2026-04-30 22:56:43","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts\/1534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/comments?post=1534"}],"version-history":[{"count":2,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts\/1534\/revisions"}],"predecessor-version":[{"id":1632,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/posts\/1534\/revisions\/1632"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/media?parent=1534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/categories?post=1534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/ebp\/wp-json\/wp\/v2\/tags?post=1534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}