Рет қаралды 2,180
In this video, we'll show you how to fix misspelled customer names using a PivotTable and the XLOOKUP function. Pivot tables are a great way to automatically view customer data in your data, and XLOOKUP is a handy tool for making sure you can focus on a common name for your customers.
Whether you're a business owner or a data analyst, this video is a must-see! We'll show you how to use Pivot tables to view customer data, and then we'll demonstrate how to use XLOOKUP to correct the "spelling" or format of customer names. With this information, you'll be able to quickly and easily fix customer data in your data!
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoff...
#excel
#msexcel
#doughexcel