Microsoft Advanced Excel: Advanced Training

• Master Microsoft Excel and many of its advanced features
• Carry out regular tasks faster than ever before
• Build Cash Flow statements
• Build Valuation models from scratch
• Design professional and good-looking advanced charts
• Become one of the top Excel users in your team
• Discover how to value a company
• Create models with multiple scenarios

Advance Charting:

• Knowing how to pick the right type of chart.
• Ability to converge various types of charts into one.
• Use features like in-cell charts and conditional formatting charts.
• Ability to setup dynamic and interactive charts.
• Use spark lines.

Advanced excel skills:

There are numerous advanced excel skills imparted to students including:

• Pivot charts.
• Pivot tables and pivot reporting
• Data validation
• VBA and macros
• Using excel productively.
• Data tables, simulations, and solver.
• Integrating excel with other tools and optimizing excel

Who this course is for:

• Any individual who has basic knowledge of excel and is willing to grow.
• Any individual who meets the course prerequisites.
• Any graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.
• Any business and finance practitioners who are eager to improve their Excel and Financial Modeling skills