Excel for Business with AI: Intermediate

О курсе

Intermediate Excel with AI is a hands-on, intermediate-level course designed to help existing Excel users take their skills to the next level by creating more automated low maintenance worksheets. This course focuses on managing data and generating reports using a range of powerful Excel features combined with practical AI assistance. Across six structured modules, you will move from data preparation and transformation through to advanced analysis, automation, and interactive dashboard creation. Master data cleaning, conditional logic, and scalable modeling with tables and named ranges. You will learn lookup functions like VLOOKUP and XLOOKUP, then integrate these skills using PivotTables, Charts, and dashboards for professional reporting. Throughout the course, you’ll work through a realistic HR analytics scenario where you manage and analyse a large, imperfect staff dataset to uncover trends in hiring, workforce composition, and leave patterns. Along the way, you’ll also learn how to use AI tools as a thinking partner to build formulas, troubleshoot errors, and speed up your workflow. By the end, you'll design clean, automated workbooks, build dynamic reports with PivotTables, and present insights through interactive dashboards — skills that stand out in any data-facing role. The course is ideal for business professionals, HR, finance, and operations teams, analysts, and anyone who has basic Excel skills and wants to advance their skills, including the integration of AI tools, to work at a more advanced, confident level. Join professionals who are advancing their careers by working smarter with data.

Навыки, которые вы освоите

Учитесь у экспертов

Nicky Bull

Lecturer and Lead Content Designer