786                                                                       

System  -  Learn 1 

LEARN Financial Modelling and Spreadsheet Programming

How do I Learn To Improve Productivity,  Business Performance and Career Prospects ?

•   If you have any doubt as to what can be achieved with sophisticated financial modelling and spreadsheet programming see our real-life examples.
•   Using Excel Financial models and programs we analyse and publish technical charts for ALL Stocks in Dow Jones, Hang Seng HSI and NIFTY-50 Indices.
•   Each time prices change on screen LIVE Exponential Moving Averages are calculated for 100s of stocks and indices DJ30 N100 NIK225 HSI NIFTY-50.
•   Using Financial models and Excel programs we daily analyse 80 stock market indices from 32 countries and 3000 stocks worldwide in 3 main time zones.
•   We use spreadsheets with LIVE calculations of Exchange-traded and Over-the-Counter (OTC) American Depositary Receipts (ADRs) of 100s of stocks.
•   For Japan, China, Hong Kong and India: using Financial Models we compare LIVE ADR prices (in New York and London) with stock prices in Asia and the Far East.
•   Using Financial models and Excel programs we publish 1000 Worldwide Charts and update over 85 Technical Analysis Spreadsheets on the internet for round-the-clock use.
•   Use 12 Calculation models, 16000 lines of Excel code, 100 system files of AZMAT System on your PC and attend Daily LOW-COST Internet Seminars with author.
•   LEARN by attending Daily LOW-COST Internet Seminars with author of AZMAT System and by reading 200-page Online HELP manual that explains ALL the commands.
•   LEARN by studying the Investment Banking terms and formulae used in 12 Calculation Models. Some Financial Models are controlled by programs.
•   LEARN by observing 16,000 lines of un-protected Excel macro and VBA Program code: 200 commands, 500 programs and 100 system files.
•   LEARN by using any Command of AZMAT System in Step-mode; observe program code and files to see what effect EACH Line of instruction code has.
•   LEARN to write Program code that automatically adapts to current version of Excel (it has 3 Excel-menu versions). AZMAT System took over 8 man-years to develop.
•   LEARN by observing 3 ways of creating own menus that work with Excel versions 5 to 14. Thus YOU will be able to create Custom-Menus for YOUR Business.
•   LEARN by using AZMAT System normally as a typical user in an Investment Bank. It is a Risk Management and Front-Office Dealing Room System.
•   AZMAT System has 3 main Calculation Models: Asset Swap, Bonds and Floating Rate Notes (FRN) that are controlled by program. There are 9 other Calculation Models.
•   Asset Swap Model is very sophisticated but simple to use; it has been developed by incorporating wish-lists of Asset Swap Traders in many investment banks.
•   Asset Swap Model in AZMAT System enables a dealer to calculate in seconds Bond Market Price, LIBOR Swap Margin or Net Profit/Loss of a Swap.
•   Use Asset Swap Model for Interest Rate Swap and Cross Currency Swap. Calculations use relevant Yield Curves for Bond Currency and Swap Currency.
•   Aim of the course is to give you and your colleagues sufficient knowledge, understanding and confidence in Your OWN abilities to embark boldly on Excel Business projects.
•   Course aim is to help you and your colleagues LEARN from working examples how to design, develop and program Financial Models to solve Business problems.
•   LEARN Why, When and How to write and use DYNAMIC Excel Program code; while instructions are carried out Required Code is CREATED by Program and used.
•   Use AZMAT System on your PC: 100 system files; 200-page Online Help manual; 12 Calculation models; 3 Excel-menu versions and 16,000 lines of Excel program code.
  
  
  
  System  -  Learn 1 
  
  AZMAT System   Copyright ©  1997-2017  Micro Minerva Consultants Ltd.   All Rights Reserved.