Excel’s automation features are faster than ChatGPT, but most people never find them in the menus
It’s very likely that you’ve tried to clean, sort, or analyze your data using ChatGPT or another artificial intelligence (AI) chatbot, assuming that it’s the fastest way to get the job done. However, Excel offers several automation features that can handle a wide range of data tasks with impressive speed. The challenge is that it’s not always obvious which tools to use or where to look for them. Once you understand which feature fits each task and know exactly where to find it, you won’t need to keep opening ChatGPT and similar tools to automate work that Excel can already handle on its own. Related I Let AI Handle Complex Excel Formulas for Me—You Should Too Let AI handle the syntax so you can focus on results. Power Query Import, clean, and reorganize without repeating yourself If you regularly pull data from external files, databases, or web sources and then spend time cleaning it up — splitting columns, fixing data types, and merging tables — Power Query is the feature designed to automate these tasks. …


