How to Fix Misspelled Customer Names with Excel

No video

How to Fix Misspelled Customer Names with Excel

Рет қаралды 2,180

11 ай бұрын

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

Пікірлер: 11

@bhavinsolanki1091 26 күн бұрын

fantastic. i was doing this for last 1-2 week thinking whether its a good practice or not, this video gave me positive feedback. thanks a lot.

@DougHExcel 26 күн бұрын

Keep it up!

@pipo441 11 ай бұрын

That's so interesting. Have to watch it again though.

@DougHExcel 11 ай бұрын

Glad you thought so!

@toptechkit 11 ай бұрын

This is good and can work in some cases. How about where the order of the names is inter-changed. I mean- assuming you want the order to be first name then second name and some names start with the last name then first name.

@DougHExcel 11 ай бұрын

That might mean either an additional lookup or a concat of the data

@Weehawk 11 ай бұрын

Nice!

@DougHExcel 11 ай бұрын

Hi Lachdanan, thanks for the comment!

@nboisen 11 ай бұрын

After creating the lookup table, an alternative to using lookup formulas would be to merge queries in Power Query. The advantage of using queries would be the ease of updating if more customer names are added.

@DougHExcel 11 ай бұрын

Hi Neil Boisen Music, Thanks for the comment and adding to the thread!

@user-fy4yd9tz4w 5 ай бұрын

Shortcuts: MOVING A ROW OR COLUMN : highlight the row you want to move hold down the shift key Click on the border of the call and drag the row or column to its new location that’s it. You will notice, as your dragging the BORDER of the row or column changes to indicate that you were moving the entire row or column. Also, instead of copy / paste, select the cell you want to copy Hold down the Cntrl key and drag it to its new location. This will leave the word or number in the cell and place a copy into the new cell To duplicate into several open BORDERING cells, highlight the cell you want to copy and drag the fill handle down or to the side.