Intensive Finance Series: Spreadsheet Skills
Intensive Finance Series: Spreadsheet Skills for Finance
Discover the powerful spreadsheet functions, tools and features that can be used in a variety of practical finance settings.
Registration Options
Register by fax or email
You will need to download this registration form
-
Download fax or email registration form
PDF, 131kB
Downloads
-
Program Outline
PDF, 654kB -
Course Sample
PDF, 912kB
Related links
Program Summary
| TITLE: | Spreadsheet Skills for Finance |
| CE: |
Up to 14hrs |
| FEE: | See program outline |
| Sydney June 27-28, 2012 | 9:00am - 5:00pm |
About the Speaker
Alex Palfi, Principal, Tykoh Group Pty Ltd
Alex Palfi is a Principal of Tykoh Group Pty Ltd – an Australian based training provider specialising in tailored one and two day workshops on technical finance and business topics.
Prior to setting up Tykoh Alex was a Division Director at Macquarie Group in Sydney. In that role he developed a range of finance workshops and presented those in Australia and at other international locations. Those workshops focused on financial modelling, valuation, derivatives, credit risk and Visual Basic programming.
In earlier roles Alex worked for a number of financial services organisations as a financial software developer and lectured at Technical Institutes in New Zealand in programming and electrical engineering. Alex’s university qualifications are in engineering. He obtained Masters and Bachelors degrees in Electrical Engineering from the University of Canterbury in New Zealand.
About this program
Spreadsheets are a powerful tool and this one-day program will show you how the features they contain are often underused or misinterpreted. This intermediate to advanced course is designed for those who wish to apply spreadsheet skills and techniques to building, maintaining and enhancing a broad range of financial applications. To participate, you’ll need prior exposure to the basic formula and functions of spreadsheets.
What will you learn?
You’ll learn how to create a well designed spreadsheet and how good design skills, together with a mastery of functions, leads to efficient, user-friendly, maintainable, robust, responsive and error-free financial spreadsheets. Discover:
- Arithmetic, logical, referencing, aggregation, ranking and text manipulation functions;
- How to choose the best function for a given application;
- The use of arrays for calculations in a single cell;
- The seven sources of error messages and why these occur;
- The finance principles and assumptions underlying the main spreadsheet functions;
- Useful keyboard shortcuts;
- How to use data validation;
- Form controls that improve workbook user interfaces;
- How to apply Goal-seek; and
- How to incorporate Visual Basic macros to automate repetitive tasks.
Testimonials
The facilitator is an excellent resource. Thanks for the opportunity to complete this course.
Very clear and concise, excellent materials and very hands-on.
This was the most useful workshop I have attended in some time. I feel that I have gained sufficient skills to take back to the workplace and I now have much greater confidence with regard to excel.