Finance course

You can search our site for finance training topics.

Or you can find out more about our finance course training:

 

Help

You know you’re going to need a lot of it. Excel has a help function which you’re likely to be familiar with (“F1” when you have Excel open). VBA has its own specific help function. After you’ve got the VBA editor open (“Alt”...

GoTo

“GoTo” is a way of quickly rerouting the flow of your code say to an earlier point. When we discussed GoTo statements we showed you how to: Create a location for the GoTo statement. In the GoTo example we used the code EnterMoneyIn: but you could name the...

Formulas

The formulas that you’re used to using in Excel are available to you in VBA as well. In VBA they’re called “Worksheet functions” so see the definition there. See also “Operators“. Macros coverage from the financial modelling course...

Excel VBA macro

See under M for “Macro“. Macro, Excel macro, Excel VBA macro: they’re all the same thing. We’re just talking about a piece of computer code that you can record and run automatically to automate tasks in Excel. To confuse you even more there are...

Developer tab

This is a hidden tab within Excel that you have to open if you want to work with macros. All the fun starts when you open the “Developer tab” but it’s hidden by default – you have to unhide it. We show you how to do that here: open...
Page 30 of 113« First...1020...2829303132...405060...Last »