In the past we've looked at how to use Excel's Sumproduct function to pick data out of a table in Excel.
CPD courses for accountancy and finance
FTA Ltd is a provider of commercially focussed courses for accountants, bankers, lawyers and financial services executives.
Our training courses are rigorous, commercially relevant and up to the minute. On our courses delegate interaction, discussion and case-related problem solving are all key components of learning.
We only use experienced trainers who have a professional track record aside from their training work. Our people are happy to tell a few salient “war stories” and are instantly credible with their audiences.
Some might say that Excel functions are a little bit over-engineered. Like the car manufacturer that brings out a new model each year with a slightly better engine and up-rated suspension, Microsoft (bless it) has been bringing out new versions for years.
"How can I get better at Excel modelling"? This question was asked recently by a delegate on a financial modelling course. Here are some ideas.
What are the exact steps in a financial modelling build up? This question was asked recently by a delegate on a financial modelling course. Here's a suggestion regarding how to proceed.
Financial Training Associates Ltd answers a recent question raised on its financial modelling course. Here's the question, asked by a recent course delegate: "What do you do if you are asked to manipulate a large complex financial model? Here's the answer...
"What are some of the big issues facing the Private Equity industry?" This question was recently posed by a delegate on a private equity course run by Financial Training Associates Ltd.
FTA Ltd answers a recent question from a financial modelling course: “In valuation modelling, where does the terminal value formula come from?” This question was recently posed by a delegate on one of Fin
www.financialtrainingassociates.com considers the answer to the question asked by a delegate on a recent financial modelling course: “How can I model a more complicated transaction such as merger, acquisiti
The question: what are some of the big issues facing the Private Equity industry?
The question: how could a seller prepare for a debate on working capital? This blog post answers a technical question discussed recently on an FTA Ltd CPD course which covers negotiating big financial issues in corporate finance deals. When buying a business a