
This includes filtering through different situations that may impact outcomes differently. With Visual Basic for Applications, you can create various portfolio-management and investment scenarios. You can use VBA in Excel to create and maintain complex trading, pricing, and risk-management models, forecast sales and earnings, and to generate financial ratios.

Macros allow financial professionals-whether accountants, commercial bankers, investment bankers, research analysts, salesmen, traders, portfolio managers, clerks, or administrators-to analyze and adjust huge amounts of data quickly.
