Finance course

You can search our site for finance training topics.

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

 

Excel’s TRUE/ FALSE checks

This course lesson is all about the usefulness of TRUE/ FALSE checks in Excel. Did you know that you can extract the simple logic test from an If formula (= the first box in the “Shift” “F3” insert formula dialog) and that it stands alone? You...

Index formula

Earlier on in the course we cover a couple of ‘data picking’ solutions with you: the Vlookup formula and the Choose formula where you’ve got a simple data set. Next we add Index to the mix but as it starts to become hard to remember all the various...

Custom formatting

Excel gives us a bunch of standard formats for numbers. Try “Ctrl” “Shift” “5” to apply Excel’s % format to a number, or “Ctrl” “Shift” “1” to reapply Excel’s general number...

Model switching

In this course lesson we introduce a few ideas and thoughts about how to switch sections of a model on and off, building in flexibility. The big mistake we’ve seen people make is building individual If formulas into cells or lines in a model. That means every...

Excel’s scenario manager

If you’ve got Excel open, find the “Data” tab and have a look under “Data Tools”, “What-If Analysis”. Under there you’ll see goal seek. We’ve said that’s a critical piece of Excel functionality that you need...
Page 10 of 113« First...89101112...203040...Last »