Master Index/Match in Excel

Master the power of Microsoft Excel’s Index/Match function.

26th January 2023 – FREE

12:00pm – 1:00pm (CET)
11:00am – 12:00pm (UK)

About this Workshop

Are you interested in speeding up data retrieval in MS Excel in a resilient way? You’ve come to the right place!

In this hour-long online livestream, we will look at how the Index/Match function works, its versatility in retrieving business data for analysis and its place in the field of financial modelling and data analytics.

We will explore four main aspects of Index Match:

  • Its core functionality
  • Its ability to retrieve any data point with ‘unique codes’ (you create)
  • Its role in enabling the creation of powerful management dashboards for decision making
  • How important it is to financial modelling and how Leap Finance Academy can help you secure or advance your career in Finance

All in real time – taught by an expert Financial Modeller and C-suite Private Equity professional so you can ask questions and build your online network by interacting with fellow classmates and your expert instructor.

Who is it for?
  • Any undergraduate or postgraduate student dealing with data in MS Excel (Statistics, Marketing, Finance, Business etc.)
  • Finance or Business postgraduates or undergraduates including MBA students
  • Any incoming or current Finance professional (Investment Banking, Audit, Private Equity, Corporate Finance, Accounting etc.)
  • Anyone interested in learning techniques that speed up data analysis or analytics in MS Excel!
Takeaways
  • Learn how Index / Match can be more useful than Vlookup/Hlookup/Xlookup in MS Excel
  • Discover its use cases and its ability to automate data retrieval with unique data codes
  • Apply it to create analytical dashboards for business managers (or for your boss!)
  • Learn its importance in financial modelling and how you can use it to advance your career in Finance faster
Preparation / Pre-requisites
  • This workshop is delivered completely online and requires a computer with a strong internet connection
  • It is open to all participants – no skills are required for the workshop

NOTE: some domains may block our automated email with the invitation details to the workshop – if you do not hear from us within 1 hours of your registration attempt, please reach out to info@leapfinanceacademy.com and we will send you the invitation details right away!
This webinar will not be recorded.

Sign Up for our FREE webinar today!

About your host

Nikhil Gupta – CFO, Kadens Capital

  • Responsible for overseeing the Investment activities of Private Equity funds that invest in Western Europe
  • Has completed over €3.5bn in Private Equity Real estate transactions since 2010
  • Prior to joining Kadens Capital, Nikhil worked for 12 years at Peakside Capital, a top 5% Private Equity investor in Europe

Take a look at what our clients are saying:

A very pedagogical instructor, always available and willing to transfer his knowledge on a practical level.

Anne-Sophie Tran
J.P. Morgan, Banking Summer Analyst

I’ve taken other finance courses but this hands-on course was different. It had an impact.

Thibaut Laberty
Silver Lake Partners, Private Equity Analyst

Thanks to Nikhil’s course… I managed to outperform my peers during my summer internship at GIC and to be enrolled as a Private Equity Analyst at Rothschild & Co/Five Arrows.

Clement Commaret
Rothschild & Co, Analyst

Sign Up for our FREE webinar today!