🔥 GROUPBY + PIVOTBY = Recreating PivotTable Drill Down with Excel’s New Functions! скачать в хорошем качестве

🔥 GROUPBY + PIVOTBY = Recreating PivotTable Drill Down with Excel’s New Functions!

How to re-create the PivotTable drill down feature with Excel formulas such as GROUPBY and PIVOTBY. This video shows two ways of creating drill down with formulas in Excel. One requires a very small piece of VBA code and the second way has no VBA. Formulas such as the GROUPBY function and PIVOTBY function are changing how we build reports and the creativity brings endless possibilities. 📚 Resources Practise file to follow along https://computergaga.com/_excel/files... 🎥 Related Videos    • Finally, an EASY Way to Calculate Per...   - PERCENTOF function with GROUPBY and PIVOTBY    • 11 Excel PivotTable Tips 💡 in Under 1...   - 11 PivotTable tips in 11 minutes    • Excel FILTER: Non-Adjacent Columns Dy...   - Choosing specific columns for array formula    • Excel FILTER Function - Is this the B...   - FILTER function in Excel ⌚ Timings 00:00 Drill down with Excel PivotTables 01:10 Writing a GROUPBY function 02:51 FILTER function for Show Details page 03:59 Hyperlinks for drill through 05:51 VBA to capture clicked value 07:01 Drill down with formulas - No VBA 07:47 Checkboxes for interaction 08:33 Prevent multiple option selection 10:30 XLOOKUP to find checked value Find more great free tutorials at; https://www.computergaga.com ** Online Excel Courses ** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ►   / alanmurray-computergaga   Instagram ►   / computergaga1   Twitter ►   / computergaga1   TikTok ►   / computergaga   #excel #excelformulas #exceltricks