Course Description

This intensive course is designed to develop a sparkling financial modeling skills through actual hands-on construction of a model by using Microsoft Excel 2013. The end goal of the course is to give you a practitioner’s view of financial modeling by blending accounting, corporate finance and Excel skills.

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 report designers, finance, accounting and advanced Excel users.

Course Content

• Charting Techniques
• Visualizing Data with Conditional Formatting
• Visualizing Data with Sparkline
• Analysing Data Dynamically by Using PivotTables
• Advanced PivotTable Features
• Power View