Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Dynamic Arrays (How they will change EVERYTHING!). That video is uploaded by Leila Gharani at 2018-10-18T04:32:41-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [2USJsIyIzvo]
| Name | Excel Dynamic Arrays (How they will change EVERYTHING!) |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 18-10-2018 11:32:41 |
| Video Discription | ★★ Link to complete Excel Dynamic Arrays Course: https://www.xelplus.com/course/new-excel-functions-course/ Complex tasks will be done with simple Excel formulas. Everything you wished Excel could do, can now be done! In this video, I take two of my popular videos which use traditional Excel complex formulas and use Dynamic array formulas instead. I also use a timer to test the time needed for the new formulas and compare it to the other videos. Here's what happens: We create a dynamic dependent drop-down list based on a messy data set. The first list includes unique values from cells and the second dependent data validation list filters the values to the ones that belong to the category selected from the first list. I also make sure the list is dynamic so if we add more data to the table, the drop-down list will automatically update (here we use the new dynamic array spill range reference #) I also use the sort function to get sorted names in the drop-down list. We use 3 Excel dynamic array functions: Unique, Sort & filter. LINKS to related videos: Extract unique items for dynamic data validation drop down list - https://youtu.be/7fYlWeMQ6L8 Excel Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set): https://youtu.be/gu4xJWAIal8 Digital Ticking Clock from DrLex1: https://youtu.be/Lsq0FiXjGHg ★ My Online Excel Courses ► https://www.xelplus.com/courses/ ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel 2USJsIyIzvo |
| Category | Education |
| Tags | dynamic array formulas in Excel | excel new formulas | modern array excel | excel unique values for list | excel dynamic data validation range | excel automatic filter refresh | excel unique values formulas | excel dependent drop-down list | excel sorted data validation list | array spill | Leila Gharani | Excel online course | XelplusVis | Excel tips and tricks | Excel hash | unique function | excel sort function | filter function | excel array formulas | dynamic arrays | Microsoft Office 365 |
