In this video, I provide a comprehensive stepbystep tutorial on using Power Query in Excel to extract and format email addresses from Outlook. I show you how to copy and paste email addresses from Outlook into an Excel worksheet, then with Power Query, I guide you through the process of breaking down that data, separating email addresses and the associated names into different rows.

I also show you how to clean up the data by removing unnecessary spaces using the TRIM function. My tutorial concludes with a demonstration of how adding more emails to the Excel spreadsheet automatically updates the Power Query, ensuring ongoing efficiency in managing your email lists.

My Excel and Teams courses are available here:
https://courses.chrismenardtraining.com

Chapters:

00:00 Introduction
00:24 Setting Up Excel and Outlook
00:37 Copying Emails from Outlook to Excel
01:19 Preparing Excel for Power Query
01:27 Using Power Query to Split Emails
02:46 Further Splitting and Cleaning Data with Power Query
04:05 Finalizing and Loading the Data
05:21 Updating the Data with New Emails
05:50 Conclusion

And make sure you subscribe to my channel!

EQUIPMENT USED
○ My camera – https://amzn.to/3vdgF5E
○ Microphone https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights https://amzn.to/3vaxyy5
○ Dual monitor mount stand https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount https://amzn.to/3g96FGj
○ Boom Arm https://amzn.to/3g8cNi6

SOFTWARE USED
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#chrismenard #excel #powerquery