Instructor Led Formatting Training Classes in Australia
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From Navigator Project Finance
Project Finance Modelling
... of Circular References
* Applications of Conditional Formatting
* Application of Data Validation (incl offsheet list selection)
Smart Functions
* Discussion around recommended functions and their applications
* SUMIF/COUNTIF/ SUMPRODUCT/ DATE FUNCTIONS
* + takeaway file of demonstrations
* Array Functions {Average()}, {Min()},{Transpose()}
Sensitivities /Scenarios
more...
... of Circular References
* Applications of Conditional Formatting
* Application of Data Validation (incl offsheet list selection)
Smart Functions
* Discussion around recommended functions and their applications
* SUMIF/COUNTIF/ SUMPRODUCT/ DATE FUNCTIONS
* + takeaway file of demonstrations
* Array Functions {Average()}, {Min()},{Transpose()}
Sensitivities /Scenarios
more...
Financial Modelling Fundamentals
...D/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
more...
...D/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
more...
