Imagine saying goodbye to tedious data cleaning forever – and letting AI do the heavy lifting in Excel!

Today, I’m going to show you how to use ChatGPT to supercharge your spreadsheet work.

If you want to standardize data, generate dummy information, and even run complex analyses with just a few clicks, stick around!

In this video, we’ll explore how you can use ChatGPT to:

Deal with inconsistent Date Formats
Clean up Data
Create Formulas
Analyze Text
Extract information from Web Links (URLs)
Split Structure Data using Formulas
Make Sentiment Analysis on Long-Form Text
Classify Data with Formulas
Generate Dummy Data for Excel

2025-03-01_10-38-09-f7dc66235da75e8eddb9c6847807a021.png

I hope you will find the techniques—from cleaning up dates and standardizing data to extracting URL information and even splitting text or using sentiment analysis—both exciting and useful!

I’d love to hear from you, so please drop a comment sharing your thoughts or any challenges you encountered while trying these methods.

https://www.youtube.com/watch?v=P1ZxSzZPNlc

Happy analyzing!

Andreas

2025-03-01_10-38-10-5354e1d79936679c74bf0ab2389b3aaa.jpg

Andreas Exadaktylos

Teacher | Expert Computer Scientist | Entrepreneur

2,084

148