Updated Excel Spreadsheet Techniques and Financial Applications

15. Updated Excel Spreadsheet Techniques and Financial Applications

Introduction:

This course is introduced to you by the International Academy of Human Resources Development (IAHRD). Our courses are specially designed to meet your needs, explained to you by experts with a long experience in the field. Excel plays a key role in many sectors and is the most used spreadsheet program in many fields. This course provides a complete, high-level education that will equip you with the skills needed to respond to the challenges presented by the manipulation of ­financial data. You will learn the essential advanced skills that will definitely increase your productivity and efficiency in the organization. This course will focus on the practical side of excel spreadsheet techniques.

Objectives:

After attending this course, participants will be able to:

1. Work efficiently with related worksheets and workbooks
2. Gain practical knowledge in excel spreadsheets techniques.
3. Understand the different usages of excel.
4. Use spreadsheet skills effectively for advanced ­financial applications

Content:

Module 1:

1. Introduction to excel.
2. The importance of excel.
3. Who should be using excel spreadsheet?
4. How can we import data intro a spreadsheet?
5. Case study.

Module 2:

1. Comments and cells naming.
2. Using pivot tables to summarize data.
3. Advanced pivot tables.
4. Spreadsheets and data linking.
5. Case study.

Module 3:

1. How to format spreadsheets?
2. Different mathematical functions and their usages.
3. Excel macros and reference.
4. How to customize charts?
5. Case study.

Module 4:

1. Using statistical and database functions.
2. Using fi­nancial and logical functions.
3. Datatables and scenarios applications.
4. Case study.

Module 5:

1. What about auditing, sharing and protecting spreadsheets?
2. Overall Financial analysis.
3. Cost and capital.
4. Applying capitalbudgeting techniques.
5. Capital budgeting valuations.
6. Case study.

Module 6:

1. Essentials of risk analysis.
2. Conditional formatting.
3. Data validation.
4.  

Who Should Attend?

Allfi­nance professionals who are looking to use advanced Excel techniques.