Free online financial modelling course material

We make free training samples available online for you.

Is it crazy to give this stuff away for free? We don’t think so. Sometimes it’s helpful to give potential course delegates a clearer idea of the kind of material they might be covering. We’ve found that it’s also handy to have chunks of training material available online because sometimes we want to refer delegates to it during a training course. Having the training material online means it’s always up to date when people come back and want to look at it after a course.

You’re welcome to work your way through the free training course material. You won’t already be intimately familiar with it though. Sorry but we expect you’ll probably find the whole experience a bit like trying to get your training from Wikipedia. You’ll find it a bit disjointed, it’s not 100% complete, it lacks structure and it’s a bit hard to work through without a friendly someone guiding you along.

That’s where the live taught courses come in.

 

Personal macro workbook

If you want to make a macro available to all worksheets in Excel that’s where you’ll need to store your macro. Project explorer P also stands for “Project explorer”. See under M for “Module“. If you open the project explorer...

Macro

A “Macro” is a piece of computer “Code“. In Excel a macro stores a sequence of repetitive actions in Excel as computer code so you can automate them by playing them back/ running the computer code. Macros help you automate Excel. A macro is a...

Loop

Imagine you wanted to work to the bottom of a column of data in Excel until you reached the bottom. A “Loop” would help you do that. Loops are really handy. Macro loops allow you to repeat a certain action or actions until a particular condition is met...

Keyboard shortcut

Did you remember that you can assign a macro to a “Keyboard shortcut” (i.e. you can start a macro running after pressing a short sequence of keys on your keyboard)? We showed you how to do that here: run a macro. You can also set a macro to run after...

If then else

“If then” statements do the same kind of job as Excel’s if funtions assuming you’re familiar with those. In VBA they make your macro do something if a particular condition is met. If the condition is not met, then your macro does something...

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”...
Page 20 of 86« First...10...1819202122...304050...Last »