Microsoft Excel (Macro & VBA)

This course covers the development of Microsoft Excel programs using Visual Basic for Applications (VBA). Participants will gain knowledge in using Macros and various commands necessary for program development, streamlining complex tasks to make work more efficient and faster. This may involve using Form Input for easier understanding and interaction. Additionally, participants will learn advanced Pivot Table usage, cost calculation (Goal Seek), conditional cost calculation (Solver), and report presentation through Scenario Manager.