Training The Street (TTS): Excel Workshop

During the session, TTS will cover the following information. As seating is extremely limited, please only register if you are able to attend. 

Working with Client Data:

• Text to columns
• Text functions within Excel: LEFT, RIGHT, UPPER, LOWER, CONCATENATE

Analyzing Data:

• Lookup functions: VLOOKUP, HLOOKUP
• INDEX and MATCH Functions
• Analyzing data using SUMIF, COUNTIF, and Nested IF functions
• Pivot Tables

Scenario Analysis:

• Sensitivity analysis including data tables
• Conditional formatting
• Scenario analysis using CHOOSE & OFFSET functions
• Utilizing “named” cells

Macros and User Friendly Tools:

• Introduction to macros
• Introduction to Visual Basic for Applications (VBA)
• Creations of basic print macros and editing of basic VBA code
• Insertion of a “print button”

Tickets are Free for GFA members and $20 for non GFA members. Tickets are non-refundable. Breakfast and lunch will not be served. 

Graduate Finance Association | Website | View More Events

Contact the organizers