O'Reilly logo

Tips & Tricks for Excel-Based Financial Modeling, Volume II by M.A. Mian

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 4

Automating Worksheets

In this chapter we will discuss the use of Macros and Visual Basic for Application (VBA), that is, automating the execution of tasks requiring many repetitive steps.

Macros and VBA

Many times we have to perform repeated tasks and each time we have to go through clicking on various tabs and options to complete the task. Macros are basically a recording of mouse clicks, keystrokes, and mouse movement in the worksheet. Macros remember the steps we have to follow in completing a certain task. Lot of times we use Macros to solve problems requiring SOLVER or Goal Seek. Macros can also accommodate nested IF statements in a closed loop.

The Macros button is under the View tab on the Excel Ribbon or under the Developer ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required