Financial Training Courses
Specialist Training Courses
Financial Products
Technical Updates
AMT's Technical Updates provide a leading insight into the world of finance and current affairs. Find out how we are solving new challenges in the financial sector.
Bloomberg Shortcuts: Avoid SURP, Increase RV and Climb the LMX - May 2012
At AMT we love to help you improve your efficiency at the desk, for example teaching the best keyboard shortcuts in Excel. Shortcuts, however need not stop at Excel, for example systems such as Bloomberg rely heavily on the keyboard. So to help Blo...
The Essential Productivity Enhancers for Windows 7 - March 2012
Give your mouse a rest!
As Windows 7 permeates the corporate environment we have compiled the critical productivity enhancers to keep you ahead. Save more than a few minutes over the course of your day on the desk.
The Desktop
The Desktop
A few peop...
International and US Accounting Changes that Impact Valuation - February 2012
There are several accounting changes in the pipeline that could have a significant impact on value calculations. We've identified the upcoming ones that might be critical for you. Make sure you are ahead of the curve for leases, pensions and financia...
Self Referencing IFs: A Compelling Alternative to Excel's Data Table Feature - January 2012
A traditional approach for presenting scenarios in Excel is to use Excel’s Data Table feature. However, Data Tables present a number of issues in financial models:
Speed: a model using multiple data tables will run slowly because the Data Table fea...
Dubious Accounting Measures: The Hard Landing? - November 2011
Earlier in the month the FT Lex column published an article on the Indian airline Kingfisher. This inspired us to take a closer look at Kingfisher's financials with some interesting findings!
An October 2011 management presentation estimated the EBIT...
Presenting Different Scenarios with Self Referencing IFs - October 2011
Self referencing IF statements allow you to present the results of multiple scenarios regardless of the individual scenario being run in the model.
Top 10 Adobe Reader Keyboard Shortcuts - September 2011
Most bankers are familiar with using Excel shortcuts to maximize their productivity. But why stop there when you can make similar gains in other applications like Adobe Reader!
Here are some of AMT’s top keyboard shortcuts in Adobe Reader (all vers...
A Tale of Two Companies - August 2011
This is a story about two companies, Company X and Company Y. The CEOs of the two companies Mr. X and Mrs. Y are considering various strategies to achieve the highest valuation multiple. They didn’t quite know whether to pursue strategies that woul...
Excel Macro Security 2003 vs 2007/2010 - July 2011
Excel macro security protects your computer against viruses that may be passed to your computer via programming in Excel Macros. We've recently launched an Excel Add-In for bankers, which is why we thought it pertinent to publish this article as on...
Excel Macro Security 2003 vs 2007/2010 - July 2011
Excel macro security protects your computer against viruses that may be passed to your computer via programming in Excel Macros. We've recently launched an Excel Add-In for bankers, which is why we thought it pertinent to publish this article as on...



