Financial Modelling with Excel and VBA

Designed to show how to use Excel and the rest of the Office suite to solve business problems, this reference offers an overview of Excel fundamentals and key features used in financial modelling. It also covers advanced financial functions, array formulae, charts, pivot tables and Visual Basic for Applications (VBA).

---

Designed to show how to use Excel and the rest of the Office suite to solve business problems, this is an invaluable reference for both business users and students alike.Not only does it provide a comprehensive overview of Excel fundamentals and key features used in financial modelling - it also covers advanced financial functions, array formulae, charts, pivot tables and Visual Basic for Applications (VBA), and provides advanced modeling techniques that can be applied to the reader's unique situation.