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...
AMT's Financial Training Portal

AMT Online

Distance training made easy!

AMT provides online testing, recorded sessions and learning materials through our financial training portal, AMT Online.

AMT Training's Public Courses
Contact Us Now