Excel 2010 for finance: From layout to advanced formulas
In this training, we will introduce a logic approach for using Excel 2010 for finance. In addition to the explanation of classical functions in Excel 2010, we will insist on the logic for constructing files, for using formulas and for checking data.
The training is divided in two independent and complementary modules and will be based on a practical approach and exercises. A detailed training support will be given for each module in order to easily find out all the steps introduced during the exploration.
Monday 23rd May 2011
Module 1: 9:00 to 13:00
Module 2: 14:00 to 18:00
Objectives and Contents:
- Use Excel 2010 as a powerful software and not as a simple board.
- Define a logical framework for using Excel.
- Develop logical and readable Excel workbooks and documents.
- Use formulas for improving automation – from the simple sum to personalized macro functions.
Please register before May 21st and send back registration form to firstname.lastname@example.org