DATA CLEANING IN EXCEL USING AI
DATA CLEANING IN EXCEL USING AI | YData Cleaning Made Easy with ChatGPT | Excel+AI
Download Practice Excel File - Click here
Topics in This video
00:00 Introduction to AI 00:36 Introduction to Row data 03:13 Remove extra space and line break with formula 05:38 Remove extra space and line break using find & replace 06:20 Remove blank rows 08:11 Convert general to Date format using cell formatting and short key 11:20 Split text using Text to column option 13:55 Split Text to column with formula 16:33 Split text to column 17:42 Analyze data to City wise total sold quantity using Pivot table 19:12 Analyze data to City wise total sold quantity using Analyze Data tool 20:15 Insert Timeli
Download Practice Excel File - Click here
Download Practice Excel File - Click here
Watch more video for Excel+AI or AI in MicroSoft please visit our YouTube Channel:
ne in pivot data
Post a Comment