New Excel PIVOTBY and GROUPBY Function скачать в хорошем качестве

New Excel PIVOTBY and GROUPBY Function

PIVOT and GROUPBY Functions in Excel - Is this the end of Pivot Tables? 👉 Learn the complete Power BI, Excel and Data training: https://comunidadedashmaker.com.br Summary Discover the powerful new Microsoft Excel functions: GROUPBY and PIVOT! In this video, we explore how these tools revolutionize the creation of Pivot Table-type reports, offering instant updates. Learn how to: • Use GROUPBY to summarize data by grouping ranges • Apply PIVOT to create reports in two dimensions • Use the PERCENTAGEBY function for percentage calculations -------------------------------------------------------------------------------------------------- 📂 Download the spreadsheet here: https://bit.ly/planilha_pivotar_agrup... -------------------------------------------------------------------------------------------------- Contents of this lesson: 00:00 Start 01:05 Inserting a Pivot Table for comparison 02:40 PIVOT Function 05:10 Comparing the PIVOT Function with a Pivot Table 07:10 PIVOT Function with Multiple Columns 11:05 PIVOT Function with Multiple Aggregation Columns 11:46 PIVOT Function with Multiple Non-Adjacent Aggregation Columns 12:57 PIVOT Function with Multiple Aggregations 15:00 PIVOT Function - handling Total and Subtotal 16:22 Conditional Formatting to highlight Total and Subtotal 17:46 PIVOT Function with Filters 20:18 PIVOT Function with PERCENTAGE OF 21:01 PIVOT Function with Multiple Sources 23:06 GROUP BY Function -------------------------------------------------------------------------------------------------- 👉 Subscribe to our channel:    / minhasplanilhasbr   👉 Turn on notifications (just click on the bell🔔)! 👉 Leave your like! --------------------------------------------------------------------------------------------------- Follow everything about Power BI and Excel on other social networks: 👉 Instagram:   / gerson.mvp   👉 LinkedIn:   / gersonggv   --------------------------------------------------------------------------------------------------- #excel #pivot #groupby