Advanced Excel Training

You will learn how to organise, manipulate, and analyse data using pivot tables, Power Pivot, lookup functions, date functions, etc. The course covers data formatting techniques like conditional formatting, what-if analysis, and decision-making functions. Participants will also learn to load data from various sources using Power Query, build advance dashboards, and automate tasks with macros and VBA programming. This course is designed for student and professionals looking to master complex data analysis and improve workflow efficiency.