I regret that I did not learn this AI feature in Power Query sooner.
This video demonstrates the use of a very useful AI feature in Powerquery that helps ease data cleaning activities.
If you want to follow along then the dataset I have used can be found at the following site
https://www.thespreadsheetguru.com/sa...
Must watch videos for your data analysis skills
Link to my video demonstrating AI features in excel can be found below:
• This AI feature will change the way you us...
Link to my data analysis using online excel series can be found below:
• Microsoft Excel tutorial - Data Analysis
If you interested in learning how to do data analysis using pandas and ChatGPT do check the link below:
• How to analyse data using ChatGPT and pandas