You can search our site for finance training topics.
Or you can find out more about our finance course training:
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...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...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...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...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...