Excel Dynamic Search Box Tutorial | Find Anything | Multi-Column Search скачать в хорошем качестве

Excel Dynamic Search Box Tutorial | Find Anything | Multi-Column Search

Learn the first steps to optimize any spreadsheet: https://www.excelpowerup.com/training Take your Excel spreadsheets to the next level: https://www.excelpowerup.com/course Get personalized professional support: https://www.excelpowerup.com/support If your data is large and unmanageable, a search box may be just the thing you need to make your spreadsheet more user-friendly! I call these kinds of fun and useful upgrades, “Power Ups”! In this video, I’ll show you step-by-step how to create a magic search box in Excel using the FILTER, ISNUMBER, and SEARCH functions. You’ll also learn about a few key tweaks that can take this feature to the next level. Website: https://www.excelpowerup.com Instagram:   / rebekahoster   LinkedIn:   / rebekah-oster   00:00 Introduction 00:54 Design Search Box 03:46 Insert ActiveX Text Box 06:00 Create Search Results View 06:50 The Formula 09:19 Power Up 1: Gridlines 10:46 Power Up 2: Multi-Column Search 12:01 Note: Partial Matches 12:26 Power Up 3: Exclude Some Columns