Supercharge your productivity by using AI to write complex formulas, automate tedious workflows, and transform raw data into stunning reports in seconds.
This course details the integration of ChatGPT into Excel workflows to support formula generation, data management, and reporting tasks. It covers methods for drafting, troubleshooting, and documenting complex formulas, including those derived from screenshots or structured references. The material also addresses data cleaning techniques, the importation of external data formats like PDFs, and the development of refreshable preparation workflows using Power Query. Finally, it outlines the use of AI for performing sentiment analysis, generating data insights, and constructing professional charts and PivotTable reports.
Topics Covered:
6 activities • 32 videos • duration: 2h 30m

Excel Trainer, Microsoft MVP and Author | Founder of Computergaga
Alan Murray is an Excel trainer, Microsoft MVP and founder of Computergaga. Through his books, courses and popular YouTube channel, he helps professionals solve practical problems and work more effectively with Excel. He also organises the London Excel Meetup and speaks at international Excel events.