Скачать с ютуб Excel Users LOVE These Two Functions! (TAKE & DROP in Excel) в хорошем качестве

Excel Users LOVE These Two Functions! (TAKE & DROP in Excel)

The TAKE and DROP functions in Excel are quickly becoming two of my favourites. They make array shaping so easy - and in this dynamic array era, this is important. This video has it all! There is a debut for the TRIMRANGE function and also appearances from HSTACK, GROUPBY and XLOOKUP. Grab your copy of Advanced Excel Formulas https://www.amazon.co.uk/Advanced-Exc... 📚 Resources Practise file from the video - https://computergaga.com/_excel/files... GROUPBY function tutorial - https://www.computergaga.com/excel-gr... 📺 Related Videos    • Finally, an EASY Way to Calculate Per...   - PERCENTOF function in Excel    • Moving Average in Excel (Seven-Day Ro...   - Seven-day rolling average function    • Excel FILTER: Non-Adjacent Columns Dy...   - Get non-adjacent columns from arrays ⌚ Timings 00:00 TAKE and DROP in Excel 01:03 Take the last column 03:53 Sum last 6 columns 04:38 With XLOOKUP 07:05 TAKE with TRIMRANGE 09:56 Top 10 list 11:07 Remove headers from GROUPBY 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 #learnexcel