Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!). That video is uploaded by Leila Gharani at 2019-10-24T02:00:03-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [EggDjAL8k4Y]
| Name | Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!) |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 24-10-2019 09:00:03 |
| Video Discription | Join 400,000+ professionals in our courses here ๐ https://link.xelplus.com/yt-d-all-courses With this Excel trick you can use a formula to show all the external links in your Excel workbook in one place. This way you can keep an eye on where the data is coming from and if any link is pointing to the wrong workbook. With this Excel hack you can also write a formula to get the list of files from a specific directory and bring it to your Excel sheet. So if you're waiting for your colleague to add a file to a directory, you'll be able to see it in your Excel formula results once you refresh the list. The fun part about this Excel trick is it combines 4.0 Excel Macros with Excel dynamic arrays. You can use the Excel Transpose function to get a vertical list of external links for file names. ๐ Key Points: - Track External Links: Learn a swift method to list all external links in a workbook, bypassing the traditional step-by-step approach. - Dynamic Array Spill Feature: Utilize Excel's latest calculation engine to get a spilled range of links, displaying them horizontally or vertically using the transpose function. - Creating Custom Excel 4.0 Macros: Discover how to create names for Excel 4.0 macros to perform specific functions, such as 'Get Links' and 'Get Files'. - File Directory Listing: See how to generate a list of all file names in a specified directory, using wildcards and dynamic arrays. - Sorting and Filtering Data: Explore the use of the SORT function and file extensions to organize and filter the list of files. - Saving Files with Macros: Understand the importance of saving files with Excel 4.0 macros as an XLSM file to retain new functionalities. โฏ Blog post is here: https://www.xelplus.com/excel-external-links-trick-dynamic-arrays Bob's Excel Magic book on Amazon: https://amzn.to/2oVFRln All about Excel's NEW Dynamic arrays - check out the complete playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP โ 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 EggDjAL8k4Y |
| Category | Education |
| Tags | XelplusVis | Leila Gharani | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts | Microsoft Excel tutorials | Microsoft Excel | Excel 2016 | Excel 2013 | Excel 2019 | excel external links | edit external links in excel | excel find external links | no vba | excel formula to get links | excel 4.0 macro | Excel LINKS | Excel FILES | Excel dynamic arrays | excel magic formula | bob umlas excel | excel hacks | excel tricks | get list of files in folder |
