With the right prompts, natural language AI can create complex macros to automate processes like data cleansing, data summarization, carrying out intricate computations, building PivotTables, and producing unique reports. Usually, most of these steps are tediously repeated in the same order month after month for years. When working with large amounts of data, this can be time-consuming and error prone. Another typical procedure entails obtaining data, cleaning it, appending data from other systems, and then summarizing it with the aid of PivotTables and other tools. It is common practice to download data from one system into a spreadsheet, edit and clean it, and then upload it into another system. With these advancements, we can now use GPT-4 to take on bigger macro writing challenges. Additionally, GPT-4 accepts longer and more detailed prompts. The more recent version has better comprehension skills and better skills for writing and debugging software. ChatGPT-4 (GPT-4), launched in March 2023, is reportedly trained on more than 100 trillion data points, compared to 175 billion for GPT-3.5.

Williams used ChatGPT-3.5 (GPT-3.5) for that article. Kelly Williams, CPA, wrote about her early use of ChatGPT in the January 2023 JofA article ' Using ChatGPT With Excel'.

This can increase productivity and free up time for work on more value-add projects. But with the introduction of advanced natural language artificial intelligence (AI) technology, practically anyone with a little programming experience can create complex scripts that automate many repetitive tasks. Until now, only elite spreadsheet users had the skills to write macros to streamline repetitive tasks. Many finance and accounting departments rely on spreadsheets to complete critical tasks.

Excel vba open ms project file