|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Programs
| New Training Providers
| Site Map
| Promote Training
|
Training Keywords
|
| Training Providers
| Regions
| Training Search
| Advertise Training Programs
| Login
|
||||||||||||||||||||||||||||||
Provided by: Navigator Project Finance
Financial Modelling FundamentalsClick here for more information or to take this course
Training Provided by Navigator Project Financef you want to improve your understanding and use of Excel as an important tool to work more efficiently then this is the course for you! This two-day interactive workshop will give your Excel knowledge a kick-start, as we work through the key functions and applications for the financial sector.The focus during the course will range from file management and presentational features to more advanced functions, including named ranges and graphs. This highly-interactive environment you will be working on your own laptop ensures that the knowledge is quickly absorbed, and you can take away the new knowledge in one Excel workbook. On completion of this course you will feel more confident when working with Excel on a daily basis. This also serves as a great foundation before attending the Project Finance Modelling course. Day one The Excel environment * Workbooks * Worksheets * Toolbars * Menus Working with files * Creating/Opening * Naming convention * Back-ups Excel formulas * SUM * IF * AND/OR * CHOOSE * Fixed/Relative anchoring ($/F4) Formatting * Borders/Patterns * Fonts/Colours * Alignment/Number Formats More efficient keyboard navigation * Ctrl Page Up/Page Down * Shift to select * Ctrl+Shift to select section Macros * Record simple macro * Link to button/object * Run Macros Review spreadsheets * Tracing Dependents * Tracing Precedents Day Two Print settings * How to set up page breaks to * print on one or several pages * Adjusting zoom level * Headers/Footers Automated fill * Generate list 1 10, etc Named ranges * Insert Named Ranges * Modify * Delete * Go to Named Range (shortcut) Graphing fundamentals * Source data * Different chart types * Labels * Number formatting * Formatting Grouping /outlining * Improve the presentation of your spreadsheet * Group lines/columns Improve Excel settings * Edit directly in cell * Iterations * VBA Toolpak What to avoid * Size blow-out in Excel documents * Unprofessional graphs * Inconsistent formulas * Complicated formulas * Certain types of formulas * External links Additional tips * Using the drawing toolbar * Create a graph in one key stroke! Training Avaliability and Delivery
Related Keywords: excel formulas menus workbooks worksheets toolbar financial modelling project finance Training Program DetailsDebt Service Reserve Account ("DSRA")- with a focus on transparency
2D Data Table and Project Finance Applications Straight Line Depreciation (without using matrices) Solving a multiple IRR problem Monte Carlo simulation (using Crystal Ball TM) Discussion: Advanced debt repayment (modelling Inverse Order of Maturity (IOM), pro-rata repayments) 1 Day - Case Study (Mining or Oil & Gas) About Navigator Project Finance - Training Provider
Navigator Project Finance - Navigator Project Finance : Financial Modelling for Intelligent Teams
Navigator is the market-leading supplier of global project finance modelling solutions:
* bespoke financial modelling
* comprehensive training courses
* independent model reviews
* consulting services
Navigator understands every stage of the global project finance process and have a methodology proven by...
More Financial Modelling for Project Finance Training from Navigator Project FinanceClick here for more information or to take this course | ||||||||||||||||||||||||||||||
|
| ||||||||||||||||||||||||||||||
| Training Directory | New Training Programs | New Training Providers | Search | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 05/13/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|