Скачать с ютуб Introducing two new Excel functions: GROUPBY and PIVOTBY в хорошем качестве

Introducing two new Excel functions: GROUPBY and PIVOTBY

Two exciting new functions were announced last week: GROUPBY and PIVOTBY. These provide a powerful yet simple way to perform data aggregations using a single formula. ❖ GROUPBY — aggregates a range of values by row group. ❖ PIVOTBY — aggregates a range of values by row and column group. One of the downsides of regular pivot tables is having to right-click on one and select Refresh to update it. These functions solve that problem by dynamically updating any time you change the source data. Both are currently only available to Microsoft 365 Insiders on the Beta Channel, so you'll have to wait a while before they reach the production version. You might also notice a few bugs, such as column headings not appearing and missing AutoComplete boxes for arguments. No doubt these issues will be ironed out, though! To find out more information about GROUPBY and PIVOTBY, head to https://techcommunity.microsoft.com/t.... Also, check out our blog post at https://globalexcelsummit.com/post/in.... If you've already played around with the functions, what are your initial impressions? #exceleration #excel #microsoftexcel #excelformulas #exceltips #exceltricks #globalexcelsummit --- The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts. Find us on: 🌐 Website: https://globalexcelsummit.com 👔 LinkedIn:   / global-excel-summit   🆇 X: https://x.com/ExcelSummit 🤳 TikTok:   / globalexcelsummit   📸 Instagram:   / globalexcelsummit   🟦 Facebook:   / globalexcelsummit   🧵 Threads: https://www.threads.net/@globalexcels...