• 0060182929791
  • info@iahrd.com
  • Home
  • courses
  • Updated Excel Spreadsheet Techniques and Financial Applications

Updated Excel Spreadsheet Techniques and Financial Applications

Updated Excel Spreadsheet Techniques and Financial Applications

ACCOUNTING, FINANCE AND BANKING


  1. 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.

 

Istanbul

# Price ($) From
d-m-Y
To Action
1 3,250 27-01-2019 31-01-2019 Enquire
Course Code:241
2 3,250 24-03-2019 28-03-2019 Enquire
Course Code:242
3 3,250 26-05-2019 30-05-2019 Enquire
Course Code:243
4 3,250 28-07-2019 01-08-2019 Enquire
Course Code:244
5 3,250 22-09-2019 26-09-2019 Enquire
Course Code:245
6 3,250 24-11-2019 28-11-2019 Enquire
Course Code:246

Kuala Lumpur

# Price ($) From
d-m-Y
To Action
1 2,950 21-01-2019 25-01-2019 Enquire
Course Code:499
2 2,950 18-03-2019 22-03-2019 Enquire
Course Code:500
3 2,950 20-05-2019 24-05-2019 Enquire
Course Code:501
4 2,950 15-07-2019 19-07-2019 Enquire
Course Code:502
5 2,950 16-09-2019 20-09-2019 Enquire
Course Code:503
6 2,950 18-11-2019 22-11-2019 Enquire
Course Code:504

London

# Price ($) From
d-m-Y
To Action
1 4,500 14-01-2019 18-01-2019 Enquire
Course Code:763
2 4,500 11-03-2019 15-03-2019 Enquire
Course Code:764
3 4,500 13-05-2019 17-05-2019 Enquire
Course Code:765
4 4,500 08-07-2019 12-07-2019 Enquire
Course Code:766
5 4,500 09-09-2019 13-09-2019 Enquire
Course Code:767
6 4,500 11-11-2019 15-11-2019 Enquire
Course Code:768

Amsterdam

# Price ($) From
d-m-Y
To Action
1 4,500 28-01-2019 01-02-2019 Enquire
Course Code:910
2 4,500 27-05-2019 31-05-2019 Enquire
Course Code:911
3 4,500 23-09-2019 27-09-2019 Enquire
Course Code:912

Athens

# Price ($) From
d-m-Y
To Action
1 4,500 21-01-2019 25-01-2019 Enquire
Course Code:1042
2 4,500 20-05-2019 24-05-2019 Enquire
Course Code:1043
3 4,500 16-09-2019 20-09-2019 Enquire
Course Code:1044

Barcelona

# Price ($) From
d-m-Y
To Action
1 4,500 14-01-2019 18-01-2019 Enquire
Course Code:1174
2 4,500 13-05-2019 17-05-2019 Enquire
Course Code:1175
3 4,500 09-09-2019 13-09-2019 Enquire
Course Code:1176

Copenhagen

# Price ($) From
d-m-Y
To Action
1 4,500 07-01-2019 11-01-2019 Enquire
Course Code:1306
2 4,500 06-05-2019 10-05-2019 Enquire
Course Code:1307
3 4,500 02-09-2019 06-09-2019 Enquire
Course Code:1308

Frankfurt

# Price ($) From
d-m-Y
To Action
1 4,500 29-04-2019 03-05-2019 Enquire
Course Code:1438
2 4,500 26-08-2019 30-08-2019 Enquire
Course Code:1439
3 4,500 30-12-2019 03-01-2020 Enquire
Course Code:1440

Madrid

# Price ($) From
d-m-Y
To Action
1 4,500 29-04-2019 03-05-2019 Enquire
Course Code:1570
2 4,500 26-08-2019 30-08-2019 Enquire
Course Code:1571
3 4,500 23-12-2019 27-12-2019 Enquire
Course Code:1572

Milan

# Price ($) From
d-m-Y
To Action
1 4,500 22-04-2019 26-04-2019 Enquire
Course Code:1702
2 4,500 19-08-2019 23-08-2019 Enquire
Course Code:1703
3 4,500 16-12-2019 20-12-2019 Enquire
Course Code:1704

Munich

# Price ($) From
d-m-Y
To Action
1 4,500 15-04-2019 19-04-2019 Enquire
Course Code:1834
2 4,500 12-08-2019 16-08-2019 Enquire
Course Code:1835
3 4,500 09-12-2019 13-12-2019 Enquire
Course Code:1836

Paris

# Price ($) From
d-m-Y
To Action
1 4,500 08-04-2019 12-04-2019 Enquire
Course Code:1966
2 4,500 05-08-2019 09-08-2019 Enquire
Course Code:1967
3 4,500 02-12-2019 06-12-2019 Enquire
Course Code:1968

Stockholm

# Price ($) From
d-m-Y
To Action
1 4,500 01-04-2019 05-04-2019 Enquire
Course Code:2098
2 4,500 29-07-2019 02-08-2019 Enquire
Course Code:2099
3 4,500 25-11-2019 29-11-2019 Enquire
Course Code:2100

Vienna

# Price ($) From
d-m-Y
To Action
1 4,500 25-03-2019 29-03-2019 Enquire
Course Code:2230
2 4,500 22-07-2019 26-07-2019 Enquire
Course Code:2231
3 4,500 18-11-2019 22-11-2019 Enquire
Course Code:2232

Zurich

# Price ($) From
d-m-Y
To Action
1 4,500 18-03-2019 22-03-2019 Enquire
Course Code:2362
2 4,500 15-07-2019 19-07-2019 Enquire
Course Code:2363
3 4,500 11-11-2019 15-11-2019 Enquire
Course Code:2364