2 days

9am - 5pm

9 - 10 December 

Exploiting Financial Analysis Tools

Course Description

Some may wonder if it is possible to maintain data integrity in Excel, but experts say that the Excel data problem can be solved with a few tips.

This two days training introduces you to Microsoft Excel 2013 features in exploiting financial analysis. Participants will learn how to finding solutions with data table, gold seek and scenarios and resource optimization with solver as well as PivotTable.


Before attending this course, students should have experience:

  • A basic working knowledge of Microsoft Office Excel

Who should Attend?

This course is intended for data analysts, intermediate Excel users.

Course Content

  • Analysing Data Dynamically by Using PivotTables
  • Filtering, Showing, and Hiding PivotTable Data
  • Formatting PivotTable
  • Formatting PivotTables
  • Creating PivotTables from External Data
  • Analyzing data and alternative data sets
  • Working with Scenarios
  • Using Solver
  • Using Data Tables

Contact Us

Salutation: *
Invalid Input
Name: *
Invalid Input
Company Name: *
Invalid Input
Designation: *
Invalid Input
Email: *
Invalid Input
Office Telephone: *
Invalid Input
Mobile: *
Invalid Input
Interested In: *
Invalid Input
How did you find us: *
Invalid Input
Describe your request: *
Invalid Input
Validation: *
Validation RefreshInvalid Input