Excel financial modelling course training
Our 3 day financial modelling course is designed as a first program for people who would like an opportunity to improve their ability to model cash flows in Excel.
This is our most popular course.
The course is conducted in a work shop format, with the emphasis on “learning by doing”.
During the course delegates work in teams to conduct financial modelling work from scratch.
In a recent post we were looking at how failing on some of the modelling basics can end up being a bit of a giveaway. In that case we were looking at how a minor formatting inconsistency (and inattention to detail) in the outputs sheet, something that we quickly... If you’re a fan of Excel names there are some great shortcuts that help you name cells in Excel. “Ctrl F3” for naming a cell If you select a cell in Excel you can assign a name to that cell by pressing “Ctrl F3” on your keyboard.... Imagine you wanted to use a formula to reference tab names in your Excel model. Perhaps the context is creating a contents page in your Excel financial model. Here we’ve got a formula you can copy that will reference the active sheet tab name in a specific cell... Excel shortcuts are great. With practise they help you automate what you’re doing with your modelling. With time you can get to the point where it feels like you’re doing two things at once. Using a shortcut to do something (almost) automatically, plus... Here’s a trick that will help you navigate more quickly around a big spreadsheet. Hide the columns out to the right. Hide the spare rows beyond the bottom. That means you will be able to use “Ctrl” and your arrows to jump quickly around your model.... Home > Course > Financial modelling July Find out more about thefinancial modelling course This modelling training course is designed as a first program for people who would like an opportunity to practise and improve their ability to... Page 1 of 4912345...102030...»Last »