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