Microsoft Excel

Program Duration - 3 Months | Platform – Online / Classroom

Live Class
Industry projects
1 - 1 Mentorship
Secure Placement Assistance

Course Overview

Learn the most advanced formulas, functions, and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our free Excel Fundamentals – Formulas for Finance. It is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research, and FP&A. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you’ve mastered them.

Curriculum

Advanced Excel

  • Basic Excel
  • Paste Special
  • Copying only formats
  • Converting formulas into values.
  • Doing mathematical operations.
  • Paste Link
  • Conditional formatting.
  • Advanced Filtering.
  • Data Consolidation
  • Data Validation.
  • Purpose of data validation.
  • Mathematical Functions.
  • Look-up Functions.
  • Text Functions.
  • Text Functions.
  • Data Visualization By Conditional Formatting.
  • What-If Analysis.
  • Pivot Table.

Tools Used

Key Features