Duration
2 days
Time
9am - 5pm
Schedule
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.
Prerequisites
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