Events

Central Texas Chapter Event
Facebook Twitter LinkedIn Email Share

WEBINAR - Advanced Excel Tools for Restructuring & Finance Leaders

Thursday, June 17, 2021 - Thursday, June 17, 2021
4:00 PM - 6:00 PM CST
Online Webinar
Austin, TX United States
Thursday, June 17, 2021 - 12:00 to 14:00
Add to Calendar

Advanced Excel Tools for Restructuring & Finance Leaders

Having strong working knowledge of Excel is essential for every business professional who works with data. While newer emerging technologies focused on Data Analytics & AI are useful, Excel continues to be the most widely used application for quick and structured data analysis particularly in the Finance function (financial forecasting, trend analysis, budgeting, MIS reporting, presentation dashboards).

Although Restructuring Professionals, CFOs and other Senior Finance Leaders are well-versed with basic Excel, the knowledge of advanced formulae and time-saving techniques can help effectively streamline painstaking tasks and turn raw data into presentable insights. This will ultimately boost efficiency, and the quality of analysis, enabling more informed decision making.

This workshop will provide an overview of advanced features of Excel that will increase the sophistication of the user's Excel usage and will help get work done better and faster. Among the topics to be discussed are:

• How to save time with keyboard hotkeys and shortcuts
• What are some of the most common mathematical and logical functions
• How and when to use advanced lookups and conditional functions
• How to slice and dice data with PIVOTs
• How to perform data sorting, data analysis and data validation
• How to audit complex formulas using Formulas features and Add-ins
• Overall best practices in Excel modelling

Please join TMA Central Texas Chapter to hear from Rob Hong, Rohit Nerurkar, and Matthew Robertson from Sapling Financial Consultants Inc. as they share their expertise and answer your “how"s and “when"s on some of the advanced Excel features. Rob will provide a general overview of the company and introduce the two main speakers, Rohit and Matthew.


Date:
Thursday, June 17, 2021

Time:

4:00-6:00 p.m. CST

Cost:
Members: $0
Non-Members: $0

Location:
Zoom Webinar (link will be sent to registrants the day of the event by Sapling Financial Consultants, Inc.)

RSVP by June 16, 2021




Presenters:

Rob Hong
Co-Founder & CEO 
Sapling Financial Consultants, Inc.

Rob Hong is a co-founder and the CEO of Sapling and has a wealth of experience in financial modelling. Previously, he worked at Artemis Investment Management, a $2 billion Bay Street investment firm, where he developed deep financial modelling skills through researching over 100 publicly-traded companies. He also oversaw more than $150 million of client money. After three years at Artemis, Rob joined KPMG LLP as a Senior Consultant in their Strategy & Operations group. There, he applied his modelling skills to a high-profile engagement while deepening his expertise in database analytics. Later, Rob joined Bell Canada Finance, supporting the Wholesale business unit, where he helped build many of the financial models setting wholesale pricing on big deals with telecom resellers.


Rohit Nerurkar, CFA
Consultant
Sapling Financial Consultants, Inc.

Rohit Nerurkar is a Consultant at Sapling and has 9 years of financial consulting experience. During his career, he has worked on financial modeling, data analytics, investment analysis, and valuation engagements and has assisted diverse set of clients including mid-market businesses, large enterprises, and private equity funds. Rohit began his career in 2012 with a boutique investment bank where he helped mid-market businesses build detailed financial models for raising private equity funding. Prior to joining Sapling, Rohit worked for a global advisory firm Aranca for over 5 years where he assisted large private equity funds and businesses on key financial decisions involving business expansions, investments and M&A deals. There, he applied his modelling and analytics skills building numerous dynamic models to a perform forecasting, valuations, return assessment and scenario testing.

Analyst
Sapling Financial Consultants, Inc.

Matthew Robertson is an Analyst at Sapling. Matthew graduated from the Commerce program at Queen’s University, where he focused on finance. During his time at Queen’s, Matthew worked as a finance Teaching Assistant as well as an analyst for a student run investment club. His professional experience includes an internship at Deloitte as a Financial Analyst Intern working to increase efficiencies in the operations department. Further, Matthew also gained knowledge and experience in real estate development and investments through a summer internship with Osmington, Inc.



For more information, contact:

Jenny Garcia
Chapter Executive
512-587-6972

UPCOMING EVENTS

Chapter Events

Jun
17
Central Texas Chapter Event

WEBINAR - Advanced Excel Tools for Restructuring &...

Austin, TX United States
Jun
16
Global Event

TMA Town Hall: ESG, Sustainable, and Impact Investing:...

,
Jul
13
Global Event

Restructuring Boot Camp: Two-Part Certificate Program -...

Oct
26
Global Event

The Annual: TMA's 33rd Annual Conference...

Nashville, TN United States

EVENTS CALENDAR

S M T W T F S
 
 
1
 
2
 
3
 
4
 
5
 
6
 
7
 
8
 
9
 
10
 
11
 
12
 
13
 
14
 
15
 
16
 
17
 
18
 
19
 
20
 
21
 
22
 
23
 
24
 
25
 
26
 
27
 
28
 
29
 
30
 
 
 
 

Benefits of a TMA Membership

"I've gotten a number of legitimate, 'for sure wouldn't have got the deal but for TMA' deals over the years."

-Brian Van Nevel, Spectrum Commercial Services Company, TMA Minnesota